function sql($sql, $type = "query", $fetchmode = 'default') { global $db; if (empty($db) || !is_object($db) || get_class($db) != "DB") { $dbh = FreePBX::Create()->Database(); $db = new DB($dbh); } switch ($fetchmode) { case 'DB_FETCHMODE_ASSOC': //You guessed it, looking for string constants! //You guessed it, looking for string constants! case DB_FETCHMODE_ASSOC: //simulate craptacular function from previous versions //that didn't even work correctly! sweet :-/ //(The integer shouldnt go there) if ($type == 'getAssoc') { $results = $db->{$type}($sql, true); } else { $results = $db->{$type}($sql, array(), DB_FETCHMODE_ASSOC); } break; case DB_FETCHMODE_ORDERED: $results = $db->{$type}($sql, array(), DB_FETCHMODE_ORDERED); break; case 'default': $results = $db->sql($sql, $type); break; default: throw new Exception("Unknown SQL fetchmode of {$fetchmode}"); break; } return $results; }
public function list_saved_form() { F3::set('data', 'daved data on the row'); $user = F3::get("SESSION.onlineUser"); $datas = DB::sql("select v.id,v.form_type,v.date,u.username from vehicle v, user_form u where u.vehicle_id=v.id and v.status ='saved' and u.username='******'"); F3::set('data', $datas); }
function lst() { $from = $this->get('POST.from'); $to = $this->get('POST.to'); $admin = $this->get('POST.admin'); $list = DB::sql("select status, count(status) as no from admin_log where admin_id='" . $admin_id . "' and date between '" . $from . "' and '" . $to . "' + interval 1 group by status"); $this->set("list", $list); }
public function items($term) { if ($term == '') { return false; } $term = $this->clean($term); // Query return DB::sql($this->query['items'], array('term' => $term)) ?: false; }
function transfer_feedback() { $id = F3::get("PARAMS.id"); $vehicle = new Axon("vehicle"); $vehicle->load(array('id=:id', array(':id' => $id))); $zone_id = $vehicle->zone_id; $wheeler = $vehicle->wheeler; $dates = $vehicle->date; $date = DB::sql("SELECT DATE_ADD( date, INTERVAL 15 DAY ) AS ds FROM vehicle WHERE id='{$id}' and date='{$dates}'"); $dt = new Form_elements(); $nepDate = $dt->dateConvertEn($date[0]["ds"]); // var_dump($date[0]["ds"]);die; //echo $nepDate;die; $zone = Admin::getZone($vehicle->zone_id); $symbol = Admin::getSymbolType($vehicle->vehicle_symbol_type); $vehicleNo = $zone . $vehicle->lot_number . $symbol . $vehicle->number; $zone = new Axon("zonal_office"); if ($zone->found(array('zone_id=:id and wheeler=:vid', array(':id' => $zone_id, ':vid' => $wheeler))) > 0) { $zone->load(array('zone_id=:id and wheeler=:vid', array(':id' => $zone_id, ':vid' => $wheeler))); $photos = new Axon("owner_photo"); if ($photos->found(array('vehicle_id =:id', array(':id' => $id)))) { $photos->load(array('vehicle_id =:id', array(':id' => $id))); F3::set('pic', $photos); } else { F3::set('pic', 'no photo available'); } F3::set('date', $nepDate); F3::set('refer', $id); F3::set('vehicle', $vehicleNo); F3::set('value', $zone->name); F3::set('navUser', 'userNav'); F3::set('template', 'feedbacktransfer'); echo Template::serve("template/layout.html"); } else { $photos = new Axon("owner_photo"); if ($photos->found(array('vehicle_id =:id', array(':id' => $id)))) { $photos->load(array('vehicle_id =:id', array(':id' => $id))); F3::set('pic', $photos); } else { F3::set('pic', 'no photo available'); } F3::set('date', $nepDate); F3::set('refer', $id); F3::set('navUser', 'userNav'); F3::set('value', 'no office available'); F3::set('template', 'feedbacktransfer'); echo Template::serve("template/layout.html"); } }
public function types() { return DB::sql($this->query['types']); }
function transfer() { if (!F3::get('SESSION.onlineUser')) { F3::reroute("/"); } $dateNep = new Form_elements(); //transfer information of the vehicle $id = date('siGjnty') . rand(1, 100); $ip_address = $_SERVER['REMOTE_ADDR']; $wheeler = F3::get("POST.wheeler"); $zone_id = F3::get("POST.zone_id"); $lot_number = F3::get("POST.lot_number"); $vehicle_symbol_type = $wheeler == 21 ? F3::get("POST.vehicle_symbol_type_two") : F3::get("POST.vehicle_symbol_type_four"); $number = F3::get("POST.number"); $vehicleid = $this->vehicleid($wheeler, $zone_id, $lot_number, $vehicle_symbol_type, $number); $reason = F3::get("POST.reason"); $dates = F3::get("POST.date"); $date = $dateNep->dateConvertEn($dates); $remarks = F3::get("POST.remarks"); $witness_name = F3::get("POST.witness_name"); $witness_address = F3::get("POST.witness_address"); $citizenship_no = F3::get("POST.citizenship_no"); //owner information $owner_type = F3::get("POST.owner_type"); $first_name = F3::get("POST.first_name"); $last_name = F3::get("POST.last_name"); $father_name = F3::get("POST.father_name"); $grandfather_name = F3::get("POST.grandfather_name"); $dob = F3::get("POST.dob"); $reg_num = F3::get("POST.reg_num"); $email = F3::get("POST.email"); $mobile = F3::get("POST.mobileno"); $p_zone_id = F3::get("POST.p_zone_id"); $p_district_id = F3::get("POST.p_district_id"); $p_metropolitan = F3::get("POST.p_metropolitan"); $p_ward_no = F3::get("POST.p_ward_no"); $p_address = F3::get("POST.p_address"); $p_house_no = F3::get("POST.p_house_no"); $p_phone = F3::get("POST.p_phone"); $temp_zone_id = F3::get("POST.temp_zone_id"); $temp_district_id = F3::get("POST.temp_district_id"); $temp_metropolitan = F3::get("POST.temp_metropolitan"); $temp_ward_no = F3::get("POST.temp_ward_no"); $temp_address = F3::get("POST.temp_address"); $temp_house_no = F3::get("POST.temp_house_no"); $temp_phone = F3::get("POST.temp_phone"); $nabalik_guardian_name = F3::get("POST.nabalik_guardian_name"); $nabalik_relation = F3::get("POST.nabalik_relation"); $nabalik_identity_no = F3::get("POST.nabalik_identity_no"); $nabalik_district = F3::get("POST.nabalik_district"); $nabalik_year = F3::get("POST.nabalik_year"); $nabalik_address = F3::get("POST.nabalik_address"); $bank_name = F3::get("POST.bank_name"); $creditor_name = F3::get("POST.creditor_name"); $creditor_district = F3::get("POST.creditor_district"); $creditor_year = F3::get("POST.creditor_year"); $creditor_address = F3::get("POST.creditor_address"); $per_nagarikta = F3::get("POST.per_nagarikta"); $per_identificationno = F3::get("POST.per_identificationno"); $per_district = F3::get("POST.per_district"); $per_year = F3::get("POST.per_year"); $indian_identificationno = F3::get("POST.indian_identificationno"); $other_identificationno = F3::get("POST.other_identificationno"); $captcha = F3::get("POST.code"); if ($captcha == F3::get("SESSION.captcha")) { $this->pictureFolder($id); $sqls[] = "INSERT INTO vehicle (id,wheeler,vehicleid,zone_id,lot_number,vehicle_symbol_type,number,ip_address,form_type) VALUES('{$id}','{$wheeler}','{$vehicleid}','{$zone_id}',' {$lot_number}','{$vehicle_symbol_type} ','{$number}','{$ip_address}','namsari')"; $sqls[] = "INSERT INTO owner (vehicleid,owner_type,first_name,last_name, father_name,grandfather_name,\n dob,reg_num,email,mobileno,p_zone_id,p_district_id, p_metropolitan,p_ward_no,\n p_address, p_house_no, p_phone, temp_zone_id,temp_district_id, temp_metropolitan,\n temp_ward_no, temp_address,temp_house_no, temp_phone, nabalik_guardian_name,nabalik_relation,\n nabalik_identity_no, nabalik_district, nabalik_year, nabalik_address, bank_name, creditor_name,\n creditor_district, creditor_year, creditor_address,per_nagarikta,per_identificationno,per_district,per_year,indian_identificationno,other_identificationno)\n VALUES( '{$id}','{$owner_type}','{$first_name}','{$last_name}','{$father_name}','{$grandfather_name}',\n '{$dob}','{$reg_num}','{$email}','{$mobile}','{$p_zone_id}','{$p_district_id}','{$p_metropolitan}','{$p_ward_no}','{$p_address}',\n '{$p_house_no}', '{$p_phone}','{$temp_zone_id}','{$temp_district_id}','{$temp_metropolitan}','{$temp_ward_no}',\n '{$temp_address}',' {$temp_house_no}',' {$temp_phone}', '{$nabalik_guardian_name}',' {$nabalik_relation}',\n '{$nabalik_identity_no}','{$nabalik_district}','{$nabalik_year}','{$nabalik_address}','{$bank_name}',\n '{$creditor_name}','{$creditor_district}','{$creditor_year}','{$creditor_address}','{$per_nagarikta}',\n '{$per_identificationno}','{$per_district}','{$per_year}','{$indian_identificationno}' ,'{$other_identificationno}')"; $sqls[] = "INSERT INTO namsari (vehicle_id,reason,date,remarks,witness_name,witness_address,citizenship_no) VALUES('{$id}','{$reason}','{$date}','{$remarks}','{$witness_name}','{$witness_address}','{$citizenship_no}')"; DB::sql($sqls); F3::reroute("/feedbackt/{$id}"); } else { F3::set('error', 'The captcha you have entered is wrong'); $this->transfer_ownership(); } }
function namsari_save() { if (!F3::get('SESSION.onlineUser')) { F3::reroute("/"); } //transfer information of the vehicle $id = date('siGjnty') . rand(1, 100); $user = F3::get("SESSION.onlineUser"); $ip_address = $_SERVER['REMOTE_ADDR']; $wheeler = F3::get("POST.wheeler"); $zone_id = F3::get("POST.zone_id"); $lot_number = F3::get("POST.lot_number"); $vehicle_symbol_type = $wheeler == 21 ? F3::get("POST.vehicle_symbol_type_two") : F3::get("POST.vehicle_symbol_type_four"); // var_dump($vehicle_symbol_type);die; $number = F3::get("POST.number"); $vehicleid = User::vehicleid($wheeler, $zone_id, $lot_number, $vehicle_symbol_type, $number); $status = 'saved'; //namsari reason $reason = F3::get("POST.reason"); $date = F3::get("POST.date"); $remarks = F3::get("POST.remarks"); $witness_name = F3::get("POST.witness_name"); $witness_address = F3::get("POST.witness_address"); $citizenship_no = F3::get("POST.citizenship_no"); //owner information $owner_type = F3::get("POST.owner_type"); $first_name = F3::get("POST.first_name"); $last_name = F3::get("POST.last_name"); $father_name = F3::get("POST.father_name"); $grandfather_name = F3::get("POST.grandfather_name"); $dob = F3::get("POST.dob"); $reg_num = F3::get("POST.reg_num"); $email = F3::get("POST.email"); $mobile = F3::get("POST.mobileno"); $p_zone_id = F3::get("POST.p_zone_id"); $p_district_id = F3::get("POST.p_district_id"); $p_metropolitan = F3::get("POST.p_metropolitan"); $p_ward_no = F3::get("POST.p_ward_no"); $p_address = F3::get("POST.p_address"); $p_house_no = F3::get("POST.p_house_no"); $p_phone = F3::get("POST.p_phone"); $temp_zone_id = F3::get("POST.temp_zone_id"); $temp_district_id = F3::get("POST.temp_district_id"); $temp_metropolitan = F3::get("POST.temp_metropolitan"); $temp_ward_no = F3::get("POST.temp_ward_no"); $temp_address = F3::get("POST.temp_address"); $temp_house_no = F3::get("POST.temp_house_no"); $temp_phone = F3::get("POST.temp_phone"); $nabalik_guardian_name = F3::get("POST.nabalik_guardian_name"); $nabalik_relation = F3::get("POST.nabalik_relation"); $nabalik_identity_no = F3::get("POST.nabalik_identity_no"); $nabalik_district = F3::get("POST.nabalik_district"); $nabalik_year = F3::get("POST.nabalik_year"); $nabalik_address = F3::get("POST.nabalik_address"); $bank_name = F3::get("POST.bank_name"); $creditor_name = F3::get("POST.creditor_name"); $creditor_district = F3::get("POST.creditor_district"); $creditor_year = F3::get("POST.creditor_year"); $creditor_address = F3::get("POST.creditor_address"); $per_nagarikta = F3::get("POST.per_nagarikta"); $per_identificationno = F3::get("POST.per_identificationno"); $per_district = F3::get("POST.per_district"); $per_year = F3::get("POST.per_year"); $indian_identificationno = F3::get("POST.indian_identificationno"); $other_identificationno = F3::get("POST.other_identificationno"); $captcha = F3::get("POST.code"); $photo = new User(); $picture = $photo->pictureFolder($id); $sqls[] = "INSERT INTO vehicle (id,wheeler,vehicleid,zone_id,lot_number,vehicle_symbol_type,number,ip_address,form_type,status) VALUES('{$id}','{$wheeler}','{$vehicleid}','{$zone_id}',' {$lot_number}','{$vehicle_symbol_type} ','{$number}','{$ip_address}','namsari','{$status}')"; $sqls[] = "INSERT INTO owner (vehicleid,owner_type,first_name,last_name, father_name,grandfather_name,\n dob,reg_num,email,mobileno,p_zone_id,p_district_id, p_metropolitan,p_ward_no,\n p_address, p_house_no, p_phone, temp_zone_id,temp_district_id, temp_metropolitan,\n temp_ward_no, temp_address,temp_house_no, temp_phone, nabalik_guardian_name,nabalik_relation,\n nabalik_identity_no, nabalik_district, nabalik_year, nabalik_address, bank_name, creditor_name,\n creditor_district, creditor_year, creditor_address,per_nagarikta,per_identificationno,per_district,per_year,indian_identificationno,other_identificationno)\n VALUES( '{$id}','{$owner_type}','{$first_name}','{$last_name}','{$father_name}','{$grandfather_name}',\n '{$dob}','{$reg_num}','{$email}','{$mobile}','{$p_zone_id}','{$p_district_id}','{$p_metropolitan}','{$p_ward_no}','{$p_address}',\n '{$p_house_no}', '{$p_phone}','{$temp_zone_id}','{$temp_district_id}','{$temp_metropolitan}','{$temp_ward_no}',\n '{$temp_address}',' {$temp_house_no}',' {$temp_phone}', '{$nabalik_guardian_name}',' {$nabalik_relation}',\n '{$nabalik_identity_no}','{$nabalik_district}','{$nabalik_year}','{$nabalik_address}','{$bank_name}',\n '{$creditor_name}','{$creditor_district}','{$creditor_year}','{$creditor_address}','{$per_nagarikta}',\n '{$per_identificationno}','{$per_district}','{$per_year}','{$indian_identificationno}' ,'{$other_identificationno}')"; $sqls[] = "INSERT INTO namsari (vehicle_id,reason,date,remarks,witness_name,witness_address,citizenship_no) VALUES('{$id}','{$reason}','{$date}','{$remarks}','{$witness_name}','{$witness_address}','{$citizenship_no}')"; $sqls[] = "INSERT INTO user_form(username,vehicle_id) VALUES('{$user}','{$id}')"; DB::sql($sqls); $data = 'saved='; $data .= $id; F3::reroute("/user/home/{$data}"); }
public static function field($tb_name) { $sql = "SHOW FULL FIELDS FROM " . $tb_name; self::$sql = $sql; return self::execute($sql); }
function dateConvertEn($date) { $sql = DB::sql("select nepali_year,month_code, datediff('" . $date . "', eng_start_date) +1 dt from calendar where '" . $date . "' between eng_start_date and eng_end_date"); $dt = $sql[0]["nepali_year"] . '-' . $sql[0]["month_code"] . '-' . $sql[0]['dt']; return $dt; }
public function prefix($sql, $exec = 0) { if (strpos($sql, 'JOIN') !== false || strpos($sql, 'ALTER TABLE') !== false) { $sql = str_replace('{{', BDPREFIX, $sql); $sql = str_replace('}}', '', $sql); } elseif (strpos($sql, 'INSERT') !== false && strpos($sql, 'SELECT') !== false) { $sql = str_replace('{{', BDPREFIX, $sql); $sql = str_replace('}}', '', $sql); } else { $sql = preg_replace(array('/{{/', '/}}/'), array(BDPREFIX, ''), $sql, 1); } $site = $_SESSION['site']; if (Funcs::$uri[0] == ONESSA_DIR) { $site = $_SESSION['OneSSA']['site']; } if ($exec == 0) { if (strpos($sql, BDPREFIX . 'tree') !== false && strpos($sql, BDPREFIX . 'tree t ') === false) { if (strpos($sql, 'WHERE') !== false) { $sql = str_replace('WHERE', 'WHERE ' . BDPREFIX . 'tree.site=' . $site . ' AND', $sql); } else { $sql = str_replace(BDPREFIX . 'tree', BDPREFIX . 'tree WHERE ' . BDPREFIX . 'tree.site=' . $site . '', $sql); } } elseif (strpos($sql, BDPREFIX . 'tree t ') !== false) { if (strpos($sql, 'WHERE') !== false) { $sql = str_replace('WHERE', 'WHERE t.site=' . $site . ' AND', $sql); } } } DB::$sql = $sql; DB::$count++; return $sql; }
function viewData() { if (!F3::get('SESSION.sid')) { F3::reroute('/home'); } $id = F3::get('PARAMS.pid'); $poll = DB::sql(" SELECT tbl_poll.user_id,tbl_option.name,tbl_poll.expiry_date,tbl_poll.created_date,tbl_poll.published_date,tbl_poll.keyword,tbl_poll.id,tbl_poll.user_id,tbl_user.fullname,tbl_user.image,tbl_poll.question,tbl_option.value FROM tbl_user LEFT join tbl_poll ON tbl_user.id=tbl_poll.user_id left join tbl_option on tbl_poll.id=tbl_option.poll_id where tbl_poll.id={$id} "); $i = 0; $data = DB::SQL("select tbl_poll.*, options.* from tbl_poll,(select name, value, COALESCE(votes, 0) as votes from tbl_option left outer join (SELECT option_name, count(option_name) as votes, poll_id from tbl_vote where poll_id={$id} group by option_name) as vote on tbl_option.name = vote.option_name where tbl_option.poll_id ={$id}) as options where tbl_poll.id={$id}"); $vote = DB::SQL("select count(option_name) as vote from tbl_vote where poll_id={$id}"); // var_dump($data);die; $dt = array(); $totalValue = $vote[0]["vote"]; if ($totalValue != 0) { // loop over poll options foreach ($data as $datas) { $cent = $datas["votes"] / $totalValue * 100; array_push($dt, array($datas["name"], stripslashes($datas["value"]), $datas["votes"], $cent)); } } else { foreach ($data as $datas) { array_push($dt, array($datas["name"], stripslashes($datas["value"]), $datas["votes"])); } } // var_dump($dt); $question = $data[0]["question"]; if (!strpos($poll[0]["question"], '?')) { $poll[0]["question"] .= "?"; } $date = DATE('Y-m-d'); F3::set('date', $date); F3::set('user_id', $poll[0]["user_id"]); F3::set('id', $poll[0]["id"]); F3::set('published_date', $poll[0]["published_date"]); F3::set('expiry_date', $poll[0]["expiry_date"]); F3::set('created_date', $poll[0]["created_date"]); F3::set('keyword', $poll[0]["keyword"]); $question = ucfirst($poll[0]["question"]); F3::set('user_id', $poll[0]["user_id"]); F3::set('fullname', $poll[0]["fullname"]); F3::set('image', $poll[0]["image"]); F3::set('question', $question); F3::set('options', $dt); F3::set('title', 'Poll Detail'); }
function axon() { $this->set('title', 'SQL/Axon'); $this->expect(is_null($this->get('ERROR')), 'No errors expected at this point', 'ERROR variable is set: ' . $this->get('ERROR.text')); $this->set('DB', new DB('sqlite::memory:')); $this->expect(extension_loaded('pdo_sqlite'), 'SQLite PDO available', 'SQLite PDO is not active - unable to continue'); if (extension_loaded('pdo_sqlite')) { DB::sql(array('DROP TABLE IF EXISTS products;', 'CREATE TABLE products (' . 'item INTEGER,' . 'description VARCHAR(255),' . 'quantity INTEGER,' . 'PRIMARY KEY (item)' . ');')); $product = new Axon('products'); $this->expect(is_object($product), 'Axon created', 'Unable to instantiate Axon'); unset($product); $product = Axon::instance('products'); $this->expect(is_a($product, 'Axon'), 'Axon instance created', 'Unable to instantiate Axon'); unset($product); $product = new axon('products'); $this->expect(is_object($product), 'Axon created (case-insensitive)', 'Unable to instantiate Axon (case-insensitive)'); $this->expect($product->dry(), 'Axon in dry state', 'Axon is in hydrated state'); $product->item = 111; $product->description = 'Coca Cola'; $product->quantity = 3; $this->expect(!$product->dry(), 'Axon hydrated manually', 'Axon should be hydrated by now'); $product->save(); $this->expect(!$product->dry(), 'Axon expected to remain hydrated', 'Axon should be dry'); // MySQL always reports an _id of 0 if primary key // is not an auto-increment field $this->expect($product->_id, 'Last insert ID available; SQLite returns ' . $product->_id, 'No last insert ID available'); $product->load(array('item=:item', array(':item' => 111))); $this->expect($product->item == 111 && $product->description == 'Coca Cola' && $product->quantity == 3, 'Auto-hydration succeeded (SQLite converts numbers to strings)', 'Auto-hydration failed'); $result = $product->findOne(array('item=:item', array(':item' => 111))); $this->expect($result->item == 111 && $result->description == 'Coca Cola' && $result->quantity == 3, 'findOne returned the correct record', 'findOne return value is incorrect'); $result = $product->find(array('item=:item', array(':item' => 111))); $this->expect(get_class($result[0]) == 'Axon' && $result[0]->item == 111 && $result[0]->description == 'Coca Cola' && $result[0]->quantity == 3, 'find returned an array of Axon objects', 'find return type is incorrect'); $product->quantity++; $product->save(); $product->load(array('item=:item', array(':item' => 111))); $this->expect($product->item == 111 && $product->description == 'Coca Cola' && $product->quantity == 4, 'Axon saved - database update succeeded', 'Database update failed'); $product->copyTo('POST'); $this->expect($this->get('POST.item') == 111 && $this->get('POST.description') == 'Coca Cola' && $this->get('POST.quantity') == 4, 'Axon properties copied to framework variable', 'Unable to copy Axon properties to framework variable'); $_POST['description'] = 'Pepsi'; $product->copyFrom('POST'); $this->expect($product->item == 111 && $product->description == 'Pepsi' && $product->quantity == 4, 'Axon properties populated by framework variable', 'Unable to fill Axon properties with contents of framework variable'); $this->set('POST.item', 999); $this->set('POST.description', 'Pepsi'); $this->set('POST.quantity', 11); $product->copyFrom('POST', 'item|quantity'); $this->expect($product->item == 999 && $product->description == 'Pepsi' && $product->quantity == 11, 'Axon properties populated by selected fields in framework variable', 'Unable to fill Axon properties with contents of framework variable'); $product->reset(); $this->expect($product->dry(), 'Axon reset completed', 'Axon should be dry'); $product->item = 222; $product->description = 'Mobile Phone'; $product->quantity = 9; $this->expect(!$product->dry(), 'Axon rehydrated manually', 'Axon should hydrated by now'); $product->save(); $this->expect(!$product->dry(), 'Axon expected to remain hydrated', 'Axon should not be dry'); $product->load('item=111'); $this->expect($product->item == 111 && $product->description == 'Coca Cola' && $product->quantity == 4, 'First record still there', 'First record is missing'); $product->load('item=222'); $this->expect($product->item == 222 && $product->description == 'Mobile Phone' && $product->quantity == 9, 'Second record found', 'Second record is missing'); $product->def('total', 'SUM(quantity)'); $this->expect($product->isdef('total') === TRUE, 'Virtual field created', 'Problem creating virtual field'); $product->load(); $this->expect($product->total == 13, 'Computed value of aggregate value using a virtual field works', 'Virtual field implementation faulty'); $product->undef('total'); $this->expect($product->isdef('total') === FALSE, 'Virtual field destroyed', 'Problem destroying virtual field'); $product->load('item=111'); $product->erase(); $product->load('item=111'); $this->expect($product->dry(), 'First record deleted', 'First record still exists'); $product->load('item=222'); $this->expect($product->item == 222 && $product->description == 'Mobile Phone' && $product->quantity == 9, 'Second record still there', 'Second record is missing'); $product->reset(); $product->item = 111; $product->description = 'Lots of dough'; $product->quantity = 666; $product->save(); $product->load('quantity>0'); $this->expect($product->found() == 2, 'New record added - multirecord criteria specified for loading', 'New record was not added'); $product->skip(1); $this->expect(!$product->dry(), 'One more record expected to be retrieved', 'Axon is dry'); $this->expect($product->item == 222 && $product->description == 'Mobile Phone' && $product->quantity == 9, 'Forward navigation', 'Forward navigation failed'); $product->skip(-1); $this->expect($product->item == 111 && $product->description == 'Lots of dough' && $product->quantity == 666, 'Backward navigation', 'Backward navigation failed'); $product->skip(-1); $this->expect($product->dry(), 'Axon is dry when navigating before the start of the record set', 'Navigation failure'); $this->set('QUIET', TRUE); $product->skip(-1); $this->expect(!is_null($this->get('ERROR')), 'Navigating past dry state triggers an error', 'Navigation error handling issue'); $this->set('QUIET', FALSE); $this->clear('ERROR'); $product->load('quantity>0'); $product->skip(2); $this->expect($product->dry(), 'Axon is dry when navigating beyond the end of the record set', 'Navigation failure'); $this->set('QUIET', TRUE); $product->skip(); $this->expect(!is_null($this->get('ERROR')), 'Navigating past dry state triggers an error', 'Navigation error handling issue'); $this->set('QUIET', FALSE); $this->clear('ERROR'); $db = $this->get('DB'); $result = $db->exec('SELECT * FROM products WHERE item=:item', array(':item' => 111)); $this->expect($result[0]['item'] == 111 && $result[0]['description'] == 'Lots of dough' && $result[0]['quantity'] == 666, 'Late-binding of parameters to values in SQL statements', 'Late-binding issue encountered'); $product->load('item=111'); $product->description = 'quoted "string"'; $product->save(); $result = $product->findOne('item=111'); $this->expect($result->description == 'quoted "string"', 'Double-quoted strings are left untouched', 'Double-quoted strings altered'); } echo $this->render('basic/results.htm'); }
function approveNamsari() { if (!F3::get('SESSION.asid')) { F3::reroute("/admin"); } $vehicle = F3::get("PARAMS.id"); $sql = DB::SQL("select vehicleid from vehicle where id=111"); $wheeler = F3::get("POST.wheeler"); $zone_id = F3::get("POST.zone_id"); $lot_number = F3::get("POST.lot_number"); $vehicle_symbol_type = $wheeler == 21 ? F3::get("POST.vehicle_symbol_type_two") : F3::get("POST.vehicle_symbol_type_four"); $number = F3::get("POST.number"); $user = new User(); $vehicleid = $user->vehicleid($wheeler, $zone_id, $lot_number, $vehicle_symbol_type, $number); //table namsari $reason = F3::get("POST.reason"); $date = F3::get("POST.date"); $remarks = F3::get("POST.remarks"); $witness_name = F3::get("POST.witness_name"); $witness_address = F3::get("POST.witness_address"); $citizenship_no = F3::get("POST.citizenship_no"); //owner table $owner_type = F3::get("POST.owner_type"); $first_name = F3::get("POST.first_name"); $last_name = F3::get("POST.last_name"); $father_name = F3::get("POST.father_name"); $grandfather_name = F3::get("POST.grandfather_name"); $dob = F3::get("POST.dob"); $reg_num = F3::get("POST.reg_num"); $email = F3::get("POST.email"); $mobile = F3::get("POST.mobileno"); $p_zone_id = F3::get("POST.p_zone_id"); $p_district_id = F3::get("POST.p_district_id"); $p_metropolitan = F3::get("POST.p_metropolitan"); $p_ward_no = F3::get("POST.p_ward_no"); $p_address = F3::get("POST.p_address"); $p_house_no = F3::get("POST.p_house_no"); $p_phone = F3::get("POST.p_phone"); $temp_zone_id = F3::get("POST.temp_zone_id"); $temp_district_id = F3::get("POST.temp_district_id"); $temp_metropolitan = F3::get("POST.temp_metropolitan"); $temp_ward_no = F3::get("POST.temp_ward_no"); $temp_address = F3::get("POST.temp_address"); $temp_house_no = F3::get("POST.temp_house_no"); $temp_phone = F3::get("POST.temp_phone"); $nabalik_guardian_name = F3::get("POST.nabalik_guardian_name"); $nabalik_relation = F3::get("POST.nabalik_relation"); $nabalik_identity_no = F3::get("POST.nabalik_identity_no"); $nabalik_district = F3::get("POST.nabalik_district"); $nabalik_year = F3::get("POST.nabalik_year"); $nabalik_address = F3::get("POST.nabalik_address"); $bank_name = F3::get("POST.bank_name"); $creditor_name = F3::get("POST.creditor_name"); $creditor_district = F3::get("POST.creditor_district"); $creditor_year = F3::get("POST.creditor_year"); $creditor_address = F3::get("POST.creditor_address"); $per_nagarikta = F3::get("POST.per_nagarikta"); $per_identificationno = F3::get("POST.per_identificationno"); $per_district = F3::get("POST.per_district"); $per_year = F3::get("POST.per_year"); $indian_identificationno = F3::get("POST.indian_identificationno"); $other_identificationno = F3::get("POST.other_identificationno"); //online edit by the operator $onlineSql[] = "update vehicle set wheeler='{$wheeler}',vehicleid='{$vehicleid}',zone_id='{$zone_id}',lot_number='{$lot_number}',\n vehicle_symbol_type='{$vehicle_symbol_type}', number='{$number}', status='approved' where id='" . $vehicle . "'"; $onlineSql[] = "update namsari set reason='{$reason}',date='{$date}',remarks='{$remarks}',witness_name='{$witness_name}',witness_address='{$witness_address}',citizenship_no='{$citizenship_no}'where id='" . $vehicle . "'"; $onlineSql[] = "update owner set owner_type='{$owner_type}',first_name='{$first_name}',last_name='{$last_name}', father_name='{$father_name}',\n grandfather_name='{$grandfather_name}',dob='{$dob}',reg_num='{$reg_num}',email='{$email}',mobileno='{$mobile}',p_zone_id='{$p_zone_id}',p_district_id='{$p_district_id}',\n p_metropolitan='{$p_metropolitan}',p_ward_no='{$p_ward_no}',p_address='{$p_address}', p_house_no='{$p_house_no}', p_phone='{$p_phone}',\n temp_zone_id='{$temp_zone_id}',temp_district_id='{$temp_district_id}', temp_metropolitan='{$temp_metropolitan}', temp_ward_no='{$temp_ward_no}', temp_address='{$temp_address}',temp_house_no='{$temp_house_no}',\n temp_phone='{$temp_phone}', nabalik_guardian_name='{$nabalik_guardian_name}',nabalik_relation='{$nabalik_relation}',\n nabalik_identity_no='{$nabalik_identity_no}', nabalik_district='{$nabalik_district}', nabalik_year='{$nabalik_year}', nabalik_address='{$nabalik_address}',\n bank_name='{$bank_name}', creditor_name='{$creditor_name}',\n creditor_district='{$creditor_district}', creditor_year='{$creditor_year}', creditor_address='{$creditor_address}',per_nagarikta='{$per_nagarikta}',\n per_identificationno='{$per_identificationno}',per_district='{$per_district}',per_year='{$per_year}',indian_identificationno='{$indian_identificationno}' ,other_identificationno='{$other_identificationno}' where vehicleid='" . $vehicle . "'"; // // $zone = Admin::getZone($zone_id); $symbol = Admin::getSymbolType($vehicle_symbol_type); $vehicleNo = $zone . $lot_number . $symbol . $number; F3::set('DB', new DB(F3::get("db_param.live_host"), F3::get("db_param.live_user"), F3::get("db_param.live_password"))); $old_owner_id = DB::sql("select owner_id from vehicle where id='" . $vehicleid . "'"); //check whether id is int if (count($old_owner_id) > 0) { $sqls[] = "INSERT INTO owner\n (name,caste,dob,email,owner_type_id,father_name,g_father_name,mobileno,p_district,p_zone_id,\n p_nagarpalika,p_wardno, p_tole,p_gharno,p_phone,t_district,t_zone_id,t_nagarpalika,t_wardno,t_tole,\n t_gharno,t_phone,nab_guardian_name,nab_relation,nab_identificationno,nab_district,nab_year,nab_address,per_nagarikta, per_identificationno,\n per_district,per_year,bank_name,bank_identificationno,bank_district, bank_year,bank_address) VALUES\n ('{$first_name}', '{$last_name}','{$dob}','{$email}','{$owner_type}','{$father_name}','{$grandfather_name}', '{$mobile}',' {$p_district_id}',' {$p_zone_id}',\n '{$p_metropolitan}', '{$p_ward_no}','{$p_address}', '{$p_house_no}', '{$p_phone}', ' {$temp_district_id}','{$temp_zone_id}', '{$temp_metropolitan}',' {$temp_ward_no}','{$temp_address}',\n ' {$temp_house_no}',' {$temp_phone}', '{$nabalik_guardian_name}',' {$nabalik_relation}', '{$nabalik_identity_no}', '{$nabalik_district}', '{$nabalik_year}', '{$nabalik_address}','{$per_nagarikta}','{$per_identificationno}',\n '{$per_district}', '{$per_year}', '{$bank_name}', '{$creditor_name}',' {$creditor_district}', '{$creditor_year}','{$creditor_address}')"; $sqls[] = "insert into namsari_info\n (vehicle_id,reason,date,comments, sakshi_name,sakshi_address,sakshi_identification,new_ownerid, old_ownerid,status)\n values ('{$vehicleid}','{$reason}','{$date}','{$remarks}','{$witness_name}','{$witness_address}','{$citizenship_no}',(select last_insert_id()),'" . $old_owner_id[0]['owner_id'] . "','initial')"; //set db to remote DB::sql($sqls); $photo_name = DB::sql("select new_ownerid from namsari_info where vehicle_id='" . $vehicleid . "' order by new_ownerid desc"); //update photo $onlineSql[] = "update owner_photo set picture='" . $photo_name[0]['new_ownerid'] . ".jpg' where vehicle_id='" . $vehicle . "'"; //set db to old one F3::set('DB', new DB(F3::get("local_param.local_host"), F3::get("local_param.local_user"), F3::get("local_param.local_password"))); DB::SQL($onlineSql); rename("photo/" . $vehicle . ".jpg", "photo/" . $photo_name[0]['new_ownerid'] . ".jpg"); AdminLog::add($vehicleNo, "namsari", "approved"); //success message F3::set('nav', 'navigation'); F3::set('message', 'The data has been approved'); F3::set('templateAdmin', 'approve'); echo Template::serve("template/layout.html"); } else { F3::set('message', 'The data doesnot exist'); F3::set('nav', 'navigation'); F3::set('templateAdmin', 'approve'); echo Template::serve("template/layout.html"); } }
function prepare($sql) { global $dbh; self::$sql = $sql; return $dbh->prepare($sql); }