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; }