$parvaz = new parvaz_det_class($parvaz_det_id); if (isset($_REQUEST["poorsant"]) && isset($_REQUEST['customer_id'])) { $customer_id = (int) $_REQUEST['customer_id']; if ($customer_id > 0) { $cust = new customer_class($customer_id); $cust->setPoorsant($parvaz_det_id, (int) $_REQUEST["poorsant"]); } else { $mysql = new mysql_class(); $mysql->ex_sqlx("update `parvaz_det` set `poor_def`='" . (int) $_REQUEST["poorsant"] . "' where `id`='{$parvaz_det_id}'"); } $arg["toz"] = "مقدار " . $_REQUEST["poorsant"] . " پورسانت برای پرواز شماره" . $parvaz->shomare . ' تاریخ ' . $parvaz->tarikh . " ثبت گردید."; $arg["user_id"] = $_SESSION[$conf->app . "_user_id"]; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 6; log_class::add($arg); die("ok"); } $gname = 'customer_parvaz_poor'; $input = array($gname => array('table' => 'customer_parvaz', 'div' => 'customer_parvaz_poor_div')); $xgrid = new xgrid($input); //$xgrid->alert = TRUE; $xgrid->eRequest[$gname] = array('parvaz_det_id' => $parvaz_det_id); $xgrid->whereClause[$gname] = " `parvaz_det_id`={$parvaz_det_id} and `poorsant`<>0 "; $xgrid->column[$gname][0]['name'] = ''; $xgrid->column[$gname][1]['name'] = 'مشتری'; $xgrid->column[$gname][1]['cfunction'] = array('loadMoshtari'); $xgrid->column[$gname][2]['name'] = ''; $xgrid->column[$gname][3]['name'] = 'کمیسیون'; $xgrid->column[$gname][4]['name'] = ''; $xgrid->column[$gname][5]['name'] = 'کاربر ثبت کننده';
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; }
function delete_item($id) { $cust_par = new customer_parvaz_class(); $cust_par = $cust_par->loadField($id, array('zakhire', 'parvaz_det_id', 'customer_id')); if ($cust_par !== FALSE) { $par = new parvaz_det_class($cust_par['parvaz_det_id']); $cust = new customer_class(); $cust = $cust->loadField($cust_par['customer_id'], array('name')); $arg["toz"] = "به تعداد " . $cust_par['zakhire'] . " از پرواز شماره " . $par->shomare . ' تاریخ ' . jdate("d / m / Y", strtotime($par->tarikh)) . ' از آژانس ' . $cust['name'] . ' ذخیره حذف گردید '; $arg["user_id"] = $_SESSION[$conf->app . "_user_id"]; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 5; log_class::add($arg); mysql_class::ex_sqlx('delete from `customer_parvaz` where `id`= ' . $id); } }
function addUser($gname, $table, $fields, $column) { $out = FALSE; $conf = new conf(); $mysql = new mysql_class(); $user = $fields['user']; $pass = $fields['pass']; $grop_id = $fields['group_id']; $fname = $fields['fname']; $lname = $fields['lname']; $customer_id = $fields['customer_id']; $typ = $fields['typ']; $mysql->ex_sql("select count(`id`) as `cid` from `user` where `user`='{$user}'", $q); if ((int) $q[0]['cid'] == 0) { $ln = $mysql->ex_sqlx("insert into `user` (`user`,`pass`,`group_id`,`fname`,`lname`,`customer_id`,`typ`) values ('{$user}','" . md5($pass) . "','{$grop_id}','{$fname}','{$lname}',{$customer_id},{$typ})", FALSE); $user_id = $mysql->insert_id($ln); $mysql->close($ln); if ($user_id > 0) { $out = TRUE; $arg["toz"] = "اضافه کردن کاربر به نام {$fname} - {$lname}"; $arg["user_id"] = $_SESSION[$conf->app . "_user_id"]; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 2; log_class::add($arg); } } return $out; }
public static function add_new($tick, $moghim_info, $rwaitlog, $parvaz_det_info, &$ticket_id) { $mysql = new mysql_class(); $conf = new conf(); //$tmp_id= (int)$tmp_id; $out = FALSE; //$mysql->ex_sql("select `id` from `ticket` where `fname`='".$tick->fname."' and `lname`='".$tick->lname."' and `tel`='".$tick->tel."' and `parvaz_det_id`='".$tick->parvaz_det_id."' and `en`='".$tick->en."' and `mablagh` = '".$tick->mablagh."' and `poorsant` = '".$tick->poorsant."' and `shomare` = '".$tick->shomare."' and `gender` = ".$tick->gender." and email_addr = '".$tick->email_addr."' and sites_id='".$tick->sites_id."' and code_melli='".$tick->code_melli."'",$q); //if(count($q)==0 && $tick->lname!="") //{ $mablagh = $tick->mablagh; if ($tick->adult == 2) { $mablagh = (int) $mablagh / 10; } $arg["toz"] = "ثبت بلیت به شماره " . $tick->shomare . " کد رهگیری " . ticket_class::rahgiriToCode($tick->sanad_record_id, $conf->rahgiri); $arg["user_id"] = isset($_SESSION) ? $_SESSION[$conf->app . "_user_id"] : -1; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 3; log_class::add($arg); $hala = date("Y-m-d H:i:s"); $con = $mysql->ex_sqlx("insert into ticket (`fname`,`lname`,`tel`,`adult`,`sanad_record_id`,`parvaz_det_id`,`customer_id`,`user_id`,`shomare`,`typ`,`en`,`mablagh`,`poorsant`,`gender`,`regtime`,email_addr,sites_id,code_melli,rep,refer,seldate,rwaitlog,parvaz_det_info) values ('" . $tick->fname . "','" . $tick->lname . "','" . $tick->tel . "','" . $tick->adult . "','" . $tick->sanad_record_id . "','" . $tick->parvaz_det_id . "','" . $tick->customer_id . "','" . $tick->user_id . "','" . $tick->shomare . "','" . $tick->typ . "','" . $tick->en . "','{$mablagh}','" . $tick->poorsant . "'," . (int) $tick->gender . ",'{$hala}','" . $tick->email_addr . "','" . $tick->sites_id . "','" . $tick->code_melli . "','" . $moghim_info->rep . "','" . $moghim_info->refer . "','" . $moghim_info->seldate . "','{$rwaitlog}','{$parvaz_det_info}')", FALSE); $ticket_id = $mysql->insert_id($con); $mysql->close($con); $out = TRUE; //------------sms------------------ /* $cust_sms = new customer_class($this->customer_id); if(sms_class::isMobile($this->tel) && $cust_sms->can_sms) { $sms_parvaz = new parvaz_det_class($this->parvaz_det_id); $sms_msg="ازخریدشمامتشکریم\nپرواز:".$sms_parvaz->shomare."\n".audit_class::hamed_pdate($sms_parvaz->tarikh)."\nرهگیری:".$this->rahgiriToCode($this->sanad_record_id,$conf->rahgiri)."\n".$cust_sms->name; sms_class::sendSms($sms_msg,array("$this->tel"),(int)$_SESSION[$conf->app.'_user_id'],$this->sanad_record_id); }*/ //--------------------------------- //$out =(($ok=="ok")?TRUE:FALSE); //} return $out; }
function edit_item($id, $field, $value) { $lastvalue = ""; $mysql = new mysql_class(); $mysql->ex_sql("select `{$field}` from `parvaz_det` where `id`='{$id}'", $q); if (isset($q[0])) { $lastvalue = $q[0][$field]; } $arg["toz"] = "اصلاح فیلد {$field} از id {$id} به مقدار {$value} از مقدار {$lastvalue}"; $arg["user_id"] = $_SESSION[$conf->app . "_user_id"]; $arg["host"] = $_SERVER["REMOTE_ADDR"]; $arg["page_address"] = $_SERVER["SCRIPT_NAME"]; $arg["typ"] = 2; log_class::add($arg); switch ($field) { case 'mablagh_kharid': $par = new parvaz_det_class((int) $id); $par->mablagh_kharid = $value - $lastvalue; $par->kharidParvaz($par->zarfiat, 'بابت تغییر قیمت خرید پرواز از ' . $lastvalue . ' به ' . $value); break; case 'customer_id': $par = new parvaz_det_class((int) $id); $par->mablagh_kharid = -1 * $par->mablagh_kharid; $cust1 = new customer_class($par->customer_id); $cust1 = $par->customer_id > 0 ? $cust1->name : 'مدیریت'; $cust2 = new customer_class($value); $cust2 = $value > 0 ? $cust2->name : 'مدیریت'; $par->kharidParvaz($par->zarfiat, 'بابت تغییر فروشنده از ' . $cust1 . ' به ' . $cust2); $par->mablagh_kharid = -1 * $par->mablagh_kharid; $par->customer_id = $value; $par->kharidParvaz($par->zarfiat, 'بابت تغییر فروشنده از ' . $cust1 . ' به ' . $cust2); break; case 'j_id': if ($lastvalue == 0 && $value == 1) { $GLOBALS['extraScript'] = "openjid('{$id}');"; } break; } $mysql->ex_sqlx("update `parvaz_det` set `{$field}`='{$value}' where `id`='{$id}'"); }