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