Example #1
0
    public function Insert(ItemEntity $oItemEntity)
    {
        $sSql = 'INSERT INTO
					' . $this->sTableName . '
							(
							    folio_id
							  , item_number

							  , process
							  , process_status

							  , process_start_time
							  , process_end_time
							  , updated
							)
				VALUES
							(
							    ?
							  , ?

							  , \'import\'
							  , \'completed\'

							  , NOW()
							  , NOW()
							  , NOW()
							)
							ON DUPLICATE KEY UPDATE
								id = LAST_INSERT_ID( id );';
        $aBindArray = array($oItemEntity->getFolioId(), $oItemEntity->getItemNumber());
        $this->Execute($sSql, $aBindArray);
        $iItemId = $this->oAdapter->getDriver()->getLastGeneratedValue();
        $oItemEntity->setId($iItemId);
        return $oItemEntity;
    }