public function getSagyo($den_no)
{
$obj = new Sdptd04denpyosagyo();
$job_info = $obj->getData(['D04_DEN_NO' => $den_no]);
$job = [];
foreach ($job_info as $k => $v) {
$job[$k]['D04_SAGYO_NO'] = $v['D04_SAGYO_NO'];
}
return $job;
}
/**
* get job of order
* @param $order_id
* @return array
*/
public static function getJob($order_id)
{
$result = [];
$obj = new Sdptd04denpyosagyo();
$job = $obj->getData(['D04_DEN_NO' => $order_id]);
if (!empty($job)) {
foreach ($job as $k => $v) {
$result[] = $v['D04_SAGYO_NO'];
}
}
return $result;
}
public function deleteData($primaryKey = [])
{
$transaction = $this->getDb()->beginTransaction();
try {
if (isset($primaryKey['cus_no']) && isset($primaryKey['car_no'])) {
if ($obj = Sdptd02car::findOne([$primaryKey['cus_no'], $primaryKey['car_no']])) {
if (!$obj->delete()) {
$transaction->rollback();
return false;
}
}
}
$delete_job = Sdptd04denpyosagyo::deleteAll('D04_DEN_NO =' . $primaryKey['den_no']);
$delete_product = Sdptd05denpyocom::deleteAll('D05_DEN_NO =' . $primaryKey['den_no']);
if (!isset($delete_job) || !isset($delete_product)) {
$transaction->rollback();
return false;
}
if ($obj = static::findOne($primaryKey['den_no'])) {
if (!$obj->delete()) {
$transaction->rollback();
return false;
}
}
$insert = new Sdptw01deldenpyo();
$insert->setData(['W01_DEN_NO' => $primaryKey['den_no']]);
if (!$insert->saveData()) {
$transaction->rollback();
return false;
}
$transaction->commit();
return true;
} catch (Exception $e) {
$transaction->rollback();
}
return false;
}
public function deleteData($where)
{
if ($where) {
return Sdptd04denpyosagyo::deleteAll($where);
}
return false;
}
