|
 |
| |
ช่วยแก้โค้ดหน่อยคับ เป็นการแก้ไขและอัพเดท ใบเสนอราคาสินค้า php |
| |
 |
|
|
 |
 |
|
คือผมจะแก้ไข code ระบบใบเสนอราคา โดยเพิ่ม บริษัทเพิ่มจากเดิม แต่ code มันไม่รัน ในหน้าของการแก้ไขข้อมูล วานผู้เชี่ยวชาญช่วยแนะนำด้วยคับ
code หน้า rewrite
<?php session_start();
require_once('Connections/yonghong.php');
mysql_select_db($database_yonghong, $yonghong);
$query_max_id = "SELECT max(id_num) id_quotation FROM quotation";
$max_id = mysql_query($query_max_id, $yonghong) or die(mysql_error());
$row_max_id = mysql_fetch_assoc($max_id);
$totalRows_max_id = mysql_num_rows($max_id);
if(!$totalRows_max_id){$row_max_id['max(id_quotation)']=0;}
$year = date("y");
$id_num = $row_max_id['id_quotation']+1;
if($_POST['companyid_quotation']==3){
mysql_select_db($database_yonghong, $yonghong);
$query_id_ime = "SELECT max(id_ime) FROM quotation";
$id_ime = mysql_query($query_id_ime, $yonghong) or die(mysql_error());
$row_id_ime = mysql_fetch_assoc($id_ime);
$totalRows_id_ime = mysql_num_rows($id_ime);
$id_ime = $row_id_ime['max(id_ime)']+1;
@mysql_free_result($id_ime);
if($id_ime<9999){
$n = "0000$id_ime";
$n = substr($n, -4);
}else{$n = $id_ime;}
$n = "$year-IMEQ$n";
//สิ้นสุดกำนดค่า ime
}
else if($_POST[companyid_quotation]==5){
mysql_select_db($database_yonghong, $yonghong);
$query_id_mec = "SELECT max(id_mec) FROM quotation";
$id_mec = mysql_query($query_id_mec, $yonghong) or die(mysql_error());
$row_id_mec = mysql_fetch_assoc($id_mec);
$totalRows_id_mec = mysql_num_rows($id_mec);
$id_mec = $row_id_mec['max(id_mec)']+1;
@mysql_free_result($id_mec);
if($id_mec<9999){
$n = "0000$id_mec";
$n = substr($n, -4);
}
else{$n = $id_mec;}
$n = "$year-MECQ$n";;
} //สิ้นสุดกำนดค่า mec
else if($_POST[companyid_quotation]==4){
mysql_select_db($database_yonghong, $yonghong);
$query_id_ind = "SELECT max(id_ind) FROM quotation";
$id_ind = mysql_query($query_id_ind, $yonghong) or die(mysql_error());
$row_id_ind = mysql_fetch_assoc($id_ind);
$totalRows_id_ind = mysql_num_rows($id_ind);
$id_ind = $row_id_ind['max(id_ind)']+1;
@mysql_free_result($id_ind);
if($id_ind<9999){
$n = "0000$id_ind";
$n = substr($n, -4);
}
else{$n = $id_ind;}
$n = "$year-INDQ$n";
} //สิ้นสุดกำนดค่า ind
else{
//เริ่มต้นกำหนดค่าบริษัททั่วไป
if($id_num<9999){
$n = "0000$id_num";
$n = substr($n, -4);
}else{$n = $id_num;}
$n = "$year-$n";
//สิ้นสุดกำนดค่า ทั่วไป
}
//เปลี่ยนค่า id_group
mysql_select_db($database_yonghong, $yonghong);
$query_select_group = "SELECT * FROM quotation_member WHERE id_sale = {$_POST[salename_quotation]}";
$select_group = mysql_query($query_select_group, $yonghong) or die(mysql_error());
$row_select_group = mysql_fetch_assoc($select_group);
$id_group_ck = $row_select_group['id_group'];
//echo "<pre>";
//print_r($_POST);
//echo "</pre>";
//exit();
////////////////////Table quotation
$zone = NULL;
if(trim($_POST['zone_1'])!=''){
$zone = trim($_POST['zone_1']);
}
elseif(trim($_POST['zone_2'])!=''){
$zone = trim($_POST['zone_2']);
}
elseif(trim($_POST['zone_3'])!=''){
$zone = trim($_POST['zone_3']);
}
elseif(trim($_POST['zone_4'])!=''){
$zone = trim($_POST['zone_4']);
}
elseif(trim($_POST['zone_5'])!=''){
$zone = trim($_POST['zone_5']);
}
elseif(trim($_POST['zone_6'])!=''){
$zone = trim($_POST['zone_6']);
}
elseif(trim($_POST['zone_7'])!=''){
$zone = trim($_POST['zone_7']);
}
$id_quotation = $n;
$id_num = $id_num;
$companyid_quotation = $_POST[companyid_quotation];
$status_cusname = trim($_POST['status_auto_complete']);
$customercompany_quotation = trim($_POST['customercompany_quotation']);
$customercompany_quotation = explode("|", $customercompany_quotation);
$customercompany_quotation = $customercompany_quotation[0];
$customer_address_quotation = $_POST[customer_address_quotation];
$tel_quotation = $_POST[tel_quotation];
$fax_quotation = $_POST[fax_quotation];
$date_quotation = $_POST[create];
$create_date = date("d-m-Y, h:i A");
$customername_quotation = $_POST[customername_quotation];
$customer_tel = $_POST[customer_tel];
$email_customer = $_POST[email_customer];
$project = $_POST[project];
$product_quotation = $_POST[product_quotation];
$staticprice_quotation = $_POST[staticprice_quotation];
$methodpayprice_quotation = $_POST[methodpayprice_quotation];
$sendproduct_quotation = $_POST[sendproduct_quotation];
$sendproductposition_quotation = $_POST[sendproductposition_quotation];
$comment_quotation = $_POST[comment_quotation];
$salename_quotation = $_POST[salename_quotation];
$sale_edit_id = $_POST[sale_edit_id];
$date_edit = $_POST[date_edit];
$rewrite_old = $_POST[rewrite_old];
$quotation_status = $_POST[quotation_status];
$coment_quotation_id = $_POST[coment_quotation_id];
$date_rewrite = trim($_POST[date_quotation]);
//เช็คค่าการ Rewrite
if($rewrite){
$rewrite_num = trim($_POST[rewrite_num]);
$rewrite_num = $rewrite_num+1;
}
mysql_select_db($database_yonghong, $yonghong);
$sql="INSERT INTO quotation(id_quotation,id_ime,id_ind,id_mec,id_num,companyid_quotation,customercompany_quotation,customer_address_quotation,tel_quotation,email_customer,fax_quotation,date_quotation,create_date,customername_quotation,customer_tel,project,product_quotation,staticprice_quotation,methodpayprice_quotation,sendproduct_quotation,sendproductposition_quotation,comment_quotation,salename_quotation,id_group,sale_edit_id,date_edit,rewrite,date_rewrite,rewrite_old,rewrite_num,quotation_status,coment_quotation_id,quotation_zone)
VALUES('$id_quotation', '$id_ime',$id_ind, $id_mec, '$id_num', '$companyid_quotation', '$customercompany_quotation', '$customer_address_quotation', '$tel_quotation', '$email_customer', '$fax_quotation', '$date_quotation', '$create_date', '$customername_quotation', '$customer_tel', '$project', '$product_quotation', '$staticprice_quotation', '$methodpayprice_quotation', '$sendproduct_quotation', '$sendproductposition_quotation', '$comment_quotation', '$salename_quotation', '$id_group_ck', '$sale_edit_id', '$date_edit', '$rewrite', '$date_rewrite', '$rewrite_old', '$rewrite_num', '$quotation_status', '$coment_quotation_id', '$zone')";
if (!mysql_query($sql,$yonghong))
{
$inser_check="- <font color=red>ป้อนข้อมูลตาราง quotation ผิดพลาด!</font><br>";
}
/////////////////Insert Table no_quotation
$sql = "INSERT INTO no_quotation(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง no_quotation ผิดพลาด!</font><br>";
}else {
for($x = 1; $x <=50; $x++){
$no = (int)$_POST['no'.$x.'_quotation'];
if(trim($no)){
$fiel = "no".$x."_quotation";
$sql = "UPDATE no_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการอัพเดทข้อมูล ตาราง no_quotation ผิดพลาด!</font><br>";
}
}
}
}
/////////////////Insert Table detail_quotation
$sql = "INSERT INTO detail_quotation(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง detail_quotation ผิดพลาด!</font><br>";
}else {
for($x = 1; $x <=50; $x++){
$no = $_POST['detail'.$x.'_quotation'];
$fiel = "detail".$x."_quotation";
$sql = "UPDATE detail_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการอัพเดทข้อมูล ตาราง detail_quotation ผิดพลาด!</font><br>";
}
}
}
/////////////////Insert Table num_quotation
$sql = "INSERT INTO num_quotation(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง num_quotation ผิดพลาด!</font><br>";
}else {
for($x = 1; $x <=50; $x++){
$no = (int)$_POST['num_'.$x.'_quotation'];
if(trim($no)){
$fiel = "num_".$x."_quotation";
$sql = "UPDATE num_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการอัพเดทข้อมูล ตาราง num_quotation ผิดพลาด!</font><br>";
}
}
}
}
/////////////////Insert Table price_quotation
$sql = "INSERT INTO price_quotation(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง price_quotation ผิดพลาด!</font><br>";
}else {
for($x = 1; $x <=50; $x++){
$no = (float)$_POST['price_'.$x.'_quotation'];
if(trim($no)){
$fiel = "price_".$x."_quotation";
$sql = "UPDATE price_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการอัพเดทข้อมูล ตาราง price_quotation ผิดพลาด!</font><br>";
}
}
}
}
/////////////////Insert Table percen_quotation
$sql = "INSERT INTO percen_quotation(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง percen_quotation ผิดพลาด!</font><br>";
}else {
for($x = 1; $x <=50; $x++){
$no = trim($_POST['percen'.$x.'_quotation']);
$fiel = "percen".$x."_quotation";
$sql = "UPDATE percen_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการอัพเดทข้อมูล ตาราง percen_quotation ผิดพลาด!</font><br>";
}
}
}
/////////////////Insert Table sumprice_quotation
$sql = "INSERT INTO sumprice_quotation(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง sumprice_quotation ผิดพลาด!</font><br>";
}else {
for($x = 1; $x <=50; $x++){
$no = (float)$_POST['sumprice_'.$x.'_quotation'];
if(trim($no)){
$fiel = "sumprice_".$x."_quotation";
$sql = "UPDATE sumprice_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการอัพเดทข้อมูล ตาราง sumprice_quotation ผิดพลาด!</font><br>";
}
}
}
}
/////////////////Insert Table sum_all
$sumallprice_quotation = (float)trim($_POST[sumallprice_quotation]);
$cash_discount_quotation = (float)trim($_POST[cash_discount_quotation]);
$sum_discount_quotation = trim($_POST[sum_discount_quotation]);
$vat_quotation = (float)trim($_POST[vat_quotation]);
$endprice_quotation = (float)trim($_POST[endprice_quotation]);
$sql = "INSERT INTO sum_all(id_num) VALUES($id_num)";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>Insert id_num ตาราง sum_all ผิดพลาด!</font><br>";
}else {
$sql = "UPDATE sum_all SET sumallprice_quotation='$sumallprice_quotation',
cash_discount_quotation='$cash_discount_quotation', sum_discount_quotation='$sum_discount_quotation', vat_quotation='$vat_quotation', endprice_quotation='$endprice_quotation' WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
if (!mysql_query($sql,$yonghong))
{
$inser_check.="- <font color=red>ช่วงการ insert ข้อมูล ตาราง sum_all ผิดพลาด!</font><br>";
}
}
if($inser_check){
echo $inser_check;} else {
echo "<font color=green>ป้อนข้อมูลชุดเลขที่ $id_quotation สำเร็จ</font>";
echo "<meta http-equiv=refresh content=1;URL=quotation_list.php>";
exit();
}
?>
โค้ดหน้า update
<?php session_start();
require_once('Connections/yonghong.php'); ?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
/*
echo "<pre>";
print_r($_POST);
echo "</pre>";
exit();
*/
//เช็ควันที่แก้ไข
if(trim($_POST['date_quotation'])==""){
$_POST['date_quotation'] = $_POST['date_quotation2'];
}
//เปลี่ยนค่า id_group
mysql_select_db($database_yonghong, $yonghong);
$query_select_group = "SELECT * FROM quotation_member WHERE id_sale = {$_POST[salename_quotation]}";
$select_group = mysql_query($query_select_group, $yonghong) or die(mysql_error());
$row_select_group = mysql_fetch_assoc($select_group);
$id_group_ck = trim($row_select_group['id_group']);
if(!empty($_POST[rewrite])){
$_POST[quotation_status]=NULL;
//$_POST[date_edit] = NULL;
$rewrite=trim(htmlspecialchars($_POST[rewrite]));
require_once('insert_rewrite.php');
exit();
}
if($_POST[copy] == '1'){
$_POST[rewrite_old] = NULL;
$_POST[quotation_status]=NULL;
$_POST[date_edit] = NULL;
require_once('insert_copy.php');
exit();
}
//Table quotation
$zone = NULL;
if(trim($_POST['zone_1'])!=''){
$zone = trim($_POST['zone_1']);
}
elseif(trim($_POST['zone_2'])!=''){
$zone = trim($_POST['zone_2']);
}
elseif(trim($_POST['zone_3'])!=''){
$zone = trim($_POST['zone_3']);
}
elseif(trim($_POST['zone_4'])!=''){
$zone = trim($_POST['zone_4']);
}
elseif(trim($_POST['zone_5'])!=''){
$zone = trim($_POST['zone_5']);
}
elseif(trim($_POST['zone_6'])!=''){
$zone = trim($_POST['zone_6']);
}
elseif(trim($_POST['zone_7'])!=''){
$zone = trim($_POST['zone_7']);
}
$id_quotation = $_POST['id_quotation'];
$id_num = $_POST['id_num'];
$companyid_quotation = $_POST['companyid_quotation'];
$status_cusname = trim($_POST['status_auto_complete']);
$customercompany_quotation = trim($_POST['customercompany_quotation']);
$customercompany_quotation = explode("|", $customercompany_quotation);
$customercompany_quotation = $customercompany_quotation[0];
$customer_address_quotation = trim($_POST['customer_address_quotation']);
$tel_quotation = $_POST['tel_quotation'];
$fax_quotation = $_POST['fax_quotation'];
$date_quotation = $_POST['date_quotation'];
$customername_quotation = $_POST['customername_quotation'];
$customer_tel = $_POST['customer_tel'];
$email_customer = $_POST['email_customer'];
$project = $_POST['project'];
$product_quotation = $_POST['product_quotation'];
$staticprice_quotation = $_POST['staticprice_quotation'];
$methodpayprice_quotation = $_POST['methodpayprice_quotation'];
$sendproduct_quotation = $_POST['sendproduct_quotation'];
$sendproductposition_quotation = $_POST['sendproductposition_quotation'];
$comment_quotation = $_POST['comment_quotation'];
$salename_quotation = $_POST['salename_quotation'];
$sale_edit_id = $_POST['sale_edit_id'];
$date_edit = $_POST['date_edit'];
$rewrite_old = $_POST[rewrite_old];
$quotation_status = $_POST['quotation_status'];
$coment_quotation_id = $_POST['coment_quotation_id'];
$sql = "UPDATE quotation SET id_quotation='$id_quotation',companyid_quotation='$companyid_quotation',customercompany_quotation='$customercompany_quotation',date_quotation='$date_quotation',customer_address_quotation='$customer_address_quotation',tel_quotation='$tel_quotation',email_customer='$email_customer',fax_quotation='$fax_quotation',customername_quotation='$customername_quotation',customer_tel='$customer_tel',project='$project',product_quotation='$product_quotation',staticprice_quotation='$staticprice_quotation',methodpayprice_quotation='$methodpayprice_quotation',sendproduct_quotation='$sendproduct_quotation',sendproductposition_quotation='$sendproductposition_quotation',comment_quotation='$comment_quotation',salename_quotation='$salename_quotation', id_group='$id_group', sale_edit_id='$sale_edit_id', date_edit='$date_edit', rewrite_old = '$rewrite_old', quotation_status= '$quotation_status', coment_quotation_id='$coment_quotation_id', quotation_zone = '$zone' WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
//Table no_quotation
for($x = 1; $x <=50; $x++){
$no = $_POST['no'.$x.'_quotation'];
$fiel = "no".$x."_quotation";
$sql = "UPDATE no_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
}
//Table detail_quotation
for($x = 1; $x <=50; $x++){
$no = trim($_POST['detail'.$x.'_quotation']);
$fiel = "detail".$x."_quotation";
$sql = "UPDATE detail_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
}
//Tablr num_quotation
for($x = 1; $x <=50; $x++){
$no = trim($_POST['num_'.$x.'_quotation']);
$fiel = "num_".$x."_quotation";
$sql = "UPDATE num_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
}
//Table price_quotation
for($x = 1; $x <=50; $x++){
$no = trim($_POST['price_'.$x.'_quotation']);
$fiel = "price_".$x."_quotation";
$sql = "UPDATE price_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
}
//Table percen_quotation
for($x = 1; $x <=50; $x++){
$no = trim($_POST['percen'.$x.'_quotation']);
$fiel = "percen".$x."_quotation";
$sql = "UPDATE percen_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
}
//Table sumprice_quotation
for($x = 1; $x <=50; $x++){
$no = trim($_POST['sumprice_'.$x.'_quotation']);
$fiel = "sumprice_".$x."_quotation";
$sql = "UPDATE sumprice_quotation SET $fiel='$no'WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
}
//Table sum_all
$sumallprice_quotation = trim($_POST['sumallprice_quotation']);
$cash_discount_quotation = trim($_POST[cash_discount_quotation]);
$sum_discount_quotation = trim($_POST[sum_discount_quotation]);
$vat_quotation = trim($_POST['vat_quotation']);
$endprice_quotation = trim($_POST['endprice_quotation']);
$sql = "UPDATE sum_all SET sumallprice_quotation='$sumallprice_quotation', cash_discount_quotation='$cash_discount_quotation', sum_discount_quotation='$sum_discount_quotation', vat_quotation='$vat_quotation', endprice_quotation='$endprice_quotation' WHERE id_num='$id_num' ";
mysql_select_db($database_yonghong, $yonghong);
mysql_query($sql, $yonghong) or die(mysql_error());
echo "<meta http-equiv=refresh content=0;URL=Quotation_Show.php?id_quotation={$id_num}>";
}
mysql_free_result($select_group);
?>
Tag : PHP, MySQL, CakePHP
|
|
|
 |
 |
 |
 |
| Date :
2013-05-06 09:29:18 |
By :
SUPAKIT |
View :
1078 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
รันแล้วมันขึ้นแบบนี้ครับ
|
| |
|
|
| |
| Date :
2013-05-06 10:00:24 |
By :
SUPAKIT |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
