tep_db_connect();
define('FPDF_IMGPATH', DIR_WS_IMAGES . 'pdf/');
define('FPDF_FONTPATH', FPDF_IMGPATH . 'fonts/');
require_once DIR_WS_CLASSES . 'fpdf.php';
if (isset($_GET['id']) && $_GET['id'] != '') {
$type = 'sp';
//SP PACKAGES
use_class("jng_sp");
$class_sp = new jng_sp();
$splist = $class_sp->retrieveList();
$sp_prefix = array();
foreach ($splist as $sp) {
$sp_prefix[$sp['jng_sp_id']] = $sp['package_prefix'];
}
use_class("jng_sp_packages");
$class_jp = new jng_sp_packages();
use_class("jng_sp_orders");
$class_jo = new jng_sp_orders();
$package_id = tep_db_prepare_input($_GET['id']);
$orders_array = $class_jp->getOrders($package_id);
$items_array = $class_jp->getItems($package_id);
} elseif (isset($_GET['pid']) && $_GET['pid'] != '') {
$type = 'jng';
//JNG PACKAGES
use_class("minierp_packages");
$class_mp = new minierp_packages();
use_class("orders");
$class_o = new orders();
$package_id = tep_db_prepare_input($_GET['pid']);
$orders_array = $class_mp->getOrders($package_id);
$items_array = $class_mp->getProducts($package_id);
$result['msg_errors'] = '';
} else {
$result = array();
$result['oi_id'] = $items_id;
$result['old_status'] = $old_status;
$result['new_status'] = $item['status'];
$result['msg_success'] = '';
$result['msg_errors'] = oiErrorStatus($items_id, $item['status'], $class_do->statusName());
}
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'PACKAGEUPDATEAWB') {
$package_id = tep_db_prepare_input($_POST['package_id']);
$package_awb = tep_db_prepare_input($_POST['package_awb']);
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
$class_jp->updateAWBno($package_id, $package_awb);
$result = array();
$result['package_id'] = $package_id;
$result['package_awb'] = $package_awb;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'REFRESHCOUNTER') {
$status_counter = $class_do->statusCounter($statusNameShow, $dpo_option, $dpo_group, $ean_list, $date_range_start, $date_range_end, $brand_id, $cat_id);
$result = array();
foreach ($status_counter as $status => $counter) {
$result[] = "{$status},{$counter}";
}
ajaxReturn($result);
exit;
// } elseif($_POST['me_action']=='LOADINGTHUMBTOOLTIP') {
// $result .= '<div> </div>';
// $result .= $win_pack->ui_print();
// }
$log_total_ged = $class_ml->retrieveContentsTotal($logistic_id, 'GED');
$log_total_dhl = $class_ml->retrieveContentsTotal($logistic_id, 'DHL', $use_cogs);
}
$result .= '<input type="hidden" id="log_value_ged_hidden" value="' . displayCurrency('EUR', $log_total_ged) . '" />';
$result .= '<input type="hidden" id="log_value_dhl_hidden" value="' . displayCurrency('EUR', $log_total_dhl) . '" />';
echo utf8_encode($result);
} elseif ($_POST['me_action'] == 'SETSENT') {
$logistic_id = tep_db_prepare_input($_POST['logistic_id']);
$packages = $class_ml->retrievePackages($logistic_id, true);
foreach ($packages as $type => $pack) {
if ($type == 'P') {
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
foreach ($pack as $p) {
$items = $class_jp->sendPackage($p['packages_id']);
foreach ($items as $items_id) {
$class_jo->updateItemStatus($items_id, '7', $session_userinfo['username']);
}
}
} elseif ($type == 'J') {
use_class('minierp_packages');
$class_mp = new minierp_packages();
use_class('orders');
$class_o = new orders();
foreach ($pack as $p) {
$items = $class_mp->sendPackage($p['packages_id']);
<?php
//AJAX ACTION
use_class('orders');
use_class('depot_orders');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('jng_sp_packages');
use_class('minierp_packages');
use_class('products_ean');
use_class('bins');
$class_o = new orders();
$class_do = new depot_orders();
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_jp = new jng_sp_packages();
$class_mp = new minierp_packages();
$class_ean = new products_ean();
$class_bins = new bins();
$item_status = statusName();
define('EAN_MISMATCH_ERROR', 'EANMISMATCH');
$waiting_box_name = 'Waiting Box';
$packing_box_name = 'Packing Box';
$finish_box_name = 'Finish Box';
$order_show_sp_info = array('9');
//am.fr
function printPackageTip($type, $no, $info = '', $spname = '', $spclass = '')
{
global $waiting_box_name, $packing_box_name;
if ($type == EAN_MISMATCH_ERROR) {
$result = '<div class="package-tip red-bright">';
<?php
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$content = $class_jp->managePackageList(ROWPERPAGE, $page);
$content .= '<div style="margin-top:20px;"><input type="button" value="View J&G Packages" onclick="location.href=\'?open=packages\';" /></div>';
$title = "List of SP Packages";
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once '../functions-xml.php';
tep_db_connect();
define('FPDF_IMGPATH', DIR_WS_IMAGES . 'pdf/');
define('FPDF_FONTPATH', FPDF_IMGPATH . 'fonts/');
use_class('fpdf', DIR_WS_CLASSES);
use_class("jng_sp_packages");
$class_jp = new jng_sp_packages();
use_class("jng_sp_orders");
$class_jo = new jng_sp_orders();
use_class("products_minierp");
$class_pm = new products_minierp();
$package_id = tep_db_prepare_input($_GET['id']);
$package = $class_jp->retrieveDetail($package_id);
//$orders_array = $class_jp->getOrders($package_id);
$items_array = $class_jp->getItems($package_id);
class PDF extends FPDF
{
var $left_margin;
var $page_width;
var $page_height;
var $font_size;
//Page header
function Header()
{
}
* 9) payone_invoice_status_history ? not sure, must discuss first
* 10) payone_orders_return_histor ? not sure, must discuss first
* 11) production_status_history ? not sure, must discuss first
* 12) elements_sourcing_history
* 13) orders_product_semail_history
* 14) orders_products_problem_history
*
*/
$logger->write("Task 1 (CHECK PACKAGE SENT RECEIVE DATE) - Start");
/////////////////////////////////////
// CHECK PACKAGE SENT RECEIVE DATE //
/////////////////////////////////////
//SP PACKAGES
$counter = 0;
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
$packages = $class_jp->retrieveUnreceivedPackages();
foreach ($packages as $pid => $p) {
$status_check = $p['package_type'] == 'R' ? array('18', '19', '20', '21') : array('8', '9');
$items = $class_jp->getItems($pid);
foreach ($items as $item_id) {
$ih = $class_jo->retrieveItemHistory($item_id);
foreach ($ih as $h) {
if (in_array($h['status'], $status_check)) {
$counter++;
$class_jp->setReceiveDate($pid, $h['status_date']);
break 2;
}
}
<?php
//EXPORT ORDERS FOR JNG-EasyLog
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
use_class('payone_invoice');
$export = 'NONE';
$packages = $class_jp->getReceivedPackages();
$lines = array();
if (count($packages) > 0) {
foreach ($packages as $package) {
$id = $package['jng_sp_packages_id'];
//EXCLUDE NM.AT from EC process
if ($package['jng_sp_id'] != '3') {
$orders_array = $class_jp->getOrders($id);
$items_array = $class_jp->getItems($id);
$order_counter = 0;
foreach ($orders_array as $order_id) {
$order_counter++;
$items = $class_jo->retrieveItems($order_id);
foreach ($items as $key => $item) {
if ($class_jo->statusIsCancelled($item['status']) || !in_array($item['jng_sp_orders_items_id'], $items_array)) {
unset($items[$key]);
}
<?php
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
$content = '';
if (!isset($_GET['id']) || $_GET['id'] == '') {
$content .= '';
$content .= '<div></div>';
} else {
$package_id = tep_db_prepare_input($_GET['id']);
$package = $class_jp->retrieveDetail($package_id);
$package_id = $package['jng_sp_packages_id'];
$sent_date = $package['sent_date'] == '' ? ' ' : date('d F Y', strtotime($package['sent_date']));
$received_date = $package['received_date'] == '' ? ' ' : date('d F Y', strtotime($package['received_date']));
$content .= '<div id="sp-package">';
$content .= '<ul>';
$content .= '<li><a href="#pack-tab1"><span>Package Data</span></a></li>';
$content .= '<li><a href="#pack-tab2"><span>Package Contents</span></a></li>';
$content .= '</ul>';
$content .= '<div id="pack-tab1">';
$content .= '<div>';
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td width="150">Package ID</td><td>' . $package_id . '</td></tr>';
$content .= '<tr><td>Package Code</td><td><strong>' . $package['package_code'] . '</strong></td></tr>';
$awb_code = $class_jp->awbCodeLink($package['awb_no']);
$content .= '<tr><td>AWB No</td><td>' . $awb_code . '</td></tr>';
$content .= '<tr><td>Sent Date</td><td>' . $sent_date . '</td></tr>';
$content .= '<tr><td>Received Date</td><td>' . $received_date . '</td></tr>';
$content .= '</table>';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'daily-statistic');
set_time_limit(0);
$tax = VAT;
$package_rate = 0;
$freight_rate = 2.7;
//SALES PARTNER DAILY STATISTIC
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('jng_sp_packages');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_jp = new jng_sp_packages();
$jng_sps = $class_sp->retrieveList();
$getdays = '';
if (isset($_GET['getdays'])) {
$getdays = tep_db_prepare_input($_GET['getdays']);
}
if ($getdays == '') {
$getdays = 1;
}
$dates = array();
for ($d = $getdays; $d > 0; $d--) {
$dates[] = date('Y-m-d', strtotime("-{$d} day"));
}
if (isset($_GET['period'])) {
//FORMAT = YYYY-MM
$dates = array();
function updatePackagesAWBno($logistic_id, $awb_no)
{
$packages = $this->retrievePackages($logistic_id, true);
foreach ($packages as $type => $packs) {
switch ($type) {
case 'J':
use_class('minierp_packages');
$class_mp = new minierp_packages();
foreach ($packs as $p) {
//if($p['awb_no']=='') {
$class_mp->updateAWBno($p['packages_id'], $awb_no);
//}
}
break;
case 'P':
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
foreach ($packs as $p) {
//if($p['awb_no']=='') {
$class_jp->updateAWBno($p['packages_id'], $awb_no);
//}
}
break;
case 'D':
use_class('depot_orders');
$class_do = new depot_orders();
foreach ($packs as $p) {
$class_do->packageUpdateAWB($p['packages_id'], $awb_no);
}
}
}
}
/**
* Retrieve order items data on Package
* @global array $SP_DOESNT_NEED_EASYLOG
* @param int $jng_sp_id
* @param int $status
* @param string $ean_list
* @param string $date_start
* @param string $date_end
* @param int $brand_id
* @param int $cat_id
* @param string $orders_no
* @return array of order items
*/
function manageOrderPackageList($jng_sp_id, $status, $ean_list = null, $date_start = null, $date_end = null, $brand_id = null, $cat_id = null, $orders_no = '')
{
use_class('jng_sp');
$class_sp = new jng_sp();
$SP_DOESNT_NEED_EASYLOG = array_keys($class_sp->retrieveList('use_easylog=0'));
$query = "SELECT CONCAT(jo.customer_billing_firstname,' ',jo.customer_billing_lastname) AS customer_name";
$query .= ", jo.order_id, jo.order_date, jo.customers_order_count, joi.*, p.products_image, p.products_brand_id, joih.status_date";
$query .= ", jp.jng_sp_id, jp.jng_sp_packages_id, jp.package_code, jp.awb_no, jcust.jng_sp_customers_id, jscs.list_type";
$query .= ", IFNULL(joi.leadtime_start_date, jo.order_date) AS date_for_sorting";
$query .= " FROM jng_sp_orders jo";
$query .= " LEFT JOIN jng_sp_customers jcust ON jcust.jng_sp_id=jo.jng_sp_id AND jcust.customer_id=jo.customer_billing_id";
$query .= " LEFT JOIN jng_sp_customers_special jscs ON jscs.jng_sp_customers_id=jcust.jng_sp_customers_id";
$query .= " LEFT JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_id=jo.jng_sp_orders_id";
$query .= " LEFT JOIN jng_sp_orders_items_status_history joih ON joih.jng_sp_orders_items_id=joi.jng_sp_orders_items_id AND joih.status=joi.status";
$query .= " INNER JOIN jng_sp_packages_items jpi ON jpi.jng_sp_orders_items_id=joi.jng_sp_orders_items_id";
$query .= " LEFT JOIN products p ON p.products_id=joi.products_id";
$query .= " LEFT JOIN jng_sp_packages jp ON jp.jng_sp_packages_id=jpi.jng_sp_packages_id";
$query .= " LEFT JOIN products_to_categories ptc ON ptc.categories_id=joi.products_id";
$query .= " WHERE joi.status='{$status}'";
if ($jng_sp_id != '0') {
$query .= " AND jo.jng_sp_id={$jng_sp_id}";
}
$query .= $this->eanListFilterQuery($ean_list, 'AND', '');
$query .= $this->leadtimeFilterQuery($status, $date_start, $date_end, 'AND', '');
if ($brand_id > 0) {
$query .= " AND p.products_brand_id='{$brand_id}' ";
}
if ($cat_id > 0) {
$query .= " AND ptc.categories_id='{$cat_id}' ";
}
if ($orders_no != '') {
$query .= " AND jo.order_id IN ('" . (is_array($orders_no) ? implode("','", $orders_no) : $orders_no) . "') ";
}
$query .= " ORDER BY IFNULL(jp.sent_date, NOW()) ";
$query .= $status < 14 ? 'ASC' : 'DESC';
$query .= ", date_for_sorting ASC, jo.jng_sp_orders_id ASC, joi.order_item_count ASC";
$result = tep_db_query($query);
$orders = array();
$package_code = array();
$package_awb = array();
$package_sp_id = array();
$all_package_receivable = true;
$filters = $this->manageOrderList_drawFilter($jng_sp_id, $ean_list, $date_start, $date_end, $brand_id, $cat_id, $orders_no);
if (tep_db_num_rows($result) > 0) {
$header = array();
$header['d'] = ($status < 6 or $status > 7) ? 'Date' : 'Lead Time';
//$header['d2'] = '<abbr title="Reported Shipping Date">RSD</abbr>';
if (!($status < 6 || $status > 7)) {
$header['d3'] = 'Cycle Time';
$header['d2'] = 'Started Date';
}
$header['c'] = 'Customer / Order No';
$header['o'] = 'Order ID';
$header['a'] = 'Article No';
$header['p'] = 'Price';
$header['q'] = 'Qty';
$header['t'] = 'Action';
$orders_items = array();
$items_listed = array();
while ($row = tep_db_fetch_array($result)) {
if (!in_array($row['jng_sp_orders_items_id'], $items_listed)) {
$obj_product = new Product($row['products_id']);
$orders_items[$row['jng_sp_orders_items_id']] = $row;
$items_listed[] = $row['jng_sp_orders_items_id'];
$package_id = $row['jng_sp_packages_id'];
if (!isset($orders[$package_id])) {
$orders[$package_id] = array();
$package_code[$package_id] = $row['package_code'];
$package_awb[$package_id] = $row['awb_no'];
if ($row['awb_no'] == '') {
$all_package_receivable = false;
}
}
$order_date = strtotime($row['order_date']);
$o = array();
/*
$date_used = strtotime($row['prod_target_in']);
if (($status < 6) OR ($status > 7)) {
$value_date = date('d-M-y', $order_date);
} else {
$value_date = displayLeadTime($row['prod_target_in'], $date_used);
}
$o['d'] = $value_date;
*/
$o['d'] = displayLeadTime($row['leadtime_start_date'], strtotime($row['leadtime_start_date']));
//$o['d'] = '<div title="'.date('H:i:s', $order_date).'">'.date('d-M-y', $order_date).'</div>';
//$o['d2'] = $this->reportedShippingDate($order_date, $status, $row['delivery_time'], $row['delivery_replacement_time']);
if (!($status < 6 or $status > 7)) {
$o['d3'] = displayCycleTime($row['status_date']);
//$o['d2'] = date('d-M-y', $date_used);
$o['d2'] = date('d-M-y', strtotime($row['leadtime_start_date']));
}
$cust = '<a href="?open=sp-customer&id=' . $row['jng_sp_customers_id'] . '&hidemenu=true" class="view_webpage" >' . $row['customer_name'] . '</a>';
if ($row['list_type'] != '') {
$crown_img_col = array('V' => 'vip', 'B' => 'black');
$crown_img_title = array('V' => 'VIP Customer', 'B' => 'Blacklist Customer');
$crown_img = '<a href="?open=sp-customers-special-detail&id=' . $row['jng_sp_customers_id'] . '&hidemenu=true" class="view_webpage">';
$crown_img .= '<img src="images/list-' . $crown_img_col[$row['list_type']] . '.gif" title="' . $crown_img_title[$row['list_type']] . '" />';
$crown_img .= '</a> ';
$cust = $crown_img . $cust;
}
$cust .= ' <sup>' . $row['customers_order_count'] . '</sup>';
$link_item = '<a href="?open=sp-order-history&oi_id=' . $row['jng_sp_orders_items_id'] . '&hidemenu=true" class="view_webpage">SP-' . $row['jng_sp_orders_items_id'] . '</a>';
$order_id_info = $link_item;
$order_no = $row['order_id'];
if ($order_no == '') {
$order_no = 'J&G ID: ' . $row['jng_sp_orders_id'];
}
$order_no = '<a href="?open=customer-care-order-detail&source=SP&id=' . $row['jng_sp_orders_id'] . '&hidemenu=true" class="view_webpage">' . $order_no . '</a>';
if ($row['order_item_total'] > 1) {
$order_id_info .= ' <sup>' . $row['order_item_count'] . '/' . $row['order_item_total'] . '</sup>';
}
$o['c'] = $cust . '<br /><small>order no:</small> ' . $order_no;
$o['o'] = $order_id_info;
$article = $row['article_number'];
$pimg = webImageSource($row['products_image'], '500');
$article = '<div><a href="?open=product-detail&products_id=' . $row['products_id'] . '" target="_blank" title="View Product Detail">' . $article . '</a></div>';
if ($pimg != '') {
$thumb = '<div class="thumb"><a href="' . $pimg . '" class="view_image" title="Click to view larger image">' . webImage($row['products_image'], '80', '80', '', 'img-border img-padding') . '</a></div>';
$article = $thumb . $article;
}
//$diamond_icon = ($obj_product->brand_id == 14) ? drawDiamondIcon('Diamond Product', ' ') : '';
$diamond_icon = $obj_product->isUsingDiamond() ? drawDiamondIcon('Diamond Product', ' ') : '';
$gold_icon = drawGoldIcon($obj_product->metal_stamp_code, $obj_product->metal_stamp_info, '', ' ');
$icons = $gold_icon . $diamond_icon;
$o['a'] = drawTableArticleInfoWithIcons($article, $icons);
$o['p'] = $row['price'];
$o['q'] = intval($row['order_quantity']);
$action = '';
if ($row['status'] == '6') {
$action .= '<input type="button" class="actbtn" name="5" value="Remove" title="Remove from package" />';
}
if ($row['status'] == '7' || $row['status'] == '8') {
$action .= '<input type="button" class="actbtn" name="10" value="DOA" title="Received DOA, cancel this product" />';
}
if ($row['status'] == '16') {
$action .= '<input type="button" class="actbtn" name="15" value="Keep" title="Remove from package and Set to Keep" />';
}
if ($row['status'] == '18') {
$action .= '<input type="button" class="actbtn" name="20" value="Stock" title="Add product to Stock" />';
$action .= '<input type="button" class="actbtn" name="21" value="Disass" title="Disassemble and add elements to Stock" />';
}
if ($row['status'] == '17' || $row['status'] == '18') {
$action .= '<input type="button" class="actbtn" name="19" value="Lost" title="Product is lost" />';
}
//Default Row Action Value (id, status, stock status)
$action .= '<input type="hidden" id="oiid-' . $row['jng_sp_orders_items_id'] . '" name="oi_id" value="' . $row['jng_sp_orders_items_id'] . '" >';
$action .= '<input type="hidden" name="oi_status" value="' . $row['status'] . '" >';
$o['t'] = $action;
$orders[$package_id][$row['jng_sp_orders_items_id']] = $o;
if (!isset($package_sp_id[$package_id])) {
$package_sp_id[$package_id] = $row['jng_sp_id'];
}
}
}
$result = '<div id="packages">';
/*
if($status=='7' && count($orders)>1 && $all_package_receivable) $result .= '<div style="margin-bottom:20px;"><input type="button" class="pkgbtn button" name="receiveallpackage" value="Receive All Packages" title="Receive all packages listed in HH" /></div>';
if($status=='8') {
//$result .= ;
if($this->easylogImportDataExist()) {
$import_stats = '';
$import_class = ' red ';
$import_value = 'Import file found. Click here to set status to Sent.';
$import_title = 'Import shipping data exported from EASYLOG';
} else {
$import_class = ' ';
$import_stats = 'disabled="disabled"';
$import_value = 'There is no import file to proccess';
$import_title = $import_value;
}
$result .= '<div style="margin-bottom:20px;">';
$result .= '<input type="button" class="pkgbtn'.$import_class.'button" name="importeasylog" value="'.$import_value.'" title="'.$import_title.'" '.$import_stats.' />';
$result .= '</div>';
}
*/
foreach ($orders as $pid => $package) {
$result .= '<div id="package-' . $pid . '" style="margin-bottom:20px;">';
$button = '';
if ($status == '6') {
//$button .= ' <input type="button" class="pkgbtn" name="printpackagelabel" value="Print Labels" title="Print Labels for products in this package" />';
$button .= ' <input type="button" class="pkgbtn" name="printpackagechecklist" value="Print Checklist" title="Print Package Checklist" />';
$button .= ' <input type="button" class="pkgbtn" name="sendpackage" value="Send" title="Send this Package to HH" />';
}
if ($status == '7' || $status == '8' || $status == '17' || $status == '18') {
use_class('jng_sp_packages');
if ($status < 14) {
$class_jp = new jng_sp_packages();
$awb_code = $class_jp->awbCodeLink($package_awb[$pid]);
} else {
$awb_code = $package_awb[$pid];
}
if ($awb_code == '') {
$awb = $awb_code;
$awb_button_tips = 'Add AWB no to this Package';
} else {
$awb = '(AWB: ' . $awb_code . ')';
$awb_button_tips = 'Change AWB';
}
$button .= ' <span id="awb-' . $pid . '" style="font-weight:normal;">' . $awb . '</span>';
$button .= ' <input type="button" class="pkgbtn" name="updateawb" value="AWB" title="' . $awb_button_tips . '" />';
//$button .= ' <input type="button" class="pkgbtn" name="printpackagepicklist" value="Print Picklist" title="Print Package Picklist" />';
}
//if($status=='7') $button .= ' <input type="button" class="pkgbtn" name="receivepackage" value="Receive" title="Receive this Package in HH" />';
if ($status == '7') {
//if($status=='8') {
if (in_array($package_sp_id[$pid], $SP_DOESNT_NEED_EASYLOG)) {
//for SP that use manual button instead of Easylog
$button .= ' <input type="button" class="pkgbtn" name="printdeliverydocsingle" value="Invoice / Delivery Document" title="Print Invoice / Delivery Documents of this package" />';
$button .= ' <input type="button" class="pkgbtn" name="setsent2cust" value="Set as Sent to Customer" title="Set all orders in this package as Sent to Customer" disabled="disabled" />';
}
}
if ($status == '16') {
$button .= ' <input type="button" class="pkgbtn" name="printpackagechecklist" value="Print Checklist" title="Print Package Checklist" />';
$button .= ' <input type="button" class="pkgbtn" name="printpackagefakeinvoice" value="Print Invoice" title="Print Fake Invoice for Bali Customs" />';
$button .= ' <input type="button" class="pkgbtn" name="sendpackage" value="Send" title="Send this Package to Bali" />';
}
if ($status == '17') {
$button .= ' <input type="button" class="pkgbtn" name="receivepackage" value="Receive" title="Receive this Package in Bali" />';
}
$result .= '<h3>Package ' . $package_code[$pid] . ' ' . $button . ' <input type="hidden" name="package_id" value="' . $pid . '" /></h3>';
//$result .= tep_draw_table('spo', $package);
//DRAW MANUALLY
$result .= '<div class="draw-table"><table class="spo" border="0" cellpadding="0" cellspacing="0">';
$result .= '<tr>';
foreach ($header as $c => $h) {
$result .= '<th class="' . $c . '">' . $h . '</th>';
}
$result .= '</tr>';
$prev_oid = null;
$order_counter = 0;
$rowclass = 'e';
foreach ($package as $oiid => $order) {
$order_counter++;
$oi = $orders_items[$oiid];
$oid = $oi['jng_sp_orders_id'];
if ($oid != $prev_oid) {
$item_counter = 0;
}
$item_counter++;
if ($item_counter == 1) {
$rowclass = $rowclass == 'e' ? 'o' : 'e';
}
$result .= '<tr class="' . $rowclass . '">';
$hidecol = 5;
$use_hide = $item_counter > 1;
//$use_hide = ($status=='3' && $item_counter>1);
// Logic for lead time
/*
$date_used = strtotime($oi['prod_target_in']);
if (($oi['status'] < 2) OR ($oi['status'] > 7)) {
$value_date = "";
} else {
$value_date = displayLeadTime($oi['prod_target_in'], $date_used);
}
if (!(($oi['status'] < 2) OR ($oi['status'] > 7))) {
$started_date = date('d-M-y', $date_used);
}
*/
$started_date = date('d-M-y', strtotime($oi['leadtime_start_date']));
$value_date = displayLeadTime($oi['leadtime_start_date'], strtotime($oi['leadtime_start_date']));
if ($use_hide) {
$result .= '<td class="d">' . $value_date . '</td>';
if (!($status < 6 || $status > 7)) {
$result .= '<td class="d3">' . displayCycleTime($oi['status_date']) . '</td>';
$result .= '<td class="d2">' . $started_date . '</td>';
}
$result .= '<td> </td>';
}
$col_counter = 0;
foreach ($order as $c => $o) {
$col_counter++;
if ($use_hide) {
/*
if($col_counter==$hidecol) {
$o_pos = strpos($o, '<sup');
$o = ($o_pos===false) ? '' : substr($o, $o_pos);
}
*/
if ($col_counter >= $hidecol) {
$result .= '<td class="' . $c . '">' . $o . '</td>';
}
} else {
$result .= '<td class="' . $c . '">' . $o . '</td>';
}
}
$result .= '</tr>';
$prev_oid = $oid;
}
$result .= '</table></div>';
$result .= '</div>';
//close package-pid
}
$result .= '</div>';
//close packages
} else {
$result = '<h3>No Orders in this status </h3>';
}
$result = $filters . $result;
return $result;
}
