function add_client($data) { $check_sql = "SELECT count(*) as c from clients where LOWER(`name`) = '" . strtolower($data["params"]["name"]) . "'"; $rs = mysql_fetch_assoc(mysql_query($check_sql)); if ($rs["c"] > 0) { phpgrid_error("Client already exist in database"); } mysql_query("INSERT INTO clients VALUES (null,'{$data["params"]["name"]}','{$data["params"]["gender"]}','{$data["params"]["company"]}')"); }
/** * Common function for db operations */ function execute_query($sql, $return = "") { if ($this->con) { $ret = $this->con->Execute($sql); if (!$ret) { if ($this->debug) { phpgrid_error("Couldn't execute query. " . $this->con->ErrorMsg() . " - {$sql}"); } else { phpgrid_error($this->error_msg); } } if ($return == "insert_id") { return $this->con->Insert_ID(); } } else { $ret = mysql_query($sql); if (!$ret) { if ($this->debug) { phpgrid_error("Couldn't execute query. " . mysql_error() . " - {$sql}"); } else { phpgrid_error($this->error_msg); } } if ($return == "insert_id") { return mysql_insert_id(); } } return $ret; }
function execute_query($Vac5c74b64b4b8352ef2f181affb5ac, $return = "") { if ($this->V7ed201fa20d25d22b291dc85ae9e5c) { $V2cb9df9898e55fd0ad829dc202ddbd = $this->V7ed201fa20d25d22b291dc85ae9e5c->Execute($Vac5c74b64b4b8352ef2f181affb5ac); if (!$V2cb9df9898e55fd0ad829dc202ddbd) { if ($this->debug) { phpgrid_error("Couldn't execute query. " . $this->V7ed201fa20d25d22b291dc85ae9e5c->ErrorMsg() . " - {$Vac5c74b64b4b8352ef2f181affb5ac}"); } else { phpgrid_error($this->error_msg); } } if ($return == "insert_id") { return $this->V7ed201fa20d25d22b291dc85ae9e5c->Insert_ID(); } } else { $V2cb9df9898e55fd0ad829dc202ddbd = mysql_query($Vac5c74b64b4b8352ef2f181affb5ac); if (!$V2cb9df9898e55fd0ad829dc202ddbd) { if ($this->debug) { phpgrid_error("Couldn't execute query. " . mysql_error() . " - {$Vac5c74b64b4b8352ef2f181affb5ac}"); } else { phpgrid_error($this->error_msg); } } if ($return == "insert_id") { return mysql_insert_id(); } } return $V2cb9df9898e55fd0ad829dc202ddbd; }
function add_client(&$data) { $check_sql = "SELECT count(*) as c from transport_customers where LOWER(`customers_name`) = '" . strtolower($data["params"]["customers_name"]) . "'"; $rs = mysql_fetch_assoc(mysql_query($check_sql)); if ($rs["c"] > 0) { phpgrid_error("ข้อมูลลูกค้าซ้ำ"); } }
function update_price(&$data) { //print_r($data); $obj =& get_instance(); $obj->load->model("price_model", "price"); $obj->load->library('conv_date'); $price_id = $data["params"]["id"]; //$startdate = date('Y-m-d',strtotime($data['params']['start_date'])); $startdate = $data['params']['start_date']; $enddate = $data['params']['start_date']; $c_stdate = $obj->price->check_before_update_price($price_id); //$c_endate = $obj->price->check_before_update_price($price_id,$en); $st_date = $c_stdate['start_date']; $en_date = $c_stdate['end_date']; //$ed_date = $c_endate; $m_date = $obj->conv_date->compareDate($startdate, $st_date); $e_date = $obj->conv_date->compareDate($enddate, $st_date); //$m_date ="E"; if ($m_date !== "E" && $e_date !== "E") { $check_sql = "SELECT COUNT(*) as c\n\nFROM\n\tpricelist\nWHERE\n\tfactory_id = '{$data["params"]["factory_id"]}'\nAND cubic_id = '{$data["params"]["cubic_id"]}'\nAND distance_id = '{$data["params"]["distance_id"]}'\nAND ( (start_date='0000-00-00' || start_date <= DATE_FORMAT('{$data["params"]["start_date"]}','%Y-%m-%d')) \nAND (end_date='0000-00-00' || end_date >= DATE_FORMAT('{$data["params"]["start_date"]}','%Y-%m-%d'))) \nOR\n( (start_date='0000-00-00' || start_date <= DATE_FORMAT('{$data["params"]["end_date"]}','%Y-%m-%d')) \nAND (end_date='0000-00-00' || end_date >= DATE_FORMAT('{$data["params"]["end_date"]}','%Y-%m-%d'))) LIMIT 1"; $rs = mysql_fetch_assoc(mysql_query($check_sql)); if ($rs["c"] > 0) { phpgrid_error("ข้อมูลราคาซ้ำ ไม่สามารถบันทึกได้"); } } }
function do_update(&$data) { //print_r($data); $obj =& get_instance(); $obj->load->model("price_model", "pricelist"); $id = intval($_REQUEST["id"]); $factory_id = $data["params"]["factory_id"]; $distance_id = $data["params"]["distance_id"]; $cubid_id = $data["params"]["cubic_id"]; $order_date = $data["params"]["order_date"]; #get price $order_price = $obj->pricelist->get_order_Price($factory_id, $cubid_id, $distance_id, $order_date); if ($order_price == null) { $str = ob_get_clean(); $str = "ไม่มีการกำหนดราคาค่าขนส่ง"; phpgrid_error($str); } else { $data["params"]["price"] = $order_price; $str = "UPDATE orders SET price ='{$data["parmas"]["price"]}' WHERE id = '{$data["id"]}'"; mysql_query($str); } //$str = "UPDATE orders SET price ='{$data["parmas"]["price"]}' WHERE id = '{$data["id"]}'"; //mysql_query($str); }
function add_invoice($data) { $upload_file_path = $data["params"]["note"]; // if file is uploaded if ($upload_file_path) { // your custom upload code goes here e.g. File DB insertion $f = pathinfo(realpath($upload_file_path)); $ext = pathinfo(realpath($upload_file_path), PATHINFO_EXTENSION); if ($ext != "pdf" && $ext != "gif" && $ext != "jpg" && $ext != "txt" && $ext != "doc" && $ext != "bmp" && $ext != "png") { unlink(realpath($upload_file_path)); phpgrid_error("Only pdf, gif, jpg, txt, doc, bmp, png files are allowed!"); } // rename file OR place folder // rename($f["dirname"]."/".$f["basename"],$f["dirname"]."/"."custom-".$f["basename"]); } }
function oilcars(&$data) { $id = intval($_GET["rowid"]); $data["params"]["customer_id"] = $id; $check_sql = "SELECT count(*) as c from transport_oilcars WHERE customer_id = {$id} and LOWER(`car_number`) = '" . strtolower($data["params"]["car_number"]) . "'"; $rs = mysql_fetch_assoc(mysql_query($check_sql)); if ($rs["c"] > 0) { phpgrid_error("หมายเลขรถซ้ำ"); } }
function delete_factory($data) { $str_ch = "UPDATE transport_factory SET factory_status ='0' WHERE (factory_id ='{$data["factory_id"]}')"; phpgrid_error($str_ch); //mysql_query($str_ch); }