<?php
$headerInclude = "ledgers";
$periodhead = "Ledgers";
require_once "includes/sessioncheck.php";
require_once "../includes/dbconnection.php";
require_once '../includes/function.php';
require_once '../includes/subFunctions/smart_search.php';
require_once '../includes/subFunctions/color_manip.php';
require_once "../includes/log.class.php";
$sessionlogin = isset($HTTP_SESSION_VARS["sessionlogin"]) ? $HTTP_SESSION_VARS["sessionlogin"] : "";
/**************
Define functions to process form
**************/
$log = new log_class();
/****************
Process Form
****************/
/**************
Define pairs
**************/
$my_sql['pairs']['actors'] = array(array("display" => "Any", "value" => "", "default" => 1), array("display" => "misc", "value" => "misc"), array("display" => "customer", "value" => "customer"), array("display" => "merchant", "value" => "merchant"), array("display" => "reseller", "value" => "reseller"), array("display" => "admin", "value" => "admin"), array("display" => "system", "value" => "system"), array("display" => "service", "value" => "service"), array("display" => "bank", "value" => "bank"));
$my_sql['pairs']['actions'] = array(array("display" => "Any", "value" => "", "default" => 1), array("display" => "rebill", "value" => "rebill"), array("display" => "email", "value" => "email"), array("display" => "misc", "value" => "misc"), array("display" => "error", "value" => "error"), array("display" => "order", "value" => "order"), array("display" => "login", "value" => "login"), array("display" => "notify", "value" => "notify"), array("display" => "hackattempt", "value" => "hackattempt"), array("display" => "erroralert", "value" => "erroralert"), array("display" => "pendingwebsite", "value" => "pendingwebsite"), array("display" => "pendingdocuments", "value" => "pendingdocuments"), array("display" => "requestrates", "value" => "requestrates"), array("display" => "resellerrequestrates", "value" => "resellerrequestrates"), array("display" => "requestlive", "value" => "requestlive"), array("display" => "completedapplication", "value" => "completedapplication"), array("display" => "turnedlive", "value" => "turnedlive"), array("display" => "requestmarkup", "value" => "requestmarkup"));
$my_sql['pairs']['ResultsPerPage'] = array(array("display" => "All", "value" => "1000000"), array("display" => "10", "value" => "10"), array("display" => "25", "value" => "25"), array("display" => "50", "value" => "50"), array("display" => "100", "value" => "100"));
$my_sql['pairs']['DisplayRange'] = array(array("display" => "Display All", "value" => "", "default" => 1), array("display" => "Selected Dates", "value" => "1"));
/****************
Define Search Fields and Action Fields
****************/
$my_sql['search']['lg_actor'] = array("input_type" => "selectmulti", "display" => "Actors");
$my_sql['search']['lg_actor']['options']['source']['pairs'] = "actors";
$my_sql['search']['lg_action'] = array("input_type" => "selectmulti", "display" => "Actions");
$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}'");
}