function loadParvazDets($parvaz_det_id) { $out = null; $no = date("Y-m-d"); $par = new parvaz_det_class((int) $parvaz_det_id); mysql_class::ex_sql("select `parvaz_det`.`id`,`parvaz`.`shomare`,`parvaz_det`.`tarikh`,`parvaz_det`.`saat` from `parvaz_det` left join `parvaz` on (`parvaz_det`.`parvaz_id` = `parvaz`.`id`) where `parvaz_det`.`en`=1 and `parvaz_det`.`id` <> {$parvaz_det_id} and `parvaz_det`.`tarikh`>='{$no}' and `parvaz`.`mabda_id`=" . $par->maghsad_id . " and `parvaz`.`maghsad_id`=" . $par->mabda_id . " order by `tarikh`,`saat`,`parvaz_id`", $q); while ($r = mysql_fetch_array($q)) { $out[$r['shomare'] . '(' . perToEnNums(audit_class::hamed_pdate($r['tarikh'])) . ' ' . $r['saat'] . ')'] = $r['id']; } return $out; }
public function deleteTicket($ticket_id) { $conf = new conf(); $ticket = new ticket_class((int) $ticket_id); $sanad_record_id = $ticket->sanad_record_id; $parvaz = new parvaz_det_class($ticket->parvaz_det_id); $today = date("Y-m-d H:i:s"); $out = FALSE; if ($today < $parvaz->tarikh . " " . $parvaz->saat) { $mysql = new mysql_class(); $mablagh = $ticket->mablagh * (1 - $ticket->poorsant / 100); $arg["toz"] = "حذف کامل بلیت شماره " . $ticket->shomare; $arg["toz"] .= 'از پرواز شماره ' . $parvaz->shomare . ' تاریخ ' . audit_class::hamed_pdate($parvaz->tarikh); $arg["user_id"] = $_SESSION[$conf->app . "_user_id"]; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 8; log_class::add($arg); $mysql->ex_sql("select `id`,`mablagh` from `customer_daryaft` where `sanad_record_id` = {$sanad_record_id}", $q); if (isset($q[0])) { if ((int) $q[0]["mablagh"] == $mablagh) { $mysql->ex_sqlx("delete from `customer_daryaft` where `id` = " . (int) $q[0]["id"]); } } $mysql->ex_sqlx("update `customer_daryaft` set `mablagh`=`mablagh`-{$mablagh} where `sanad_record_id` = {$sanad_record_id}"); $mysql->ex_sqlx("delete from `ticket` where `id` = " . $ticket->getId()); if ($ticket->adult < 2) { $parvaz->resetZarfiat(1); } $out = TRUE; } return $out; }
public function sanad_shenavar_kharid($parvaz, $tedad, $sanad_record_id, $user_id) { $toz = "بابت خرید {$tedad} بلیت از پرواز " . $parvaz->shomare . " تاریخ " . audit_class::hamed_pdate($parvaz->tarikh) . " ساعت " . $parvaz->saat . ' بصورت شناور'; if ($parvaz->mablagh_kharid != 0) { mysql_class::ex_sqlx('insert into `customer_daryaft` (`customer_id`, `user_id`, `mablagh`, `tozihat`, `sanad_record_id`, `typ`,`sanad_typ`) values(' . $parvaz->customer_id . ',' . $user_id . ',' . $tedad * $parvaz->mablagh_kharid . ',\'' . $toz . '\',' . $sanad_record_id . ',1,2)'); } }
function hamed_pdate($inp) { return audit_class::hamed_pdate($inp); }
public function addTmp($parvaz_det_id, $tedad, $timeout, $netlog, $rwaitlog, $adlprice, $chdprice, $infprice, $adl, $chd, $inf, $customer_id = -1) { $mysql = new mysql_class(); $conf = new conf(); if ($customer_id <= 0) { if (isset($_SESSION[$conf->app . "_customer_id"])) { $customer_id = (int) $_SESSION[$conf->app . "_customer_id"]; } } $cust = new customer_class($customer_id); $parvaz_det = new parvaz_det_class((int) $parvaz_det_id); $free_zarfiat = $parvaz_det->getZarfiat(-1); $zakhire = 0; $zarfiat = 0; if ($free_zarfiat < $tedad) { $zakhire = $tedad - $free_zarfiat; } $zarfiat = $tedad; $arg["toz"] = "ثبت موقت برای پرواز شماره \n\t\t\t" . $parvaz_det->shomare . ' تاریخ ' . audit_class::hamed_pdate($parvaz_det->tarikh) . "\n\t\t\t\t\t\t\t\t به تعداد\n\t\t\t{$tedad}\n\t\t\t\t\t\t\t\t از طریق" . $cust->name; $arg["user_id"] = isset($_SESSION) ? $_SESSION[$conf->app . "_user_id"] : -1; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 4; log_class::add($arg); $tarikh = date("Y-m-d H:i:s"); $con = $mysql->ex_sqlx("insert into `reserve_tmp` (`parvaz_det_id`,`tedad`,`customer_id`,`zakhire`,`zarfiat`,`tarikh`,`timeout`,`netlog`,`rwaitlog`,`adlprice`,`chdprice`,`infprice`,`adltedad`, `chdtedad`, `inftedad`,`parvaz_det_info`) values ('{$parvaz_det_id}','{$tedad}','{$customer_id}','{$zakhire}','{$zarfiat}','{$tarikh}','{$timeout}','{$netlog}','{$rwaitlog}',{$adlprice},{$chdprice},{$infprice},{$adl},{$chd},{$inf},'" . serialize($parvaz_det) . "') ", FALSE); $out = $mysql->insert_id($con); $mysql->close($con); return $out; }