public function loadByName($name)
{
if (trim($name) != '') {
$name = trim($name);
$mysql = new mysql_class();
$ln1 = $mysql->ex_sqlx("insert into shahr_tmp (name) values ('{$name}') ", FALSE);
$tmp_id = $mysql->insert_id($ln1);
$mysql->close($ln1);
$mysql->ex_sql("select name from shahr_tmp where id = {$tmp_id}", $q1);
if (isset($q1[0])) {
$name = $q1[0]['name'];
}
$mysql->ex_sqlx("delete from shahr_tmp where id = {$tmp_id}");
$mysql->ex_sql("select * from shahr where name='{$name}'", $q);
if (isset($q[0])) {
$r = $q[0];
$this->id = $q[0]['id'];
$this->name = $q[0]["name"];
$this->en_name = $q[0]["en_name"];
} else {
$ln = $mysql->ex_sqlx("insert into shahr (name) values ('{$name}') ", FALSE);
$this->id = $mysql->insert_id($ln);
$this->name = $name;
$mysql->close($ln);
}
}
}
public function __construct($id = -1)
{
$id = (int) $id;
mysql_class::ex_sql("select * from `reserve_tmp` where `id` = {$id}", $q);
if ($r = mysql_fetch_array($q)) {
$this->id = $r['id'];
$this->parvaz_det_id = $r['parvaz_det_id'];
$this->tarikh = $r['tarikh'];
$this->tedad = $r['tedad'];
$this->customer_id = $r['customer_id'];
$this->zakhire = $r['zakhire'];
$this->zarfiat = $r['zarfiat'];
$this->timeout = $r['timeout'];
$this->adlprice = $r['adlprice'];
$this->chdprice = $r['chdprice'];
$this->infprice = $r['infprice'];
$this->adltedad = $r['adltedad'];
$this->chdtedad = $r['chdtedad'];
$this->inftedad = $r['inftedad'];
$this->netlog = $r['netlog'];
$this->rwaitlog = $r['rwaitlog'];
if ($r['info'] != '' && $r['info'] != null) {
$this->info = unserialize($r['info']);
}
}
}
function load_tickets($user, $pass, $sanad_record_ids)
{
$tmp_arr = array();
$my = new mysql_class();
$u = new user_class();
$u->loadByUser($user);
$customer_id = $u->customer_id;
$my->ex_sql("select * from ticket where customer_id={$customer_id} and sanad_record_id in ({$sanad_record_ids})", $q);
foreach ($q as $r) {
$tick = new ticket_class();
//$tick->id = (int)$r['id'];
unset($tick->sanad_record_id);
$tick->fname = $r["fname"];
$tick->lname = $r["lname"];
$tick->tel = $r["tel"];
$tick->adult = (int) $r["adult"];
$tick->rahgiri = (int) $r["sanad_record_id"];
$tick->parvaz_det_id = (int) $r["parvaz_det_id"];
$tick->customer_id = (int) $r["customer_id"];
$tick->user_id = (int) $r["user_id"];
$tick->shomare = (int) $r["shomare"];
$tick->typ = (int) $r["typ"];
$tick->en = (int) $r["en"];
$tick->regtime = $r["regtime"];
$tick->mablagh = (int) $r["mablagh"];
$tick->tour_mablagh = (int) $r["tour_mablagh"];
$tick->poorsant = (int) $r["poorsant"];
$tick->gender = (int) $r["gender"];
$tmp_arr[] = $tick;
}
$out = xml_class::export($tmp_arr);
return $out;
}
public function __construct($app = conf::app)
{
mysql_class::ex_sql("select * from `admin` where `app` = '{$app}'", $q);
while ($r = mysql_fetch_array($q)) {
$this->data[] = $r['content'];
}
}
function add_item()
{
$fields = array();
foreach ($_REQUEST as $key => $value) {
if (strpos($key, "new_") === 0 && $key != "new_id" && $key != "new_en") {
$fields[substr($key, 4)] = $value;
}
}
$min_ticket = 0;
mysql_class::ex_sql("select MAX(`max_ticket`) as `minticket` from `customers`", $q);
if ($r = mysql_fetch_array($q)) {
$min_ticket = (int) $r["minticket"];
}
$min_ticket++;
$max_ticket = 0;
$max_ticket = $min_ticket + 999;
$fields["min_ticket"] = $min_ticket;
$fields["max_ticket"] = $max_ticket;
$fi = "(";
$va = "(";
foreach ($fields as $key => $value) {
$fi .= "`{$key}`,";
$va .= "'{$value}',";
}
$fi = substr($fi, 0, -1);
$va = substr($va, 0, -1);
$fi .= ")";
$va .= ")";
$query = "insert into `customers` {$fi} values {$va}";
mysql_class::ex_sqlx($query);
}
public function firstVisit(&$ses, $req)
{
$out = TRUE;
$conf = new conf();
//var_dump($ses);
//echo "<br/>";
//var_dump($req);
//echo "<br/>";
$firstVisit = isset($ses[$conf->app . "_login"]) && $ses[$conf->app . "_login"] == 1 && isset($req["user"]);
//var_dump($firstVisit);
//echo "<br/>";
$mysql = new mysql_class();
if ($firstVisit) {
$user = $req["user"];
$pass = md5($req["pass"]);
$out = FALSE;
$mysql->ex_sql("select `id`,`typ`,`pass`,`customer_id` from user where user = '******'", $q);
if (isset($q[0])) {
$r_u = $q[0];
if ($pass == $r_u["pass"]) {
$ses[$conf->app . "_user_id"] = (int) $r_u["id"];
$ses[$conf->app . "_typ"] = (int) $r_u['typ'];
$ses[$conf->app . "_customer_id"] = (int) $r_u['customer_id'];
$out = TRUE;
}
}
} else {
if (isset($req["user"]) && isset($_REQUEST['pass']) && $req['user'] == 'test' && $req['pass'] == 'test') {
$user = $req["user"];
$pass = md5($req["pass"]);
$out = FALSE;
//echo "select `id`,`typ`,`pass`,`customer_id` from user where user = '******'<br/>";
$mysql->ex_sql("select `id`,`typ`,`pass`,`customer_id` from user where user = '******'", $q);
//var_dump($q);
if (isset($q[0])) {
$r_u = $q[0];
if ($pass == $r_u["pass"]) {
$ses[$conf->app . "_user_id"] = (int) $r_u["id"];
$ses[$conf->app . "_typ"] = (int) $r_u['typ'];
$ses[$conf->app . "_customer_id"] = (int) $r_u['customer_id'];
$out = TRUE;
}
}
}
}
return $out;
}
function edit_item($id, $field, $value)
{
$parvaz_det_id = $GLOBALS['parvaz_det_id'];
mysql_class::ex_sql('select `id` from `parvaz_jid` where `parvaz_det_id` = ' . $parvaz_det_id . ' and `jid` = ' . $value, $q);
if (!($r = mysql_fetch_array($q))) {
mysql_class::ex_sqlx('update `parvaz_jid` set `jid` = ' . $value . ' where `id` = ' . $id);
}
}
function loadCustomer()
{
$out = '';
mysql_class::ex_sql("select `id`,`name` from `customers` where `en` = 1 order by `name` ", $q);
while ($r = mysql_fetch_array($q)) {
$out[$r['name']] = $r['id'];
}
return $out;
}
public function decreaseSms($number, $user_id, $sanad_record_id, $status)
{
mysql_class::ex_sql("select `id` from `sms_charge` where `cont`<`maxi` order by `id` limit 1 ", $q);
if ($r = mysql_fetch_array($q)) {
mysql_class::ex_sqlx('update `sms_charge` set `cont`=`cont`+1 where `id`=' . $r['id']);
}
//---------------------------------------------------------
mysql_class::ex_sqlx("insert into `sms` (`number`,`user_id`,`sanad_record_id`,`sent`) values ('{$number}','{$user_id}','{$sanad_record_id}','{$status}')");
}
function epass($cid)
{
$out = "";
mysql_class::ex_sql("select `epass` from `customers` where `id`='{$cid}'", $q);
if ($r = mysql_fetch_array($q)) {
$out = $r["epass"];
}
return $out;
}
function setDetByAcc($grp_id, $page_name, $frase)
{
mysql_class::ex_sql("select `id` from `access` where `page_name`='{$page_name}' and `group_id`='{$grp_id}' ", $q);
if ($r = mysql_fetch_array($q)) {
if ($r['id'] > 0) {
mysql_class::ex_sqlx("insert into `access_det` (`acc_id`,`frase`) values('" . $r['id'] . "','{$frase}') ");
}
}
}
function loadCustomerName()
{
$out = null;
mysql_class::ex_sql('select `name`,`id` from `customers` order by `name`', $q);
while ($r = mysql_fetch_array($q)) {
$out[$r['name']] = (int) $r['id'];
}
return $out;
}
function loadGroups()
{
$out = array();
$mysql = new mysql_class();
$mysql->ex_sql('select `name`,`id` from `grop` where `en`=1 order by `name`', $q);
foreach ($q as $r) {
$out[$r['name']] = (int) $r['id'];
}
return $out;
}
function sanadJam($where = '')
{
$out = array("sum_mablagh" => 0);
$mysql = new mysql_class();
$mysql->ex_sql("select sum(`mablagh`) as `sm` from `customer_daryaft` " . ($where != '' ? " where {$where}" : ''), $q);
if (isset($q[0])) {
$out = array("sum_mablagh" => (int) $q[0]['sm']);
}
return $out;
}
function loadSherkatName($inp)
{
$inp = (int) $inp;
$out = "";
mysql_class::ex_sql("select `name` from `sherkat` where `id` = '{$inp}'", $q);
if ($r = mysql_fetch_array($q)) {
$out = $r["name"];
}
return $out;
}
function epass($cid)
{
$mysql = new mysql_class();
$out = "";
$mysql->ex_sql("select `epass` from `customers` where `id`='{$cid}'", $q);
if (isset($q[0])) {
$out = $q[0]["epass"];
}
return $out;
}
public function getLastSanad_record_id()
{
$sanad_record_id = 200;
mysql_class::ex_sql("select MAX(`sanad_record_id`) as `sss` from `customer_daryaft`", $q);
if ($r = mysql_fetch_array($q)) {
$sanad_record_id = (int) $r["sss"] > 199 ? (int) $r["sss"] : 199;
$sanad_record_id++;
}
return $sanad_record_id;
}
public function __construct($moghim_code = -1)
{
$mysql = new mysql_class();
$mysql->ex_sql("select * from `agency` where `moghim_code` = '{$moghim_code}'", $q);
if (count($q) > 0) {
foreach ($q[0] as $fi => $val) {
$this->{$fi} = $val;
}
}
}
public function loadByParvaz_det_id($parvaz_det_id)
{
$my = new mysql_class();
$out = -1;
$my->ex_sql("select sites_id from parvaz_det_sites where parvaz_det_id={$parvaz_det_id}", $qp);
foreach ($qp as $r) {
$out = $r['sites_id'];
}
return $out;
}
function loadUser($inp)
{
$out = '';
$mysql = new mysql_class();
$mysql->ex_sql("select `fname`,`lname` from `user` where `id`='{$inp}'", $q);
if (isset($q[0])) {
$out = $q[0]['fname'] . ' ' . $q[0]['lname'];
}
return $out;
}
function loadCustomer()
{
$out = '';
$mysql = new mysql_class();
$mysql->ex_sql("select `id`,`name` from `customers` where `en` = 1 order by `name` ", $q);
foreach ($q as $r) {
$out[(int) $r['id']] = $r["name"];
}
return $out;
}
function loadCustomerName()
{
$mysql = new mysql_class();
$out = null;
$mysql->ex_sql('select `name`,`id` from `customers` order by `name`', $q);
foreach ($q as $r) {
$out[$r['id']] = (int) $r['name'];
}
return $out;
}
public static function get($source_id)
{
$out = 0;
$my = new mysql_class();
$my->ex_sql("select rookeshi from rookeshi where source_id={$source_id}", $q);
if (isset($q[0])) {
$out = (int) $q[0]['rookeshi'];
}
return $out;
}
function loadUser($inp)
{
$inp = (int) $inp;
$out = "";
mysql_class::ex_sql("select `fname`,`lname` from `user` where `id` = '{$inp}'", $q);
if ($r = mysql_fetch_array($q)) {
$out = $r["fname"] . ' ' . $r["lname"];
}
return $out;
}
public function loadByUser($user_id)
{
$out = array();
$user_id = (int) $user_id;
$mysql = new mysql_class();
$mysql->ex_sql("select `id`,`page_name` from `access` where `group_id` = {$user_id} and `is_group` = 0", $q);
foreach ($q as $r) {
$out[(int) $r['id']] = $r['page_name'];
}
return $out;
}
function edit_item($id, $feild, $value)
{
if ($feild == 'frase') {
mysql_class::ex_sql("select `id` from `access_det` where `acc_id` = (select `acc_id` from `access_det` where `id`={$id}) and `frase` = '{$value}'", $q);
if (!($r = mysql_fetch_array($q))) {
mysql_class::ex_sqlx("update `access_det` set `frase` = '{$value}' where `id`={$id}");
}
} else {
mysql_class::ex_sqlx("update `access_det` set `{$feild}` = '{$value}' where `id`={$id}");
}
}
public static function loadAll($iata = '')
{
$iata = strtoupper(trim($iata));
$out = "";
$my = new mysql_class();
$my->ex_sql("select iata,name,en_name from city where iata <> '' order by id", $q);
foreach ($q as $r) {
$out .= "<option value='" . $r['iata'] . "'" . ($iata == $r['iata'] ? ' selected' : '') . ">" . $r['name'] . '/' . $r['en_name'] . '/' . $r['iata'] . "</option>";
}
return $out;
}
function city($user, $pass)
{
$out = 'auth_error';
if (user_class::is_authonticated($pass, $user)) {
$tmp_arr = array();
$my = new mysql_class();
$my->ex_sql("select * from shahr order by name", $q);
$out = xml_class::export($q);
}
return $out;
}
public function __construct($id = -1)
{
$mysql = new mysql_class();
$mysql->ex_sql("select * from `grop` where `id` = {$id}", $q);
if (isset($q[0])) {
$r = $q[0];
$this->id = $r['id'];
$this->name = $r['name'];
$this->en = $r['en'];
}
}
function loadSherkatName($inp)
{
$mysql = new mysql_class();
$inp = (int) $inp;
$out = "";
$mysql->ex_sql("select `name` from `sherkat` where `id` = '{$inp}'", $q);
if (isset($q[0])) {
$out = $q[0]["name"];
}
return $out;
}
