ผลงานของสมาชิก nuiii044

ความคิดเห็นที่ 3

3 ธันวาคม 2563 21:50:34 (IP 1.46.142.xxx)

$value) { //echo "key = $key value = $value
"; $value_name = $key; $$value_name = $value; } $today = date("Y-m-d H:i:s"); // add $sql_add = " insert book set b_number = '".addslashes($b_number)."' ,b_number2 = '".addslashes($b_number2)."' ,b_number3 = '".addslashes($b_number3)."' ,b_t = '".addslashes($b_t)."' ,start_date = '".ymd($start_date)."' ,b_g = '$b_g' ,b_go = '".addslashes($b_go)."' ,b_h = '$b_h' ,bo_type = '".addslashes($bo_type)."' ,b_f = '$b_f' ,b_m = '$b_m' ,bo_m = '".addslashes($bo_m)."' ,b_type = '$b_type' ,cur = '$cur' ,h2r = '$h2r' ,create_date = '".date('Y-m-d H:i:s')."' ,admin_id = '".$_SESSION['SS_ADMIN_ID']."' ,ip_add = '".getRealIpAddr()."' "; //echo ""; //exit(); if(mysql_query($sql_add)) { // id book $sql_id = "select b_id from book where admin_id = '".$_SESSION['SS_ADMIN_ID']."' and ip_add = '".getRealIpAddr()."' order by b_id DESC limit 0,1"; $result = mysql_query($sql_id) or die(mysql_error()); $row = mysql_fetch_array($result); $last_id = $row['b_id']; $msg = "
บันทึกข้อมูลรหัสรายการที่ $last_id สำเร็จแล้ว
"; // add detail if($last_id != "") { // $_REQUEST['id'] = $last_id; for($i = 0;$i 0) { $sql_add = "insert repair set book_detail_id = '$barcode_id' , re_detail = '".addslashes($b_detail[$i])."' , re_detail2 = '".$price_detail[$i]."' , re_w = '' , re_number = '$barcode_number' , re_create_date = '$today' , re_date = '".ymd($start_date)."' "; mysql_query($sql_add) or die(mysql_error()); } else { $msg.= "ไม่สามารถลงประวัติซ่อมบำรุง เนื่องจากไม่พบ barcode $txt_barcode นี้มีอยุ่ในระบบ"; } } } } // p1 add if($_REQUEST[p1] != "") { $sql_set = "select * from setting where admin_id = '".$_SESSION['SS_ADMIN_ID']."' order by setting_id DESC limit 0,1"; $result_set = mysql_query($sql_set) or die(mysql_error()); $row_set = mysql_fetch_array($result_set); $sql_addupdate = "";; if(!empty($row_set)) { foreach($row_set as $key => $value) { //echo "key = $key value = $value
"; if($key != "0" and $key < 1) { $value_name = $key; $$value_name = $value; if($value_name !="book_id" and $value_name !="admin_id" and $value_name != "p1" and $value_name != "setting_id") { $sql_addupdate.=",$value_name = '$value' "; } //echo "$key = $value
"; } } } $sql_adds = "insert setting set p1 = '".$_REQUEST[p1]."' , book_id = '$last_id' ,admin_id = '".$_SESSION['SS_ADMIN_ID']."' $sql_addupdate"; mysql_query($sql_adds) or die(mysql_error()); } } } else { mysql_error(); } } if($_POST['edit'])// แก้ไข { $tdate = $_POST['start_date']; //print_r($_POST); $id = $_REQUEST['id']; foreach($_POST as $key => $value) { //echo "key = $key value = $value
"; $value_name = $key; $$value_name = $value; } // add $permission = "Yes"; $sql_add = " update book set b_number = '".addslashes($b_number)."' ,b_number2 = '".addslashes($b_number2)."' ,b_number3 = '".addslashes($b_number3)."' ,b_t = '".addslashes($b_t)."' ,start_date = '".ymd($start_date)."' ,b_g = '$b_g' ,b_go = '".addslashes($b_go)."' ,b_h = '$b_h' ,bo_type = '".addslashes($bo_type)."' ,b_f = '$b_f' ,b_m = '$b_m' ,bo_m = '".addslashes($bo_m)."' ,b_type = '$b_type' ,cur = '$cur' ,h2r = '$h2r' where b_id = '$id' and (admin_id = '".$_SESSION['SS_ADMIN_ID']."' or '$permission' = 'Yes') "; //echo "$sql_add"; //exit(); //mysql_query($sql_add) or die(mysql_error());; if(mysql_query($sql_add)) { // id book //echo"added"; $last_id = $id; $msg = "
บันทึกข้อมูลรหัสรายการที่ $last_id สำเร็จแล้ว
"; // add detail if($last_id != "") { $_REQUEST['id'] = $last_id; //clear $sql_del = "delete from book_detail where book_id = '$last_id'"; mysql_query($sql_del) or die(mysql_error()); for($i = 0;$i 0) { $sql_add = "insert repair set book_detail_id = '$barcode_id' , re_detail = '".addslashes($b_detail[$i])."' , re_detail2 = '".$price_detail[$i]."' , re_w = '' , re_number = '$barcode_number' , re_create_date = '$today' , re_date = '".ymd($start_date)."' "; mysql_query($sql_add) or die(mysql_error()); } else { $msg.= "ไม่สามารถลงประวัติซ่อมบำรุง เนื่องจากไม่พบ barcode $txt_barcode นี้มีอยุ่ในระบบ"; } } } } // p1 add if($_REQUEST[p1] != "") { $sql_adds = "update setting set p1 = '".$_REQUEST[p1]."' where book_id = '$last_id' "; mysql_query($sql_adds) or die(mysql_error()); } } } else { mysql_error(); } } // ยืนยัน if($_POST['confirm']) { $id = $_REQUEST['id']; $permission = permission_test(2); $sql_update = "update book set book_confirm = 'Yes' where b_id = '$id' and (admin_id = '".$_SESSION['SS_ADMIN_ID']."' or '$permission' = 'Yes') and book_confirm = 'No'"; if(mysql_query($sql_update)) { $msg = "
ยืนยันรายการสิ่งซื้อรหัส $id สำเร็จแล้ว
"; } else { $msg = "
ยืนยันการสั่งซื้อรหัส $last_id ไม่สำเร็จ
"; } } if($_REQUEST['id'] != "") { $tid = $_REQUEST['id']; $sql = "select * from book where book.b_id = '$tid'"; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_array($result); //print_r($row); foreach($row as $key => $value) { //echo "key = $key value = $value
"; if($key != "0" and $key < 1) { $value_name = $key; $$value_name = $value; //echo "$key = $value
"; } } // ชื่อหัวหน้ากลุ่มสาระ $sql_setting = "select p1 from setting where book_id = '$tid'"; $result_setting = mysql_query($sql_setting) or die(mysql_error()); $rowsetting= mysql_fetch_array($result_setting); } // gen list $sql_list = "select * from item_type where list_sub_id = '0' and type_status = '0' order by item_type_name ASC"; $result_list = mysql_query($sql_list) or die(mysql_error()); $list_id_arr = ""; $list_name_arr = ""; $sub_list_arr = ""; $sub_list_name_arr = ""; $txt_list_value = ""; while($row_list = mysql_fetch_array($result_list)) { $list_id_arr[] = $row_list[item_type_id]; $m_id = $row_list[item_type_id]; $list_name_arr[] = $row_list[item_type_name]; $txt_list_value.=""; // get_sub $sql_sub = "select * from item_type where list_sub_id = '$m_id' and type_status = '0' "; $result_sub = mysql_query($sql_sub) or die(mysql_error()); while($row_sub = mysql_fetch_array($result_sub)) { $sub_list_arr[$m_id][] = $row_sub[item_type_id]; $sub_list_name_arr[$m_id][] = $row_sub[item_type_name]; } } //print_r($list_name_arr); ?>

----------------------------------
ขึ้นแบบนี้แก้ไขยังไง

ความคิดเห็นที่ 2

19 มิถุนายน 2558 10:33:27 (IP 182.93.216.xxx)

ผมเข้าใช้ไม่ได้ครับ
กรอก user admin
pass: admin ก็ไม่เข้าครับ

ความคิดเห็นที่ 1

21 พฤศจิกายน 2555 00:45:10 (IP 27.55.15.xxx)

จะขอเผยแพร่โปรแกรมฟรีครับ