PHP Participant::insert方法代码示例

 public function createAction()
 {
     $expId = intval($this->getRequest()->getParam(Expertise::COL_ID));
     $keyId = intval($this->getRequest()->getParam(KeyTable::COL_ID));
     $expTable = new Expertise();
     $expRow = $expTable->find($expId);
     $keyTable = new KeyTable();
     $keyRow = $keyTable->find($keyId);
     if ($keyRow->count() != 0 || $expRow->count() != 0) {
         $keyArray = $keyRow->toArray();
         $expArray = $expRow->toArray();
         // create CE row
         $ceTable = new CalibrationExercise();
         $ceName = $expArray[0][Expertise::COL_SPECIES] . ' / ' . AuthQuery::getUserName();
         //TODO \r in der Datenbank
         $ceDescription = 'Area: ' . $expArray[0][Expertise::COL_AREA] . '\\r' . 'Subject: ' . $expArray[0][Expertise::COL_SUBJECT] . '\\r' . 'KeyName: ' . $keyArray[0][KeyTable::COL_NAME];
         $ceData = array(CalibrationExercise::COL_NAME => $ceName, CalibrationExercise::COL_DESCRIPTION => $ceDescription, CalibrationExercise::COL_KEY_TABLE_ID => $keyArray[0][KeyTable::COL_ID], CalibrationExercise::COL_EXPERTISE_ID => $expArray[0][Expertise::COL_ID], CalibrationExercise::COL_COMPAREABLE => 1, CalibrationExercise::COL_IS_STOPPED => 0, CalibrationExercise::COL_TRAINING => 1);
         $ceId = $ceTable->insert($ceData);
         // create participant row
         $partTable = new Participant();
         $partData = array(Participant::COL_CE_ID => $ceId, Participant::COL_USER_ID => AuthQuery::getUserId(), Participant::COL_NUMBER => 1);
         $partId = $partTable->insert($partData);
         // add all possible shown attributes
         $dbAdapter = $ceTable->getAdapter();
         $selectAttr = $dbAdapter->select();
         $selectAttr->from(AttributeDescriptor::TABLE_NAME);
         $selectAttr->orWhere(AttributeDescriptor::COL_GROUP . '=?', 'fish');
         $selectAttr->orWhere(AttributeDescriptor::COL_GROUP . '=?', 'image');
         $attrArray = $dbAdapter->fetchAll($selectAttr);
         $ceHasAttrTable = new CeHasAttributeDescriptor();
         foreach ($attrArray as $attr) {
             $attrData = array(CeHasAttributeDescriptor::COL_ATDE_ID => $attr[AttributeDescriptor::COL_ID], CeHasAttributeDescriptor::COL_CAEX_ID => $ceId);
             $ceHasAttrTable->insert($attrData);
         }
         //get images for exp/key
         $refQuery = new Default_ReferenceQuery();
         $images = $refQuery->getImages($expId, $keyId);
         // create imageset
         //			$selectImages = $dbAdapter->select();
         //			$imagesArray = $dbAdapter->fetchAll($selectImages);
         $imageSetTable = new CeHasImage();
         foreach ($images as $image) {
             $data = array(CeHasImage::COL_IMAGE_ID => $image, CeHasImage::COL_CALIBRATION_EXERCISE_ID => $ceId);
             $imageSetTable->insert($data);
         }
         //$this->render('form');
         $Redirect = new Zend_Controller_Action_Helper_Redirector();
         $Redirect->setGotoSimple('index', 'make', 'annotation', array(CalibrationExercise::COL_ID => $ceId));
     } else {
         throw new Zend_Controller_Exception('Error at craeting a new training Calibration Exercise.', 505);
     }
 }

 private function autoParticipateInCe($ceId, $userId)
 {
     $dbAdapter = Zend_Registry::get('DB_CONNECTION1');
     $part = new Participant();
     //SELECT MAX(column_name) FROM table_name where partceid=ceid
     $select = $dbAdapter->select();
     $select->from(Participant::TABLE_NAME, array('max' => 'MAX(' . Participant::COL_NUMBER . ')'));
     $select->where(Participant::COL_CE_ID . ' = ?', $ceId);
     $resultArray = $dbAdapter->fetchAll($select);
     $select->reset();
     //reader number for new CE part. is highest reader no. of old participents within CE + 1
     $readerNo = $resultArray[0]['max'] + 1;
     $data = array(Participant::COL_CE_ID => $ceId, Participant::COL_USER_ID => $userId, Participant::COL_NUMBER => $readerNo);
     $part->insert($data);
 }

 public function addparticipantsAction()
 {
     //inserts one or many selected participants
     if ($this->getRequest()->isPost()) {
         $this->defaultNamespace = new Zend_Session_Namespace('default');
         $ceId = $this->defaultNamespace->callingActionId;
         $userIds = $this->getRequest()->getParam(User::COL_ID);
         $dbAdapter = Zend_Registry::get('DB_CONNECTION1');
         $part = new Participant();
         foreach ($userIds as $userId) {
             //count participants in CE
             /*				$where = $part->getAdapter()->quoteInto(Participant::COL_CE_ID.' = ?', $ceId);
             				 $rowSet = $part->fetchAll($where);
             				 $numberOfPart = count($rowSet);*/
             //SELECT MAX(column_name) FROM table_name where partceid=ceid
             $select = $dbAdapter->select();
             $select->from(Participant::TABLE_NAME, array('max' => 'MAX(' . Participant::COL_NUMBER . ')'));
             $select->where(Participant::COL_CE_ID . ' = ?', $ceId);
             $resultArray = $dbAdapter->fetchAll($select);
             $select->reset();
             //reader number for new CE part. is highest reader no. of old participents within CE + 1
             $readerNo = $resultArray[0]['max'] + 1;
             $data = array(Participant::COL_CE_ID => $ceId, Participant::COL_USER_ID => $userId, Participant::COL_NUMBER => $readerNo);
             $part->insert($data);
         }
         $this->redirectTo('index');
     }
 }

 public function replicateAction()
 {
     $ceTable = new CalibrationExercise();
     $partTable = new Participant();
     $cehimTable = new CeHasImage();
     $imagesetTable = new ImagesetAttributes();
     $shownAtTable = new CeHasAttributeDescriptor();
     /**
      * calibration exercises
      */
     $ceArray = $ceTable->find($this->callingCeId)->current()->toArray();
     /**
      * participants
      */
     $partSelect = $partTable->getAdapter()->select();
     $partSelect->from(Participant::TABLE_NAME);
     $partSelect->where(Participant::COL_CE_ID . '=?', $this->callingCeId);
     $partArray = $partTable->getAdapter()->fetchAll($partSelect);
     /**
      * imageset
      */
     $cehimSelect = $cehimTable->getAdapter()->select();
     $cehimSelect->from(CeHasImage::TABLE_NAME);
     $cehimSelect->where(CeHasImage::COL_CALIBRATION_EXERCISE_ID . '=?', $this->callingCeId);
     $cehimArray = $cehimTable->getAdapter()->fetchAll($cehimSelect);
     /**
      * imageset definition
      */
     $imagesetSelect = $imagesetTable->getAdapter()->select();
     $imagesetSelect->from(ImagesetAttributes::TABLE_NAME);
     $imagesetSelect->where(ImagesetAttributes::COL_CE_ID . '=?', $this->callingCeId);
     $imagesetArray = $imagesetTable->getAdapter()->fetchAll($imagesetSelect);
     /**
      * shown attributes
      */
     $shownAtSelect = $shownAtTable->getAdapter()->select();
     $shownAtSelect->from(CeHasAttributeDescriptor::TABLE_NAME);
     $shownAtSelect->where(CeHasAttributeDescriptor::COL_CAEX_ID . '=?', $this->callingCeId);
     $shownAtArray = $shownAtTable->getAdapter()->fetchAll($shownAtSelect);
     /**
      * insert all data
      */
     $ceData = array(CalibrationExercise::COL_COMPAREABLE => $ceArray[CalibrationExercise::COL_COMPAREABLE], CalibrationExercise::COL_DESCRIPTION => $ceArray[CalibrationExercise::COL_DESCRIPTION], CalibrationExercise::COL_EXPERTISE_ID => $ceArray[CalibrationExercise::COL_EXPERTISE_ID], CalibrationExercise::COL_KEY_TABLE_ID => $ceArray[CalibrationExercise::COL_KEY_TABLE_ID], CalibrationExercise::COL_NAME => $ceArray[CalibrationExercise::COL_NAME], CalibrationExercise::COL_RANDOMIZED => $ceArray[CalibrationExercise::COL_RANDOMIZED], CalibrationExercise::COL_WORKSHOP_ID => $ceArray[CalibrationExercise::COL_WORKSHOP_ID]);
     $newCeId = $ceTable->insert($ceData);
     foreach ($partArray as $part) {
         $partData = array(Participant::COL_CE_ID => $newCeId, Participant::COL_EXPERTISE_LEVEL => $part[Participant::COL_EXPERTISE_LEVEL], Participant::COL_NUMBER => $part[Participant::COL_NUMBER], Participant::COL_ROLE => $part[Participant::COL_ROLE], Participant::COL_STOCK_ASSESSMENT => $part[Participant::COL_STOCK_ASSESSMENT], Participant::COL_USER_ID => $part[Participant::COL_USER_ID]);
         $partTable->insert($partData);
     }
     foreach ($cehimArray as $cehim) {
         $cehimData = array(CeHasImage::COL_CALIBRATION_EXERCISE_ID => $newCeId, CeHasImage::COL_IMAGE_ID => $cehim[CeHasImage::COL_IMAGE_ID]);
         $cehimTable->insert($cehimData);
     }
     foreach ($imagesetArray as $imageSet) {
         $imageSetData = array(ImagesetAttributes::COL_ATTRIBUTE_DESCRIPTOR_ID => $imageSet[ImagesetAttributes::COL_ATTRIBUTE_DESCRIPTOR_ID], ImagesetAttributes::COL_CE_ID => $newCeId, ImagesetAttributes::COL_FROM => $imageSet[ImagesetAttributes::COL_FROM], ImagesetAttributes::COL_TO => $imageSet[ImagesetAttributes::COL_TO], ImagesetAttributes::COL_VALUE => $imageSet[ImagesetAttributes::COL_VALUE]);
         $imagesetTable->insert($imageSetData);
     }
     foreach ($shownAtArray as $shownAt) {
         $shownAtData = array(CeHasAttributeDescriptor::COL_ATDE_ID => $shownAt[CeHasAttributeDescriptor::COL_ATDE_ID], CeHasAttributeDescriptor::COL_CAEX_ID => $newCeId);
         $imagesetTable->insert($imageSetData);
     }
     $this->redirectTo('index', array(CalibrationExercise::COL_ID => $newCeId));
 }