public function save(UploadRecord $record)
{
$this->_transaction->add("\n\t\t\tUPDATE\n\t\t\t\tproduct_page_upload_record\n\t\t\tSET\n\t\t\t\tproduct_id = :productID?i,\n\t\t\t\tunit_id = :unitID?in,\n\t\t\t\tconfirmed_at = :confirmedAt?dn,\n\t\t\t\tconfirmed_by = :confirmedBy?in\n\t\t\tWHERE\n\t\t\t\tpage_id = :pageID?i\n\t\t", ['productID' => $record->getProductID(), 'unitID' => $record->getUnitID(), 'confirmedAt' => $record->getConfirmedAt(), 'confirmedBy' => $record->getConfirmedBy(), 'pageID' => $record->getPageID()]);
if (!$this->_transOverride) {
$this->_transaction->commit();
}
}
public function create(UploadRecord $record)
{
$this->_transaction->add("\n\t\t\tINSERT INTO\n\t\t\t\tproduct_page_upload_record\n\t\t\t\t(\n\t\t\t\t\tpage_id,\n\t\t\t\t\tproduct_id,\n\t\t\t\t\tunit_id,\n\t\t\t\t\tconfirmed_at,\n\t\t\t\t\tconfirmed_by\n\t\t\t\t)\n\t\t\tVALUES\n\t\t\t\t(\n\t\t\t\t\t:pageID?i,\n\t\t\t\t\t:productID?in,\n\t\t\t\t\t:unitID?in,\n\t\t\t\t\t:confirmedAt?dn,\n\t\t\t\t\t:confirmedBy?in\n\t\t\t\t)\n\t\t", ['pageID' => $record->getPageID(), 'productID' => $record->getProductID(), 'unitID' => $record->getUnitID(), 'confirmedAt' => $record->getConfirmedAt(), 'confirmedBy' => $record->getConfirmedBy()]);
if (!$this->_transOverride) {
$this->_transaction->commit();
}
}
