Exemplo n.º 1
0
    public function Insert(BoxEntity $oBoxEntity)
    {
        $sSql = 'INSERT INTO
					' . $this->sTableName . '
							(
							    job_queue_id
							  , box_number
							  , process
							  , process_status
							  , process_start_time
							  , updated
							)
				VALUES
							(
							    ?
							  , ?
							  , "import"
							  , "completed"
							  , NOW()
							  , NULL
							)
				 ON DUPLICATE KEY UPDATE
							id = LAST_INSERT_ID( id );';
        $aBindArray = array($oBoxEntity->getJobQueueId(), $oBoxEntity->getBoxNumber());
        $this->Execute($sSql, $aBindArray);
        $iBoxId = $this->oAdapter->getDriver()->getLastGeneratedValue();
        $oBoxEntity->setId($iBoxId);
        return $oBoxEntity;
    }