/**
* 対象成果明細の親の成果を更新します
*/
public function Result_SeikaModifyItemPriceQuantityUpload_updateParentSeika($code, $seikaId, $updUserId)
{
$db =& $this->_core->getDBForUpdate();
$tables = new CampaignDbTables($code);
$name_seika = $tables->getTableName_Seika();
$name_seika_detail = $tables->getTableName_Seika_Detail();
// 成果の更新
// 成果のステータス、承認日は更新しない
EcSeikaManager::updateSeika($db, $name_seika, $name_seika_detail, $seikaId, $updUserId);
}
public function Result_ClientReportResultSeq_updateDetailCancel($code, $seikaId, $data, $updUserId)
{
// DB接続
$db =& $this->_core->getDBForUpdate();
// テーブル名称
$tables = new CampaignDbTables($code);
$name_seika = $tables->getTableName_Seika();
$name_seika_detail = $tables->getTableName_Seika_detail();
$sql = <<<SQL
update {$name_seika_detail} set
cancel_flg = ?,
upd_user_id = ?,
upd_time=now()
where
seika_detail_id=?
SQL;
foreach ($data as $detailId => $cancelFlg) {
$param = array($cancelFlg, $updUserId, $detailId);
$db->execute($sql, $param);
}
// 成果の更新
EcSeikaManager::updateSeika($db, $name_seika, $name_seika_detail, $seikaId, $updUserId);
}