/* Decoded by unphp.net */ include("./includes/header.php"); include("./includes/connection.php"); include("./functions/items.php"); include("./get_item_balance_for_particular_subdepartment.php"); if (isset($_SESSION['userinfo']['Employee_Name'])) { $Employee_Name = $_SESSION['userinfo']['Employee_Name']; }else { $Employee_Name = 'Unknown Officer'; } if (isset($_GET['jobcard_ID'])) { $jobcard_ID = $_GET['jobcard_ID']; } if (isset($_SESSION['userinfo']['Employee_ID'])) { $Employee_ID = $_SESSION['userinfo']['Employee_ID']; }else { $Employee_ID = 0; } if (isset($_SESSION['userinfo']['Branch_ID'])) { $Branch_ID = $_SESSION['userinfo']['Branch_ID']; }else { $Branch_ID = 0; } ;echo '

Engineering Store Order JobCard No: ';echo $jobcard_ID;echo '
Order Number Order Date '; if (isset($_SESSION['General_Order_ID'])) { $Jobcard_Order_ID = $_SESSION['General_Order_ID']; $get_details = mysqli_query($conn,"select Created_Date_Time from tbl_jobcard_orders where Jobcard_Order_ID = '$Jobcard_Order_ID'") or die(mysqli_error($conn)); $num = mysqli_num_rows($get_details); if ($num >0) { while ($row = mysqli_fetch_array($get_details)) { $Created_Date_Time = $row['Created_Date_Time']; } }else { $Created_Date_Time = ''; } ;echo ' ';}else {;echo ' ';};echo ' Prepared By
Store Ordering Order Description '; if (isset($_SESSION['General_Order_ID'])) { $Jobcard_Order_ID = $_SESSION['General_Order_ID']; $get_details = mysqli_query($conn,"select Order_Description from tbl_jobcard_orders where Jobcard_Order_ID = '$Jobcard_Order_ID'") or die(mysqli_error($conn)); $num = mysqli_num_rows($get_details); if ($num >0) { while ($row = mysqli_fetch_array($get_details)) { $Order_Description = $row['Order_Description']; } }else { $Order_Description = ''; } ;echo ' ';}else {;echo ' ';};echo '
'; if (isset($_SESSION['General_Order_ID'])) { $Jobcard_Order_ID = $_SESSION['General_Order_ID']; }else { $Jobcard_Order_ID = 0; } ;echo ' ';if (isset($_SESSION['systeminfo']['Store_Order_Add_Items_By_Pop_Up']) &&$_SESSION['systeminfo']['Store_Order_Add_Items_By_Pop_Up'] == 'yes') {;echo '
Classification
'; $result = mysqli_query($conn,"SELECT DISTINCT Product_Name, t.Item_ID, t.Unit_Of_Measure FROM tbl_items t ORDER BY Product_Name LIMIT 50") or die(mysqli_error($conn)); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while ($row = mysqli_fetch_array($result)) { $last_buying_prices = Get_Item_Last_Buying_Price_With_Supplier($row['Item_ID']); if (count($last_buying_prices) >0) { $last_buying_price = $last_buying_prices["Buying_Price"]; }else { $last_buying_price = 0; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ;echo '
ItemsOUM nondoBalancelast buying price
"; ;echo ' '; echo ""; echo ""; echo "
';};echo '
';if (isset($_SESSION['systeminfo']['Store_Order_Add_Items_By_Pop_Up']) &&$_SESSION['systeminfo']['Store_Order_Add_Items_By_Pop_Up'] == 'no') {;echo ' ';};echo '
classfication
'; $result = mysqli_query($conn,"SELECT Product_Name, t.Item_ID, t.Unit_Of_Measure FROM tbl_items t WHERE Classification in ('Pharmaceuticals', 'Dental Materials', 'Disposables', 'Laboratory Materials', 'Radiology Materials', 'Stationaries') ORDER BY Product_Name LIMIT 400 ") or die(mysqli_error($conn)); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while ($row = mysqli_fetch_array($result)) { $last_buying_prices = Get_Item_Last_Buying_Price_With_Supplier($row['Item_ID']); if (count($last_buying_prices) >0) { @$last_buying_price = $last_buying_prices["Buying_Price"]; }else { $last_buying_price = 0; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ;echo '
ItemsOUMBalancelast buying price
"; ;echo ' '; echo ""; echo ""; echo "
';if (isset($_SESSION['systeminfo']['Store_Order_Add_Items_By_Pop_Up']) &&$_SESSION['systeminfo']['Store_Order_Add_Items_By_Pop_Up'] == 'yes') {;echo ' ';};echo '
'; echo '
'; echo ''; $select_Transaction_Items = mysqli_query($conn,"SELECT soi.Order_Item_ID, soi.Last_Buying_Price,soi.Jobcard_Order_ID, itm.Product_Name,itm.Item_ID, soi.Quantity_Required, soi.Item_Remark, soi.Jobcard_Order_ID, soi.Container_Qty, soi.Items_Qty, ib.Item_Balance FROM tbl_jobcard_order_items soi, tbl_items itm, tbl_items_balance ib WHERE itm.Item_ID = soi.Item_ID AND itm.Item_ID = ib.Item_ID AND ib.Sub_Department_ID = '$Sub_Department_ID' AND soi.Jobcard_Order_ID ='$Jobcard_Order_ID'") or die(mysqli_error($conn)); $Temp = 1; while ($row = mysqli_fetch_array($select_Transaction_Items)) { $last_buying_prices = Get_Item_Last_Buying_Price_With_Supplier($row['Item_ID']); if (count($last_buying_prices) >0) { @$last_buying_price = $last_buying_prices["Buying_Price"]; }else { $last_buying_price = 0; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ;echo ' '; echo ""; $Temp++; } echo '
Sn Item Name for Units Items Quantity Store Balance Last Buying Price Remark Remove
'; ;echo '
'; if (isset($_SESSION['General_Order_ID'])) { ;echo ' '; } ;echo '
'; include("./includes/footer.php"); ;