예제 #1
0
if ($num_po_dtl > 0) {
    $nArrItems = rtrim($nArrItems, "|");
}
if (isset($_POST['update'])) {
    $difference = $_POST['difference'];
    $paymentterm = $_POST['payment_terms'];
    $item = explode(":", $_POST['txtItemsArr']);
    $price = explode(":", $_POST['txtPricesArr']);
    $discount = str_replace(",", "", $_POST['discount']);
    $subtotal = str_replace(",", "", $_POST['subtotal']);
    $vat = str_replace(",", "", $_POST['vat']);
    $totalamount = str_replace(",", "", $_POST['total_amount']);
    switch ($_POST['status']) {
        case 1:
            //UPDATE
            $rrrefno = getNewNum('RECEIVING_REPORT');
            $rr_mst = "INSERT INTO tbl_rr_mst(rr_reference_no,rr_date,po_reference_no,received_by,received_date,discount,sub_total,vat,total_amount)\n\t\t\t\t\t\t\t\t\tVALUES('{$rrrefno}','{$today}','{$id}','{$_SESSION['username']}','{$today}','{$discount}',\n\t\t\t\t\t\t\t\t\t\t\t'{$subtotal}',\n\t\t\t\t\t\t\t\t\t\t\t'{$vat}',\n\t\t\t\t\t\t\t\t\t\t\t'{$totalamount}')";
            $res = mysql_query($rr_mst) or die("SAVING RR " . mysql_error());
            $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'RECEIVING_REPORT' ";
            mysql_query($update_controlno);
            $cnt = 1;
            $ttlrrqty = 0;
            for ($i = 0; $i < count($item); $i++) {
                $itemcode = $item[$i];
                $itemprice = $price[$i];
                $qty = $_POST['txt' . $itemcode];
                $ttlrrqty += $qty;
                // $sql_item = "SELECT * FROM tbl_items WHERE item_code = '$itemcode'";
                $sql_item = "SELECT tbl_items.item_code,tbl_items.item_description,tbl_parts.part_onhand AS onhand,'parts' AS item_type\n\t\t\t\t\t\t\t\t\t\tFROM tbl_items\n\t\t\t\t\t\t\t\t\t\t\tJOIN tbl_parts ON tbl_parts.item_code = tbl_items.item_code\n\t\t\t\t\t\t\t\t\t\tWHERE tbl_items.item_code = '{$itemcode}'\n\n\t\t\t\t\t\t\t\t\t\tUNION\n\n\t\t\t\t\t\t\t\t\t\tSELECT tbl_items.item_code,tbl_items.item_description,tbl_material.material_onhand AS onhand,'material' AS item_type\n\t\t\t\t\t\t\t\t\t\tFROM tbl_items\n\t\t\t\t\t\t\t\t\t\t\tJOIN tbl_material ON tbl_material.item_code = tbl_items.item_code\n\t\t\t\t\t\t\t\t\t\tWHERE tbl_items.item_code = '{$itemcode}'\n\n\t\t\t\t\t\t\t\t\t\tUNION\n\n\t\t\t\t\t\t\t\t\t\tSELECT tbl_items.item_code,tbl_items.item_description,tbl_accessory.access_onhand AS onhand,'lubricants' AS item_type\n\t\t\t\t\t\t\t\t\t\tFROM tbl_items\n\t\t\t\t\t\t\t\t\t\t\tJOIN tbl_accessory ON tbl_accessory.item_code = tbl_items.item_code\n\t\t\t\t\t\t\t\t\t\tWHERE tbl_items.item_code = '{$itemcode}'";
                $qry_item = mysql_query($sql_item);
                while ($row = mysql_fetch_array($qry_item)) {
예제 #2
0
        break;
    case 1:
        $payment = "payment_id = 'PAY00000003'";
        break;
    case 2:
        $payment = "payment_id = 'PAY00000004'";
        break;
    default:
        break;
}
$qrybillingdtl = "SELECT * FROM v_for_billing_detail WHERE customer_id = '{$custid}' AND {$payment}";
$resbillingdtl = $dbo->query($qrybillingdtl);
if (isset($_POST['billed']) && !empty($_POST['billed']) && $_POST['billed'] == 1) {
    $total_amnt = str_replace(",", "", $_POST['txtGrandTotal']);
    $sql = null;
    $newrefno = getNewNum('BILLING');
    $sql3 = null;
    foreach ($_REQUEST['chkworefno'] as $val) {
        $sql1 = null;
        $sql2 = null;
        $val = explode("#", $val);
        $wo = $val[0];
        $amnt = $val[1];
        $sql1 = "INSERT INTO tbl_billing(wo_refno,billing_refno,billing_date,total_amount)\n\t\t\t\t\tVALUES('{$wo}','{$newrefno}','{$today}','{$amnt}'); ";
        $sql2 = "UPDATE tbl_service_master SET trans_status = '6' WHERE wo_refno = '{$wo}'; ";
        mysql_query($sql1);
        mysql_query($sql2);
    }
    $sql3 = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'BILLING'; ";
    $res = mysql_query($sql3);
    if (!$res) {
예제 #3
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $package = $_POST['package'];
    $newnum = getNewNum('PACKAGE');
    $employee_insert = "INSERT INTO tbl_package_master (package_id,package_name,created_by,created_date) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $package . "',\n\t\t'" . $_SESSION['username'] . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'PACKAGE' ";
    $res = mysql_query($employee_insert) or die("INSERT EMPLOYEE " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your package profile! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Package profile successfully saved.");</script>';
    }
    echo '<script>window.location="package_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</script>

</head>
<body>
예제 #4
0
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
$qry_items = "SELECT * FROM v_items WHERE status = '1' ORDER BY item_description";
$result_items = $dbo->query($qry_items);
if (isset($_POST['save'])) {
    $parts = strtoupper($_POST['parts']);
    $parts_discount = str_replace(",", "", $_POST['parts_discount']);
    $part_srp = str_replace(",", "", $_POST['part_srp']);
    $part_onhand = $_POST['part_onhand'];
    $parts_lowstock = $_POST['parts_lowstock'];
    $partstatus = $_POST['partstatus'];
    $new_price_date = date("Y-m-d h:i:s");
    $item_code = $_POST['item_code'];
    $newnum = getNewNum('PARTS');
    $parts_insert = "INSERT INTO tbl_parts (parts_id, parts, parts_discount, part_srp, part_onhand, parts_lowstock, partstatus, part_created, new_price_date,item_code) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $parts . "',\n\t\t'" . $parts_discount . "',\n\t\t'" . $part_srp . "',\n\t\t'" . $part_onhand . "',\n\t\t'" . $parts_lowstock . "',\n\t\t'" . $partstatus . "',\n\t\t'" . $today . "',\n\t\t'" . $new_price_date . "',\n\t\t'" . $item_code . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'PARTS' ";
    $res = mysql_query($parts_insert) or die("INSERT PARTS " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your parts! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Parts successfully saved.");</script>';
    }
    echo '<script>window.location="parts_list.php";</script>';
}
?>
<html>
<head>
<title></title>
예제 #5
0
$ses_id = session_id();
require_once "conf/db_connection.php";
require_once "functions.php";
if (isset($_POST['save']) && !empty($_POST['save']) && $_POST['save'] == 1) {
    $customerid = $_POST['customer_id'];
    $vehicleid = $_POST['plateno'];
    $payment = $_POST['paymentmode'];
    $remarks = $_POST['txtremarks'];
    $subtotal = trim(str_replace(",", "", $_POST['subtotal']));
    $discount = trim(str_replace(",", "", $_POST['discount']));
    $discounted_price = trim(str_replace(",", "", $_POST['discounted_price']));
    $vat = $_POST['vat'];
    $total_amount = trim(str_replace(",", "", $_POST['totalamount']));
    $qrytempestimate = "SELECT * FROM v_temp_estimate WHERE ses_id = '{$ses_id}'";
    $restempestimate = $dbo->query($qrytempestimate);
    $estimate_refno = getNewNum('ESTIMATEREFNO');
    $sql = null;
    $sql .= "INSERT INTO tbl_service_master\n\t\t\t(estimate_refno,transaction_date,customer_id,vehicle_id,payment_id,subtotal_amount,discount,discounted_price,vat,total_amount,created_by,remarks)\n\t\t\tVALUES('{$estimate_refno}','{$today}','{$customerid}','{$vehicleid}','{$payment}','{$subtotal}','{$discount}','{$discounted_price}','{$vat}','{$total_amount}','{$ses_UserID}','{$remarks}'); ";
    foreach ($restempestimate as $rowtempestimate) {
        $sql .= "INSERT INTO tbl_service_detail\n\t\t\t\t(estimate_refno,type,id,amount)\n\t\t\t\tVALUES('{$estimate_refno}','{$rowtempestimate['type']}','{$rowtempestimate['id']}','{$rowtempestimate['rate']}'); ";
    }
    $sql .= "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'ESTIMATEREFNO'; ";
    $sql .= "DELETE FROM tbl_temp_estimate WHERE ses_id = '{$ses_id}'; ";
    $qry = $dbo->query($sql);
    if (!$qry) {
        echo '<script>alert("There has been an error on saving your service! Please double check all the data and save.");</script>';
    } else {
        echo '<script>alert("Service successfully saved.");</script>';
    }
    echo '<script>window.location="estimate.php";</script>';
}
예제 #6
0
 $subtotal = $_POST['subtotal'];
 $discount = $_POST['discount'];
 $vat = $_POST['vat'];
 $discounted_price = $_POST['discounted_price'];
 $total_amount = $_POST['totalamount'];
 $remarks = $_POST['remarks'];
 $file = $_FILES['txtattachment']['name'];
 $qry = null;
 $getqryservice = "SELECT * FROM v_service_master WHERE estimate_refno = '{$estimaterefno}'";
 $getresservice = $dbo->query($getqryservice);
 foreach ($getresservice as $rowresservice) {
     $worefno = $rowresservice['wo_refno'];
 }
 $getqrytemppodetail = "SELECT * FROM v_temp_po_detail WHERE ses_id = '{$ses_id}'";
 $getrestemppodetail = $dbo->query($getqrytemppodetail);
 $new_refno = getNewNum('PURCHASEORDER');
 if (!empty($file)) {
     $upload_path = 'attachments/';
     $ext = substr($file, strpos($file, '.'), strlen($file) - 1);
     $attachment = $new_refno . $ext;
     move_uploaded_file($_FILES['txtattachment']['tmp_name'], $upload_path . $attachment);
 }
 $qry .= "INSERT INTO tbl_po_master(estimate_refno,wo_refno,po_refno,attachment,transaction_date,payment_id,subtotal_amount,discount,discounted_price,vat,total_amount,remarks,created_by)\n\t\t\t\tVALUES('{$estimaterefno}','{$worefno}','{$new_refno}','{$attachment}','{$today}','{$payment}','{$subtotal}','{$discount}','{$discounted_price}','12','{$total_amount}','{$remarks}','asdf'); ";
 foreach ($getrestemppodetail as $rowTEMPPODETAIL) {
     $qry .= "INSERT INTO tbl_po_detail(po_refno,type,description,amount)\n\t\t\t\t\tVALUES('{$new_refno}','{$rowTEMPPODETAIL['type']}','{$rowTEMPPODETAIL['description']}','{$rowTEMPPODETAIL['amount']}'); ";
 }
 $qry .= "UPDATE tbl_service_master SET po_refno = '{$new_refno}' WHERE estimate_refno = '{$estimaterefno}'; ";
 $qry .= "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'PURCHASEORDER'; ";
 $qry .= "DELETE FROM tbl_temp_po_detail WHERE ses_id = '{$ses_id}'; ";
 $res = $dbo->query($qry);
 $msg = "created";
예제 #7
0
    }
    if (!empty($estimateno)) {
        $where .= " AND estimate_refno LIKE '{$estimateno}%'";
    }
    $qryservices = new v_service_master();
    $resservices = $dbo->query($qryservices->Query($where));
}
if (isset($_POST['option']) && !empty($_POST['option']) && $_POST['option'] == 1) {
    $cntERNo = count($_POST['chkEstimateRefNo']);
    if ($cntERNo > 0) {
        switch ($_POST['opt']) {
            case 1:
                $cnt = 1;
                $qry = null;
                foreach ($_REQUEST['chkEstimateRefNo'] as $val) {
                    $new_refno = getNewNum('WORKORDER', $cnt);
                    $qry .= "UPDATE tbl_service_master SET wo_refno = '{$new_refno}', trans_status = '1' WHERE estimate_refno = '{$val}'; ";
                    $cnt++;
                }
                $qry .= "UPDATE tbl_controlno SET lastseqno = (lastseqno + {$cnt}) WHERE control_type = 'WORKORDER'; ";
                $res = $dbo->query($qry);
                $msg = "approved";
                break;
            case 2:
                $qry = null;
                foreach ($_REQUEST['chkEstimateRefNo'] as $val) {
                    $qry .= "UPDATE tbl_service_master SET trans_status = '2' WHERE estimate_refno = '{$val}'; ";
                }
                $res = $dbo->query($qry);
                $msg = "disapproved";
                break;
예제 #8
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $desc = $_POST['description'];
    $newnum = getNewNum('PAYMENT_TERM');
    $payment_term_insert = "INSERT INTO tbl_payment_term (payment_term_code,description,created_date) VALUES \n\t \t('" . $newnum . "',\n\t \t'" . $desc . "',\n\t \t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'PAYMENT_TERM' ";
    $res = mysql_query($payment_term_insert) or die("INSERT PAYMENT TERM " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your payment term! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Payment term successfully saved.");</script>';
    }
    echo '<script>window.location="payment_term_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</head>
<body>
	<form method="post" name="payment_term_form" class="form" onsubmit="return ValidateMe();">
	<fieldset form="form_payment_term" name="form_payment_term">
예제 #9
0
 $serial = $_POST['serial'];
 $remarks = $_POST['txtremarks'];
 $payment = $_POST['paymentmode'];
 $subtotal = trim(str_replace(",", "", $_POST['subtotal']));
 $discount = trim(str_replace(",", "", $_POST['discount']));
 $discounted_price = trim(str_replace(",", "", $_POST['discounted_price']));
 $vat = $_POST['vat'];
 $total_amount = trim(str_replace(",", "", $_POST['totalamount']));
 if ($_POST['txtrecommendation']) {
     $recommendation = $_POST['txtrecommendation'];
 } else {
     $recommendation = null;
 }
 $qrytempestimate = "SELECT * FROM v_temp_estimate WHERE ses_id = '{$ses_id}'";
 $restempestimate = $dbo->query($qrytempestimate);
 $oe_no = getNewNum('ONLINE_ESTIMATE');
 $sql = null;
 $sql .= "INSERT INTO tbl_online_estimate_master\n\t\t\t(oe_id,transaction_date,customer,address,contactno,emailaddress,plateno,year,make,model,color,variant,engineno,chassisno,serialno,remarks,recommendation,payment_id,subtotal_amount,discount,discounted_price,vat,total_amount)\n\t\t\tVALUES('{$oe_no}','{$today}','{$customer}','{$address}','{$contactno}','{$emailaddress}','{$plateno}','{$year}','{$make}','{$model}','{$color}','{$variant}','{$engine}','{$chassis}','{$serial}','{$remarks}','{$recommendation}','{$payment}','{$subtotal}','{$discount}','{$discounted_price}','{$vat}','{$total_amount}'); ";
 foreach ($restempestimate as $rowtempestimate) {
     $sql .= "INSERT INTO tbl_online_estimate_detail\n\t\t\t\t(oe_id,type,id,amount)\n\t\t\t\tVALUES('{$oe_no}','{$rowtempestimate['type']}','{$rowtempestimate['id']}','{$rowtempestimate['rate']}'); ";
 }
 $sql .= "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'ONLINE_ESTIMATE'; ";
 $sql .= "DELETE FROM tbl_temp_estimate WHERE ses_id = '{$ses_id}'; ";
 $qry = $dbo->query($sql);
 if (!$qry) {
     echo '<script>alert("There has been an error on saving your service! Please double check all the data and save.");</script>';
 } else {
     echo '<script>alert("Service successfully saved. Please print a copy, this will serve as your reference.");</script>';
 }
 echo '<script>window.open("online_estimate_print.php?oe_id=' . $oe_no . '");</script>';
 // echo '<script>window.location="estimate_add1.php";</script>';
예제 #10
0
require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
$qry_items = "SELECT * FROM v_items WHERE status = '1' ORDER BY item_description";
$result_items = $dbo->query($qry_items);
if (isset($_POST['save'])) {
    $accessory = strtoupper($_POST['accessory']);
    $access_disc = str_replace(",", "", $_POST['access_disc']);
    $access_srp = str_replace(",", "", $_POST['access_srp']);
    $access_onhand = $_POST['access_onhand'];
    $access_low = $_POST['access_low'];
    $access_status = $_POST['access_status'];
    $item_code = $_POST['item_code'];
    $newnum = getNewNum('ACCESSORY');
    $accessory_insert = "INSERT INTO tbl_accessory (accessory_id, accessory, access_disc, access_srp, access_onhand, access_low, access_status, access_created, item_code) VALUES \n\t\t('" . $newnum . "',\n\t\t'" . $accessory . "',\n\t\t'" . $access_disc . "',\n\t\t'" . $access_srp . "',\n\t\t'" . $access_onhand . "',\n\t\t'" . $access_low . "',\n\t\t'" . $access_status . "',\n\t\t'" . $today . "',\n\t\t'" . $item_code . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'ACCESSORY' ";
    $res = mysql_query($accessory_insert) or die("INSERT ACCESSORY " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your accessory! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Accessory successfully saved.");</script>';
    }
    echo '<script>window.location="accessory_list.php";</script>';
}
?>
<html>
<head>
<title></title>
예제 #11
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $make = strtoupper($_POST['make']);
    $make_rate = str_replace(",", "", $_POST['make_rate']);
    $newnum = getNewNum('MAKE');
    $make_insert = "INSERT INTO tbl_make (make_id, make, make_rate, make_created) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $make . "',\n\t\t'" . $make_rate . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'MAKE' ";
    $res = mysql_query($make_insert) or die("INSERT MAKE " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your make! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Make successfully saved.");</script>';
    }
    echo '<script>window.location="make_list.php";</script>';
}
?>
<html>
<head>
<title></title>

<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</script>
예제 #12
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $idle_name = strtoupper($_POST['idle_name']);
    $newnum = getNewNum('IDLE');
    $idle_insert = "INSERT INTO tbl_idle (idle_id, idle_name, idle_created) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $idle_name . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'IDLE' ";
    $res = mysql_query($idle_insert) or die("INSERT IDLE " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your idle! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Idle successfully saved.");</script>';
    }
    echo '<script>window.location="idle_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  

</head>
<body>
	<form method="post" name="color_form" class="form" onSubmit="return ValidateMe();">
예제 #13
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $wocat = strtoupper($_POST['wocat']);
    $newnum = getNewNum('WOCATEGORY');
    $wocat_insert = "INSERT INTO tbl_wocat (wocat_id, wocat, wocat_created) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $wocat . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'WOCATEGORY' ";
    $res = mysql_query($wocat_insert) or die("INSERT WOCAT " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your work order category! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Work order category successfully saved.");</script>';
    }
    echo '<script>window.location="wocategory_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</head>
<body>
	<form method="post" name="wocat_form" class="form" onSubmit="return ValidateMe();">
	<fieldset form="form_wocat" name="form_wocat">
예제 #14
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $color = strtoupper($_POST['color']);
    $newnum = getNewNum('COLOR');
    $color_insert = "INSERT INTO tbl_color (color_id,color,color_created) VALUES\n\t\t('{$newnum}','{$color}','{$today}') ";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'COLOR' ";
    $res = mysql_query($color_insert) or die("INSERT COLOR " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your color! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Color successfully saved.");</script>';
    }
    echo '<script>window.location="color_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</script>
</head>
<body>
	<form method="post" name="color_form" class="form" onSubmit="return ValidateMe();">
예제 #15
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $desc = $_POST['description'];
    $newnum = getNewNum('ITEM_TYPE');
    $item_type_insert = "INSERT INTO tbl_item_type (item_type_code,description,created_date) VALUES \n\t \t('" . $newnum . "',\n\t \t'" . $desc . "',\n\t \t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'ITEM_TYPE' ";
    $res = mysql_query($item_type_insert) or die("INSERT ITEM TYPE " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your Item Type! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Item Type successfully saved.");</script>';
    }
    echo '<script>window.location="item_type_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</head>
<body>
	<form method="post" name="item_type_form" class="form" onsubmit="return ValidateMe();">
	<fieldset form="form_item_type" name="form_item_type">
예제 #16
0
파일: po_add.php 프로젝트: alladinxApp/qsms
$qry_payterms = "SELECT * FROM v_payment_term WHERE status = '1'";
$result_payterms = $dbo->query($qry_payterms);
$qry_items = "SELECT * FROM v_items WHERE status = '1'";
$result_items = $dbo->query($qry_items);
if (isset($_POST['save'])) {
    $supplier = $_POST['supplier'];
    $deliverto = $_POST['deliver_to'];
    $deliveryaddress = $_POST['delivery_address'];
    $special = $_POST['special'];
    $paymentterms = $_POST['payment_terms'];
    $discount = str_replace(",", "", $_POST['discount']);
    $subtotal = str_replace(",", "", $_POST['subtotal']);
    $vat = str_replace(",", "", $_POST['vat']);
    $totalamount = str_replace(",", "", $_POST['total_amount']);
    $item = explode("|", $_POST['arrItems']);
    $newnum = getNewNum('PURCHASE_ORDER');
    $po_mst_insert = "INSERT INTO tbl_po_mst (po_reference_no,po_date,supplier_code,deliver_to,delivery_address,payment_code,discount,sub_total,vat,total_amount,special_instruction,created_date,created_by) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $today . "',\n\t\t'" . $supplier . "',\n\t\t'" . $deliverto . "',\n\t\t'" . $deliveryaddress . "',\n\t\t'" . $paymentterms . "',\n\t\t'" . $discount . "',\n\t\t'" . $subtotal . "',\n\t\t'" . $vat . "',\n\t\t'" . $totalamount . "',\n\t\t'" . $special . "',\n\t\t'" . $today . "',\n\t\t'" . $_SESSION['username'] . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'PURCHASE_ORDER' ";
    $res = mysql_query($po_mst_insert) or die("INSERT PO " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your RO! Please double check all the data and save.");</script>';
    } else {
        $cnt = 1;
        for ($i = 0; $i < count($item); $i++) {
            $val = explode(":", $item[$i]);
            $qry_dtl = mysql_query("INSERT INTO tbl_po_dtl(po_reference_no,item_code,price,quantity,seqno) VALUES\n\t\t\t\t\t('" . $newnum . "',\n\t\t\t\t\t'" . $val[0] . "',\n\t\t\t\t\t'" . $val[4] . "',\n\t\t\t\t\t'" . $val[5] . "',\n\t\t\t\t\t'" . $cnt . "')");
            $cnt++;
        }
        mysql_query($update_controlno);
        echo '<script>alert("PO successfully saved.");</script>';
    }
예제 #17
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $employee = strtoupper($_POST['employee']);
    $position = $_POST['position'];
    $image = $_FILES['emp_image']['name'];
    $newnum = getNewNum('EMPLOYEE');
    if (!empty($image)) {
        $upload_path = 'images/employees/';
        $ext = substr($image, strpos($image, '.'), strlen($image) - 1);
        if (file_exists($upload_path . $image)) {
            unlink($upload_path . $image);
        }
        $img = $newnum . $ext;
        move_uploaded_file($_FILES['emp_image']['tmp_name'], $upload_path . $img);
    } else {
        $img = 'no-image.png';
    }
    $employee_insert = "INSERT INTO tbl_employee (emp_id,employee,position, emp_image, emp_created) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $employee . "',\n\t\t'" . $position . "',\n\t\t'" . $img . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'EMPLOYEE' ";
    $res = mysql_query($employee_insert) or die("INSERT EMPLOYEE " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your employee profile! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Employee profile successfully saved.");</script>';
예제 #18
0
$nArrItems = null;
foreach ($result_rr_dtl as $row) {
    $itemcode = $row['item_code'];
    $itemdesc = $row['item_description'];
    $itemuom = $row['UOM'];
    $itemuomdesc = $row['UOM_desc'];
    $itemprice = $row['price'];
    $itemqty = $row['quantity'];
    $itemrrttl = $row['rr_total'];
    $nArrItems .= $itemcode . ":" . $itemdesc . ":" . $itemuom . ":" . $itemuomdesc . ":" . $itemprice . ":" . $itemqty . ":" . $itemrrttl . "|";
}
if ($num_rr_dtl > 0) {
    $nArrItems = rtrim($nArrItems, "|");
}
if (isset($_POST['update'])) {
    $newnum = getNewNum('RR_POSTING');
    $po_mst_upd = "UPDATE tbl_po_mst \n\t\t\tSET rr_post_reference_no = '{$newnum}'\n\t\t\t\t,rr_post_date = '{$today}'\n\t\t\t\t,posted_by = '{$_SESSION['username']}'\n\t\t\tWHERE po_reference_no = '{$id}' ";
    $rr_mst_upd = "UPDATE tbl_rr_mst \n\t\t\tSET rr_post_reference_no = '{$newnum}'\n\t\t\t\t,rr_post_date = '{$today}'\n\t\t\t\t,posted_by = '{$_SESSION['username']}'\n\t\t\t\t,status = '1'\n\t\t\tWHERE po_reference_no = '{$id}' ";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'RR_POSTING' ";
    $res = mysql_query($po_mst_upd) or die("UPDATE Posting " . mysql_error());
    mysql_query($rr_mst_upd);
    if (!$res) {
        echo '<script>alert("There has been an error on posting your RR! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("RR successfully posted.");</script>';
    }
    echo '<script>window.location="rr_posting_edit.php?id=' . $id . '";</script>';
}
?>
<html>
예제 #19
0
session_start();
require_once "conf/db_connection.php";
require_once "functions.php";
$worefno = $_GET['worefno'];
$getempqry = new v_service_master();
$getempres = $dbo->query($getempqry->Query("WHERE wo_refno = '{$worefno}'"));
foreach ($getempres as $rowEMP) {
    $empid = $rowEMP['emp_id'];
    $estimaterefno = $rowEMP['estimate_refno'];
    if ($rowEMP['po_refno'] != '0') {
        $po_refno = $rowEMP['po_refno'];
    } else {
        $po_refno = '0';
    }
}
$billing_refno = getNewNum('BILLING');
$check_date = dateFormat($today, "Y-m-d H:i");
$qry = null;
$qry .= "UPDATE tbl_jobclock_checkin_checkout SET check_out = '{$check_date}' WHERE wo_refno = '{$worefno}'; ";
$qry .= "UPDATE tbl_jobclock_master SET job_end = '{$today}', job_status = '2' WHERE wo_refno = '{$worefno}'; ";
$qry .= "UPDATE tbl_service_master SET trans_status = '5' WHERE wo_refno = '{$worefno}'; ";
$qry .= "UPDATE tbl_po_master SET trans_status = '2' WHERE wo_refno = '{$worefno}'; ";
$res = $dbo->query($qry);
// GET DATA OF JOBCLOCK MASTER
$qryidletimehistorymst = "SELECT * FROM v_jobclock_master WHERE wo_refno = '{$worefno}'";
$residletimehistorymst = mysql_query($qryidletimehistorymst);
while ($row = mysql_fetch_array($residletimehistorymst)) {
    $jobstatus = $row['job_status'];
    $jobstart = $row['job_start'];
    $jobend = $row['job_end'];
}
예제 #20
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $model = strtoupper($_POST['model']);
    $variant = $_POST['model'];
    $variantdesc = $_POST['variantdesc'];
    $newnum = getNewNum('MODEL');
    $model_insert = "INSERT INTO tbl_model (model_id, model, variant, variantdesc, model_created) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $model . "',\n\t\t'" . $variant . "',\n\t\t'" . $variantdesc . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'MODEL' ";
    $res = mysql_query($model_insert) or die("INSERT MODEL " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your model! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Model successfully saved.");</script>';
    }
    echo '<script>window.location="model_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</script>
예제 #21
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $job = strtoupper($_POST['job']);
    $wocatid = $_POST['wocatid'];
    $stdhr = $_POST['stdhr'];
    $flagrate = $_POST['flagrate'];
    $stdrate = str_replace(",", "", $_POST['stdrate']);
    $newnum = getNewNum('JOB');
    $job_insert = "INSERT INTO tbl_job (job_id, job, wocat_id, stdhr, stdrate, flagrate) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $job . "',\n\t\t'" . $wocatid . "',\n\t\t'" . $stdhr . "',\n\t\t'" . $flagrate . "',\n\t\t'" . $stdrate . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'JOB' ";
    $res = mysql_query($job_insert) or die("INSERT JOB " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your job! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Job successfully saved.");</script>';
    }
    echo '<script>window.location="job_list.php";</script>';
}
$query = " SELECT * FROM v_wocat order by wocat_id";
$result = $dbo->query($query);
?>
<html>
<head>
<title</title>
예제 #22
0
if (!isset($_SESSION)) {
    session_start();
}
$qry_uom = "SELECT * FROM v_uom ORDER BY description";
$result_uom = $dbo->query($qry_uom);
$qry_item_type = "SELECT * FROM v_item_type ORDER BY description";
$result_item_type = $dbo->query($qry_item_type);
if (isset($_POST['save'])) {
    $sapitemcode = strtoupper($_POST['sap_item_code']);
    $desc = strtoupper($_POST['description']);
    $unitprice = str_replace(",", "", $_POST['unit_price']);
    $uom = $_POST['uom'];
    $lowstockvalue = $_POST['low_stock_value'];
    $lastunitprice = str_replace(",", "", $_POST['last_unit_price']);
    $itemtype = $_POST['item_type'];
    $newnum = getNewNum('ITEMS');
    $item_insert = "INSERT INTO tbl_items (item_code,SAP_item_code,item_description,unit_price,UOM,low_stock_value,last_unit_price,item_type,created_date) VALUES \n\t\t('" . $newnum . "',\n\t\t'" . $sapitemcode . "',\n\t\t'" . $desc . "',\n\t\t'" . $unitprice . "',\n\t\t'" . $uom . "',\n\t\t'" . $lowstockvalue . "',\n\t\t'" . $lastunitprice . "',\n\t\t'" . $itemtype . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'ITEMS' ";
    $res = mysql_query($item_insert) or die("INSERT ITEM " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your item! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Item successfully saved.");</script>';
    }
    echo '<script>window.location="items_list.php";</script>';
}
?>
<html>
<head>
<title></title>
예제 #23
0
$rescost_accessory = $dbo->query($qrycost_accessory->Query("WHERE estimate_refno = '{$estimaterefno}'"));
$numrow1 = count($rescost_accessory);
$qrycost_job = new v_service_detail_job();
$rescost_job = $dbo->query($qrycost_job->Query("WHERE estimate_refno = '{$estimaterefno}'"));
$qrycost_material = new v_service_detail_material();
$rescost_material = $dbo->query($qrycost_material->Query("WHERE estimate_refno = '{$estimaterefno}'"));
$numrow2 = count($rescost_material);
$qrycost_parts = new v_service_detail_parts();
$rescost_parts = $dbo->query($qrycost_parts->Query("WHERE estimate_refno = '{$estimaterefno}'"));
$numrow = count($rescost_parts);
$subtotal = 0;
if (isset($_POST['option']) && !empty($_POST['option']) && $_POST['option'] == 1) {
    $qry = null;
    switch ($_POST['opt']) {
        case 1:
            $new_refno = getNewNum('WORKORDER');
            $qry .= "UPDATE tbl_service_master SET wo_refno = '{$new_refno}',wo_trans_date = '{$today}', trans_status = '4' WHERE estimate_refno = '{$estimaterefno}'; ";
            $qry .= "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'WORKORDER'; ";
            // PARTS
            if ($numrow > 0) {
                // while($row = mysql_fetch_array($result)){
                foreach ($rescost_parts as $row) {
                    $qty = $row['qty'];
                    $starting = $row['parts_onhand'];
                    $ending = $row['parts_onhand'] - $qty;
                    $qry .= "UPDATE tbl_parts SET part_onhand = (part_onhand - {$qty}), parts_used = (parts_used + {$qty}) WHERE parts_id = '{$row['id']}'; ";
                    $qry .= "INSERT INTO tbl_po_inventory(item_code,beginning_balance,issued,issued_date,ending_balance,remarks,reference_no,item_type,created_date,created_by)\n\t\t\t\t\t\t\t\t\tVALUES('{$row['item_code']}','{$starting}','{$qty}','{$today}','{$ending}','{$new_refno}','{$new_refno}','parts','{$today}','{$_SESSION['username']}'); ";
                }
            }
            // ACCESSORY or LUBRICANTS
            if ($numrow1 > 0) {
예제 #24
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $year = $_POST['year'];
    $newnum = getNewNum('YEAR');
    $year_insert = "INSERT INTO tbl_year (year_id, year) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $year . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'YEAR' ";
    $res = mysql_query($year_insert) or die("INSERT YEAR " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your year! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Year successfully saved.");</script>';
    }
    echo '<script>window.location="year_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</script>
</head>
<body>
	<form method="post" name="year_form" class="form" onSubmit="return ValidateMe();">
예제 #25
0
}
if (isset($_POST['save'])) {
    $vehicle_id = $_POST['vehicle_id'];
    $customer_id = $_POST['customer_id'];
    $address = $_POST['customer_address'];
    $plate_no = strtoupper($_POST['plateno']);
    $year = $_POST['year'];
    $make = $_POST['make'];
    $model = $_POST['model'];
    $color = $_POST['color'];
    $variant = $_POST['variant'];
    $engine_no = $_POST['engineno'];
    $chassis_no = $_POST['chassisno'];
    $serial_no = $_POST['serialno'];
    $conductionsticker = $_POST['conductionsticker'];
    $newnum = getNewNum('VEHICLE');
    $vehiclelist_insert = "INSERT INTO tbl_vehicleinfo (vehicle_id,customer_id, address, plate_no, year, make, model, color, variant, engine_no, chassis_no, serial_no, conduction_sticker) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $customer_id . "',\n\t\t'" . $address . "',\n\t\t'" . $plate_no . "',\n\t\t'" . $year . "',\n\t\t'" . $make . "',\n\t\t'" . $model . "',\n\t\t'" . $color . "',\n\t\t'" . $variant . "',\n\t\t'" . $engine_no . "',\n\t\t'" . $chassis_no . "',\n\t\t'" . $serial_no . "',\n\t\t'" . $conductionsticker . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'VEHICLE' ";
    $res = mysql_query($vehiclelist_insert) or die("INSERT VEHICLE LIST " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your customers vehicle profile!");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Customers vehicle profile successfully saved.");</script>';
    }
    echo '<script>window.location="vehicle_list.php";</script>';
}
$qry = " SELECT * FROM v_customer order by lastname";
$result = $dbo->query($qry);
$qry1 = " SELECT * FROM v_customer order by lastname";
$result1 = $dbo->query($qry1);
예제 #26
0
require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
$qry_items = "SELECT * FROM v_items WHERE status = '1' ORDER BY item_description";
$result_items = $dbo->query($qry_items);
if (isset($_POST['save'])) {
    $material = strtoupper($_POST['material']);
    $material_disc = str_replace(",", "", $_POST['material_disc']);
    $material_srp = str_replace(",", "", $_POST['material_srp']);
    $material_onhand = $_POST['material_onhand'];
    $material_lowstock = $_POST['material_lowstock'];
    $material_status = $_POST['material_status'];
    $item_code = $_POST['item_code'];
    $newnum = getNewNum('MATERIAL');
    $material_insert = "INSERT INTO tbl_material (material_id, material, material_disc, material_srp, material_onhand, material_lowstock, material_status, material_created,item_code) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $material . "',\n\t\t'" . $material_disc . "',\n\t\t'" . $material_srp . "',\n\t\t'" . $material_onhand . "',\n\t\t'" . $material_lowstock . "',\n\t\t'" . $material_status . "',\n\t\t'" . $today . "',\n\t\t'" . $item_code . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'MATERIAL' ";
    $res = mysql_query($material_insert) or die("INSERT MATERIAL " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your material! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Material successfully saved.");</script>';
    }
    echo '<script>window.location="material_list.php";</script>';
}
?>
<html>
<head>
<title></title>
예제 #27
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $desc = $_POST['description'];
    $newnum = getNewNum('UOM');
    $uom_insert = "INSERT INTO tbl_uom (uom_code,description,created_date) VALUES \n\t \t('" . $newnum . "',\n\t \t'" . $desc . "',\n\t \t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'UOM' ";
    $res = mysql_query($uom_insert) or die("INSERT UOM " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your UOM! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("UOM successfully saved.");</script>';
    }
    echo '<script>window.location="uom_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  
</head>
<body>
	<form method="post" name="uom_form" class="form" onsubmit="return ValidateMe();">
	<fieldset form="form_uom" name="form_uom">
예제 #28
0
<?php

require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $payment = mysql_real_escape_string(strtoupper($_POST['payment']));
    $newnum = getNewNum('PAYMENT');
    $payment_insert = "INSERT INTO tbl_payment (payment_id, payment, payment_created) VALUES\n\t\t('" . $newnum . "',\n\t\t'" . $payment . "',\n\t\t'" . $today . "')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'PAYMENT' ";
    $res = mysql_query($payment_insert) or die("INSERT PAYMENT " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your payment! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Payment successfully saved.");</script>';
    }
    echo '<script>window.location="payment_list.php";</script>';
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style/cal.css" />
<link rel="stylesheet" type="text/css" href="style/forms.css" />  

</head>
<body>
	<form method="post" name="payment_form" class="form" onSubmit="return ValidateMe();">
예제 #29
0
require_once "conf/db_connection.php";
require_once "functions.php";
if (!isset($_SESSION)) {
    session_start();
}
if (isset($_POST['save'])) {
    $sapsuppliercode = $_POST['sap_supplier_code'];
    $suppliername = $_POST['supplier_name'];
    $address = $_POST['address'];
    $contactperson = $_POST['contact_person'];
    $phone = $_POST['phone'];
    $fax = $_POST['fax'];
    $email = $_POST['email'];
    $tin = $_POST['TIN'];
    $isvat = $_POST['isVat'];
    $newnum = getNewNum('SUPPLIER');
    $supplier_insert = "INSERT INTO tbl_suppliers (supplier_code,SAP_supplier_code,supplier_name,address,contact_person,phone,fax,email,TIN,isVat,created_date,status) VALUES \n\t \t('" . $newnum . "',\n\t \t'" . $sapsuppliercode . "',\n\t \t'" . $suppliername . "',\n\t \t'" . $address . "',\n\t \t'" . $contactperson . "',\n\t \t'" . $phone . "',\n\t \t'" . $fax . "',\n\t \t'" . $email . "',\n\t \t'" . $TIN . "',\n\t \t'" . $isvat . "',\n\t \t'" . $today . "','1')";
    $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'SUPPLIER' ";
    $res = mysql_query($supplier_insert) or die("INSERT SUPPLIER " . mysql_error());
    if (!$res) {
        echo '<script>alert("There has been an error on saving your supplier! Please double check all the data and save.");</script>';
    } else {
        mysql_query($update_controlno);
        echo '<script>alert("Supplier successfully saved.");</script>';
    }
    echo '<script>window.location="supplier_list.php";</script>';
}
?>
<html>
<head>
<title></title>
예제 #30
0
$nArrItems = null;
foreach ($result_rr_dtl as $row) {
    $itemcode = $row['item_code'];
    $itemdesc = $row['item_description'];
    $itemuom = $row['UOM'];
    $itemuomdesc = $row['UOM_desc'];
    $itemprice = $row['price'];
    $itemqty = $row['quantity'];
    $itemrr = $row['rr_quantity'];
    $nArrItems .= $itemcode . ":" . $itemdesc . ":" . $itemuom . ":" . $itemuomdesc . ":" . $itemprice . ":" . $itemqty . "|";
}
if ($num_rr_dtl > 0) {
    $nArrItems = rtrim($nArrItems, "|");
}
if (isset($_POST['update'])) {
    $newnum = getNewNum('CV_REFERENCE');
    switch ($_POST['status']) {
        case 1:
            // BILLED
            $po_mst_upd = "UPDATE tbl_po_mst \n\t\t\t\t\t\tSET cv_reference_no = '{$newnum}'\n\t\t\t\t\t\t\t,payment_date = '{$today}'\n\t\t\t\t\t\t\t,billed_by = '{$_SESSION['username']}'\n\t\t\t\t\t\tWHERE po_reference_no = '{$id}'";
            $rr_mst_upd = "UPDATE tbl_rr_mst \n\t\t\t\t\t\tSET cv_reference_no = '{$newnum}'\n\t\t\t\t\t\t\t,payment_date = '{$today}'\n\t\t\t\t\t\t\t,billed_by = '{$_SESSION['username']}'\n\t\t\t\t\t\t\t,status = '10'\n\t\t\t\t\t\tWHERE po_reference_no = '{$id}' ";
            $update_controlno = "UPDATE tbl_controlno SET lastseqno = (lastseqno + 1) WHERE control_type = 'CV_REFERENCE' ";
            $res = mysql_query($po_mst_upd) or die("UPDATE Billing " . mysql_error());
            mysql_query($rr_mst_upd);
            if (!$res) {
                echo '<script>alert("There has been an error on billing your PO! Please double check all the data and save.");</script>';
            } else {
                mysql_query($update_controlno);
                echo '<script>alert("PO successfully billed.");</script>';
            }
            echo '<script>window.location="po_payment_edit.php?id=' . $id . '";</script>';