$q .= " LEFT JOIN products_use_elements pue ON pue.products_id = do.products_id";
$q .= " LEFT JOIN products_articles_use_elements paue ON paue.products_use_elements_id = pue.products_use_elements_id";
$q .= " INNER JOIN element e ON e.elements_id = IF(IFNULL(paue.elements_id,0)=0, pue.elements_id, paue.elements_id) AND e.attribute_material_id=1";
$q .= " WHERE dp.depot_packages_id";
$q .= " IN ( " . implode(',', $packages_dp) . " )";
$r = tep_db_query($q);
$row = tep_db_fetch_array($r);
$total_silver_price += $row['total_weight'];
}
echo number_format($total_silver_price, 2);
} elseif ($_POST['me_action'] == 'EXCLUDEFROMPACKAGE') {
$logistic_id = tep_db_prepare_input($_POST['logistic_id']);
$log_partner = tep_db_prepare_input($_POST['log_partner']);
$bcid = tep_db_prepare_input($_POST['bcid']);
$new_status = '11';
$exclude_status = $class_ml->removeFromPackage($logistic_id, $log_partner, $bcid, $new_status);
echo $exclude_status;
}
exit;
}
//START TEMPLATE
$logistic_id = isset($_GET['id']) ? tep_db_prepare_input($_GET['id']) : '';
$log_data = $class_ml->retrieveDetail($logistic_id);
$title = 'Package Info';
$logparts = array();
$logparts['ged'] = 'GED';
$logparts['dhl'] = 'DHL';
$logpart = substr($log_data['logistic_code'], 0, 3) == 'DHL' ? 'DHL' : 'GED';
$logpart_options = '<select id="cmb_logpart" style="width:142px;">' . loadComboListFromArray($logparts, $logpart) . '</selct>';
$date_time = $log_data['logistic_date'] == '' || $log_data['logistic_date'] == '0000-00-00' ? time() : strtotime($log_data['logistic_date']);
$date_value = date('d.m.Y', $date_time);
<?php
set_time_limit(0);
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
$bcids = explode(',', tep_db_prepare_input($_GET['bcid']));
$logistic_id = tep_db_prepare_input($_GET['logid']);
$log_partner = tep_db_prepare_input($_GET['logp']);
$new_status = tep_db_prepare_input($_GET['newstatus']);
if (count($bcids) > 0 && $logistic_id > 0 && $log_partner != '' && $new_status > 0) {
use_class('minierp_logistic');
$class_ml = new minierp_logistic();
foreach ($bcids as $bcid) {
$class_ml->removeFromPackage($logistic_id, $log_partner, $bcid, $new_status, 'manual');
echo "Order {$bcid} removed from package \n";
}
} else {
echo "Input data not complete!";
}
tep_db_close();
