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