function generateDesignsId($month)
{
    //    $dateObj = DateTime::createFromFormat('!m', $month);
    //    $month_name = $dateObj->format('F');
    $month_name = date('F', mktime(0, 0, 0, $month, 10));
    echo "<h3>{$month_name}</h3>";
    $query = "SELECT designs_id, status_time FROM designs_status_history";
    $query .= " WHERE status=9 AND YEAR(FROM_UNIXTIME(status_time)) = '2014' AND MONTH(FROM_UNIXTIME(status_time)) = '{$month}'";
    $result = tep_db_query($query);
    $c = array();
    $c['no'] = 'No.';
    $c['id'] = 'Designs ID';
    $c['date'] = 'Finalized Date';
    $table_des[] = $c;
    while ($row = tep_db_fetch_array($result)) {
        $no++;
        $date = date('d-m-Y', $row['status_time']);
        $c = array();
        $c['no'] = $no;
        $c['id'] = $row['designs_id'];
        $c['date'] = $date;
        $table_des[] = $c;
    }
    $table = tep_draw_table('main_center', $table_des, true);
    echo $table;
}

function spNAVdrawTable($jng_sp_id, $type, $navigations, $float)
{
    global $type_allowed_clear;
    $allowed_clear = in_array($jng_sp_id . $type, $type_allowed_clear);
    $content = '<div id="nc-' . $type . '" class="nav-container" style="width:610px;' . ($float ? 'float:left;margin-right:15px;' : '') . '">';
    if (!$float) {
        $title = 'Primary';
    } else {
        if ($jng_sp_id == '1') {
            if ($type == 'jng') {
                $title = 'J&G Brand';
            } elseif ($type == 's') {
                $title = 'Specials';
            }
        }
    }
    if (!isset($title)) {
        $title = 'Secondary';
    }
    $title .= ' Navigations';
    $content .= '<h2 style="float:left;padding-top:7px;">' . $title . '</h2>';
    $content .= spNAVdravAddButton($jng_sp_id, $type, 'margin-bottom:10px');
    $table = array();
    $table[] = spNAVdrawRowHeader($allowed_clear);
    foreach ($navigations as $nav_id => $nav_name) {
        $table[] = spNAVdrawRow($jng_sp_id, $type, $nav_id, $nav_name, $allowed_clear);
    }
    $content .= tep_draw_table('navs', $table);
    $content .= spNAVdravAddButton($jng_sp_id, $type, 'margin-top:10px');
    $content .= '</div>';
    //.nav-container
    return $content;
}

 public function getList($category_id, $languages_id = 2, $render_to_table = false)
 {
     $result = array();
     $q = "SELECT m.*, md.name FROM measurements m" . " INNER JOIN measurements_description md" . " ON md.measurements_id = m.measurements_id AND md.languages_id = {$languages_id}" . " WHERE m.categories_id = {$category_id}";
     $r = tep_db_query($q);
     while ($row = tep_db_fetch_array($r)) {
         $result[$row['measurements_id']] = $row;
     }
     if ($render_to_table) {
         if (is_array($result) && count($result) > 0) {
             $table = array();
             $header['id'] = 'ID';
             $header['name'] = 'Name';
             $table[] = $header;
             foreach ($result as $mid => $mdt) {
                 $row = array();
                 $link_to_edit = "?open=products-measurements&id={$mid}&hidemenu=true";
                 $row['id'] = '<a href="' . $link_to_edit . '" class="view_webpage">' . $mid . '</a>';
                 $row['name'] = '<a href="' . $link_to_edit . '" class="view_webpage">' . $mdt['name'] . '</a>';
                 $table[] = $row;
             }
             return tep_draw_table('measurement', $table);
         } else {
             return 'No data to show';
         }
     } else {
         return $result;
     }
 }

 function manageLogisticList($rowperpage, $page)
 {
     $result = '';
     $result .= '<div>';
     $result .= '<input type="button" id="newlogpack" value="Create New" title="Create New Logistic Package" />';
     $result .= '<a href="?open=packages-logistic-detail&hidemenu=true" class="view_webpage"></a>';
     $result .= '</div>';
     $result .= '<div>&nbsp;</div>';
     $count_logistic_query = tep_db_query("SELECT COUNT(logistic_id) AS total FROM minierp_logistic");
     $count_logistic = tep_db_fetch_array($count_logistic_query);
     $offset = ($page - 1) * $rowperpage;
     $paging_filter = "LIMIT {$rowperpage} OFFSET {$offset}";
     $lq = "SELECT ml.*, SUM(products_total_count) AS total_qty";
     $lq .= " FROM minierp_logistic ml";
     $lq .= " LEFT JOIN minierp_logistic_contents mlc ON mlc.logistic_id=ml.logistic_id";
     $lq .= " GROUP BY logistic_id";
     $lq .= " ORDER BY logistic_date DESC";
     $lq .= " {$paging_filter}";
     $logistic_query = tep_db_query($lq);
     $logistic = array();
     while ($row = tep_db_fetch_array($logistic_query)) {
         $logistic[] = $row;
     }
     if (count($logistic) > 0) {
         $pagelink = tep_paging($count_logistic['total'], $page, '?open=packages-logistic-list&amp;page=');
         $log_table = array();
         $lt = array();
         $lt['pac_code'] = 'Shipper Code';
         $lt['long_id'] = 'Invoice No';
         $lt['date'] = 'Sent Date';
         $lt['qty'] = 'Qty';
         $lt['countpro'] = 'Weight';
         $lt['price'] = 'Price';
         $lt['awb_no'] = 'AWB No';
         $log_table[] = $lt;
         foreach ($logistic as $l) {
             $log_date = strtotime($l['logistic_date']);
             $sent_date = $l['sent_date'] == '' ? '&nbsp;' : date('d-M-Y', strtotime($l['sent_date']));
             $lt = array();
             $lt['pac_code'] = '<a href="?open=packages-logistic-detail&amp;id=' . $l['logistic_id'] . '&hidemenu=true" class="view_webpage" title="View Logistic Detail">' . $l['logistic_code'] . '</a>';
             $lt['long_id'] = $l['ptb_no'] != '' ? date('ym', $log_date) . '-' . $l['ptb_no'] : '&nbsp;';
             $lt['date'] = date('j-M-y', $log_date);
             $lt['qty'] = $l['total_qty'];
             $lt['countpro'] = $l['logistic_weight'] . ' Kg';
             $lt['price'] = displayCurrency($l['currency'], $l['logistic_price']);
             $lt['awb_no'] = $this->awbCodeLink($l['awb_no']);
             $log_table[] = $lt;
         }
         $result .= tep_draw_table('packages', $log_table);
         $result .= $pagelink;
     } else {
         $result .= '<h3 class="red">No Logistic Packages is found in database</h3>';
     }
     return $result;
 }

 function managePackageList($rowperpage, $page)
 {
     $count_packages_query = tep_db_query("SELECT COUNT(packages_id) AS total FROM minierp_packages");
     $count_packages = tep_db_fetch_array($count_packages_query);
     $offset = ($page - 1) * $rowperpage;
     $paging_filter = "LIMIT {$rowperpage} OFFSET {$offset}";
     $packages_query = tep_db_query("SELECT * FROM minierp_packages {$paging_filter}");
     $packages = array();
     while ($row = tep_db_fetch_array($packages_query)) {
         $packages[] = $row;
     }
     $pagelink = tep_paging($count_packages['total'], $page, '?open=sp-packages&page=');
     $package_table = array();
     $pt = array();
     $pt['pac_code'] = 'Package Code';
     $pt['awb_no'] = 'AWB No';
     $pt['sen_date'] = 'Sent Date';
     $pt['rec_date'] = 'Received Date';
     $package_table[] = $pt;
     if (count($packages) > 0) {
         foreach ($packages as $p) {
             $sent_date = $p['sent_date'] == '' ? ' ' : date('d-M-Y', strtotime($p['sent_date']));
             $received_date = $p['received_date'] == '' ? ' ' : date('d-M-Y', strtotime($p['received_date']));
             $pt = array();
             $pt['pac_code'] = '<a href="?open=sp-package&amp;id=' . $p['packages_id'] . '" title="View Package Detail"s>' . $p['packages_code'] . '</a>';
             $pt['awb_no'] = $p['awb_no'];
             $pt['sen_date'] = $sent_date;
             $pt['rec_date'] = $received_date;
             $package_table[] = $pt;
         }
     } else {
         $pt = array();
         $pt['pac_code'] = '&nbsp;';
         $pt['awb_no'] = '&nbsp;';
         $pt['sen_date'] = '&nbsp;';
         $pt['rec_date'] = '&nbsp;';
         $package_table[] = $pt;
     }
     $result = tep_draw_table('packages', $package_table);
     $result .= $pagelink;
     return $result;
 }

$q .= " FROM jng_sp_orders_items_return joir";
$q .= " LEFT JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_items_id=joir.jng_sp_orders_items_id";
$q .= " LEFT JOIN products p ON p.products_id=joi.products_id";
$q .= " WHERE joir.return_comment_customer!='' OR joir.return_comment_jng!=''";
$q .= " ORDER BY p.products_id, joir.return_time";
$r = tep_db_query($q);
while ($row = tep_db_fetch_array($r)) {
    $returns[] = $row;
}
$table = array();
$t = array();
$t[1] = 'No';
$t[2] = 'Image';
$t[3] = 'Return Date';
$t[4] = 'Product Code';
$t[5] = 'Article No';
$t[6] = 'Reason';
$table[] = $t;
foreach ($returns as $counter => $row) {
    $t = array();
    $t[1] = '<div>' . ($counter + 1) . '</div>';
    $t[2] = '<div>' . webImage($row['products_image'], '80', '80') . '</div>';
    $t[3] = '<div>' . date('d-M-y', strtotime($row['return_time'])) . '</div>';
    $t[4] = '<div>' . $row['products_model'] . '</div>';
    $t[5] = '<div>' . $row['article_number'] . '</div>';
    $t[6] = '<div>' . $row['return_reason'] . '</div>';
    $table[] = $t;
}
$content = tep_draw_table('', $table);
echo $content;
tep_db_close();

         $s['id'] = 'ID';
         $s['active'] = 'Active';
         $s['name'] = 'Name';
         $s['desc'] = 'Description';
         $stab[] = $s;
         foreach ($pi as $row) {
             $s = array();
             $s['qty'] = '<input type="checkbox" name="piids[]" value="' . $row['production_instruction_id'] . '" />';
             $s['id'] = $row['production_instruction_id'];
             $s['active'] = $row['active_status'] ? '<span class="green">A</span>' : '<span class="green">-</span>';
             $s['name'] = '<a href="?open=production-instruction-manual&amp;id=' . $row['production_instruction_id'] . '&amp;hidemenu=true" class="view_webpage">' . $row['name'] . '</a>';
             $s['desc'] = nl2br($row['description']);
             //production_instruction_manual::parsingDescription($row['description'], 'ul');
             $stab[] = $s;
         }
         $pi_table = tep_draw_table('pi_manual', $stab);
         $action_buttons = ' <input id="delete-submit" type="submit" name="submit" value="Remove" style="display:none;" />';
         $action_buttons .= ' <input id="delete-button" type="button" class="button red" value="Delete" />';
     }
     echo utf8_encode($pi_table . '<span id="pibuttons">' . $action_buttons . '</span>');
     exit;
 } else {
     if ($_POST['me_action'] == 'CREATEPI') {
         $pi_cat = tep_db_prepare_input($_POST['pi_cat']);
         $pi_name = tep_db_prepare_input($_POST['pi_name']);
         $pi_desc = tep_db_prepare_input($_POST['pi_desc']);
         $pi_active = tep_db_prepare_input($_POST['pi_active']);
         $class_pim = new production_instruction_manual();
         $class_pim->create($pi_cat, $pi_name, $pi_desc, $pi_active);
         $messagebox->add('Manual Production Instruction created', 'green');
         $reloadlist = true;

        $r[] = $x;
    }
    $x = array();
    $x['id'] = ' ';
    $x['name'] = '<strong>Total: ' . $total . ' Customer(s)<strong>';
    $x['email'] = '&nbsp;';
    $x['date'] = '&nbsp;';
    $r[] = $x;
}
if (isset($_GET['format']) && $_GET['format'] == 'csv') {
    $file_name = 'jng-not-active-reports-' . date('Ymd-Hi') . '.csv';
    header("Content-type: application/octet-stream");
    header("Content-Disposition: attachment; filename=\"{$file_name}\"");
    header("Cache-Control: cache, must-revalidate");
    header("Pragma: public");
    echo tep_create_csv($r);
    exit;
}
$dl = '?report=customers-not-active&format=csv';
$content = '<a class="dl-icon" href="' . $dl . '" target="_blank"></a>';
$content .= ' <a class="dl-text" href="' . $dl . '" target="_blank">Download CSV</a>';
$xlimit = ceil($total / $each);
$content .= '<h2>CSV per ' . $each . ' customers</h2>';
for ($x = 1; $x <= $xlimit; $x++) {
    $dl = '?report=customers-not-active&format=csv&list=' . $x;
    $content .= '<div><a href="' . $dl . '">Download List Cust #' . $x . ' </a></div>';
}
$content .= '<div>&nbsp;</div>';
$content .= '<div class="total">Total: ' . $total . ' Customer(s)</div>';
$content .= tep_draw_table('reports', $r);
$title = 'Incomplete Registration';

$content .= '</select></td></tr>';
$content .= '</table>';
$content .= '<table border="0" cellpadding="0" cellspacing="0" style="background:#eee;">';
$content .= '<tr><td rowspan="2"><input type="button" id="print-stock" value="Print Stock List" /></td>';
$content .= '<td><h3>Average DIOH</h3></td><td><h3>: <span id="avg-dioh">' . $dioh_average . '</span></h3></td></tr>';
$content .= '<tr><td><h3>Total Stock Value</h3></td><td><h3>: <span id="total-price">' . displayCurrency('EUR', $total_total) . '</span></h3></td></tr>';
$content .= '</table></div>';
$content .= '<strong>Sort by </strong><select id="sort_option" name="sort_option" onchange="frm_sort.submit();">';
foreach ($sort_options as $value => $option) {
    $sel = $sort_option == $value ? 'selected="selected"' : '';
    $content .= '<option value="' . $value . '" ' . $sel . '>' . $option . '</option>';
}
$content .= '</select>';
$content .= '</form></div>';
$content .= '<div style="clear:both;">&nbsp;</div>';
$content .= tep_draw_table('proman sticky-tablehead', $table);
$content .= '<div id="showopt" class="bold">';
$content .= '<div id="showmore">&raquo; Show <span class="show">' . $show_amount . '</span> more out of <span class="more"></span></div>';
$content .= '<div id="showall">&raquo; Show ALL (<span class="more"></span>)</div>';
$content .= '</div>';
// #showopt
$content .= '<div style="display:none;">';
$content .= '<div id="printstocklist" style="width:500px;height:400px;padding:10px;">';
$content .= '<div id="errornotype" class="ui-corner-all" style="position:absolute;top:35px;left:200px;border:2px solid #f00;padding:10px 20px;color:#f00;display:none;">&laquo; Please Select a Type</div>';
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td colspan="2"><h3>Stock List Type:</h3></td></tr>';
$content .= '<tr><td><input id="rad-slt-1" type="radio" name="type" value="FULL" /></td><td><label for="rad-slt-1">Full Stock Info</label></td></tr>';
$content .= '<tr><td><input id="rad-slt-2" type="radio" name="type" value="BLANK" /></td><td><label for="rad-slt-2">Blank / No Stock Info</label></td></tr>';
$content .= '<tr><td colspan="2">&nbsp;</td></tr>';
$content .= '<tr><td colspan="2"><h3>Filter by Category:</h3></td></tr>';
$content .= '<tr><td><input id="rad-cat-0" type="radio" name="catid" value="0" /></td><td><label for="rad-cat-0">Show All Elements</label></td></tr>';

        //PRICE GROUP TABLE
        $price_category = array();
        $price_category[] = formatTableRow(REPORT_TABLE_TYPE_PRICEGROUP);
        $data_price_categories = queryData(REPORT_TABLE_TYPE_PRICEGROUP, $id_source_order, $start_date, $end_date);
        foreach ($data_price_categories as $dpc) {
            $price_category[] = formatTableRow($dpc['row_id'], $dpc['sold_pieces'], $dpc['total_sales'], $dpc['total_sales_ratio'], $dpc['avg_price'], $dpc['avg_margin'], $dpc['total_profit'], $dpc['total_profit_ratio'], $dpc['return_rate'], false);
        }
        $table_price_group = tep_draw_table('', $price_category, false, true);
        //PRODUCT BRAND TABLE
        $brand_category = array();
        $brand_category[] = formatTableRow(REPORT_TABLE_TYPE_BRAND);
        $data_brand_categories = queryData(REPORT_TABLE_TYPE_BRAND, $id_source_order, $start_date, $end_date);
        foreach ($data_brand_categories as $dbc) {
            $brand_category[] = formatTableRow($dbc['row_id'], $dbc['sold_pieces'], $dbc['total_sales'], $dbc['total_sales_ratio'], $dbc['avg_price'], $dbc['avg_margin'], $dbc['total_profit'], $dbc['total_profit_ratio'], $dbc['return_rate'], false);
        }
        $table_brand = tep_draw_table('', $brand_category, false, true);
        //Merge all tables as 1 html
        $result = '<h3 style="margin-top:20px;">' . REPORT_TABLE_TYPE_CATEGORY . '</h3>' . '<div>' . $table_product_category . '</div>' . '<h3 style="margin-top:20px;margin-bottom:0px;">' . REPORT_TABLE_TYPE_PRICEGROUP . '</h3>' . '<span class="notice">Average price before return is used for seperating data into each Price Group</span>' . '<div style="margin-top:5px;">' . $table_price_group . '</div>' . '<h3 style="margin-top:20px;">' . REPORT_TABLE_TYPE_BRAND . '</h3>' . '<div>' . $table_brand . '</div>';
        echo utf8_encode($result);
        exit;
    }
}
//Set Available Tables
$arr_data_table = array();
$arr_data_table[] = 'Product Category';
$arr_data_table[] = 'Price Group';
$arr_data_table[] = 'Brand';
$select_sp = '<select id="source_order" title="Select Main Filter">';
if (!SERVER_IS_LOCAL) {
    $select_sp .= '<option value="0">Julie & Grace</option>' . '<option value="allsp">All SP and J&G</option>';
} else {

            $bus_partner['to'] = number_format($to_value, 2) . ' EUR';
            $bp[] = $bus_partner;
        }
    } else {
        $bp[1]['sel'] = ' ';
        $bp[1]['company'] = ' ';
        $bp[1]['name'] = ' ';
        $bp[1]['email'] = ' ';
        $bp[1]['date'] = ' ';
        $bp[1]['lo'] = ' ';
        $bp[1]['to'] = ' ';
    }
    //EXPORT TO CSV DOWNLOAD LINK
    $export = '';
    if ($page == 1) {
        $dl = '?open=business-partner&format=csv';
        $export .= '<a class="dl-icon" href="' . $dl . '" target="_blank"></a>';
        $export .= '<a class="dl-text" href="' . $dl . '" target="_blank">Download Complete CSV</a>';
    }
    //START CONTENT
    $content = '';
    $content .= $export;
    //$content .= '<div style="margin:0px 0px 5px 0px;"><a href="?open=business-p-fixed-disc">Manage Fixed Discount Status</a></div>';
    $content .= '<form name="ambassador-status-remove" action="?open=business-partner" method="post">';
    $content .= '<input type="hidden" name="me_action" value="BUSINESSPARTNERSTATUSREM" />';
    $content .= tep_draw_table('bp', $bp) . $pagelink;
    $content .= '<div>&nbsp;</div>';
    $content .= '<input type="submit" class="red button" name="submit" value="Remove Selected" />';
    $content .= '<div>&nbsp;</div>';
    $title = 'List of Business Partners';
}

             }
             if ($total_ordered_after_void > 0) {
                 if ($o['payment_status'] == '1') {
                     $button_closed_dis_en = '';
                 } else {
                     $button_closed_dis_en = ' disabled="disabled"';
                 }
             } else {
                 $button_closed_dis_en = '';
             }
             //                $button_closed_dis_en = ($o['payment_status']!='1') ? 'disabled="disabled" ' : '';
             $ot['d2'] = '<input type="text" id="paydat-' . $oid . '" name="paydat" value="' . $payment_date . '" class="date_picker"' . $payment_dis . ' />';
             $ot['act'] = '<input type="button" id="close-' . $oid . '" name="close" value="Close"' . $button_closed_dis_en . ' />';
             $otable[] = $ot;
         }
         $tabcontent .= tep_draw_table('spo sticky-tablehead', $otable);
     }
 } elseif ($status == 'F') {
     $filter_month = array();
     $filter_year = array();
     for ($d = 1; $d <= 12; $d++) {
         $filter_month[$d] = date("F", mktime(0, 0, 0, $d));
     }
     $current_year = date('Y');
     $fsy = $current_year - 2;
     //Filter Start Year
     for ($y = $fsy; $y <= $current_year; $y++) {
         $filter_year[$y] = $y;
     }
     $tabcontent .= '<div style="margin-bottom:10px;">';
     $tabcontent .= '<select id="months" name="months">' . loadComboListFromArray($filter_month, null, date('n'), false) . '</select>';

$filter_query = '';
$el_query = tep_db_query("SELECT e.elements_id, e.elements_code, etes.item_number, e.elements_image AS image FROM element e\n  INNER JOIN elements_to_elements_suppliers etes ON etes.elements_id=e.elements_id AND etes.is_default='1' AND etes.price_quantity_type='set'\n  LEFT JOIN elements_images ei ON ei.elements_id=e.elements_id AND ei.elements_sample_name='EC1'\n  LEFT JOIN elements_description ed ON ed.elements_id=e.elements_id AND ed.languages_id=2\n  {$filter_query}\n  GROUP BY e.elements_id ORDER BY e.elements_id");
$elements = array();
$e = array();
$e['i'] = '<div>Image</div>';
$e['j'] = '<div>J&G ID</div>';
$e['k'] = '<div>J&G Code</div>';
$e['l'] = '<div>J&G Name</div>';
$e['m'] = '<div>Supplier Code</div>';
$elements[] = $e;
$grouper = array('+', '&', ',');
while ($row = tep_db_fetch_array($el_query)) {
    $grabbed = false;
    foreach ($grouper as $g) {
        if (strpos($row['item_number'], $g) !== false) {
            $grabbed = true;
            break;
        }
    }
    if ($grabbed) {
        $e = array();
        $e['i'] = '<div>' . webImage($row['image'], '130', '130') . '</div>';
        $e['j'] = '<div>' . $row['elements_id'] . '</div>';
        $e['k'] = '<div>' . $row['elements_code'] . '</div>';
        $e['l'] = '<div>' . $row['name'] . '</div>';
        $e['m'] = '<div>' . $row['item_number'] . '</div>';
        $elements[] = $e;
    }
}
echo tep_draw_table('', $elements);
tep_db_close();

                $keywords_array = explode(' ', $keywords);
                foreach ($customers as $c) {
                    $cname = strtolower($c['customers_name']);
                    foreach ($keywords_array as $key) {
                        $cname = str_replace($key, "<strong>{$key}</strong>", $cname);
                    }
                    $t = array();
                    $t['r'] = $c['partner'];
                    $t['d'] = $c['jng_sp_customers_id'];
                    $t['c'] = $cname;
                    $action = '<input type="button" name="cadd2list" value="Add" />';
                    $action .= '<input type="hidden" id="cid-' . $c['jng_sp_customers_id'] . '" name="jng_sp_customers_id" value="' . $c['jng_sp_customers_id'] . '" />';
                    $t['a'] = $action;
                    $table[] = $t;
                }
                $result .= tep_draw_table('spo', $table);
            }
        }
        echo utf8_encode($result);
    } elseif ($_POST['me_action'] == 'ADDCUSTOMER') {
        $jng_sp_customers_id = tep_db_prepare_input($_POST['jng_sp_customers_id']);
        $added = $class_jcs->addCustomer($type, $jng_sp_customers_id);
        $result = $added ? $jng_sp_customers_id : 'fail';
        echo utf8_encode($result);
    }
    exit;
}
//START TEMPLATE
$content = '<div>Search Customer Name</div>';
$content .= '<div style="margin-bottom:20px;">';
$content .= '<input type="text" id="search_keywords" value="" class="iwbutton" />';

        $p_sel['dur'] = '<label for="cb_el' . $row['elements_id'] . '">' . $e_duration . '</label>';
        $p_sel['name'] = '<label for="cb_el' . $row['elements_id'] . '">' . $e_name . '</label>';
        $new_elements[] = $p_sel;
    }
} else {
    $new_elements[1]['sel'] = '&nbsp;';
    $new_elements[1]['id'] = '&nbsp;';
    $new_elements[1]['model'] = '&nbsp;';
    $new_elements[1]['since'] = '&nbsp;';
    $new_elements[1]['dur'] = '&nbsp;';
    $new_elements[1]['name'] = '&nbsp;';
}
$ne_form = '<div>';
$ne_form .= '<form name="element-new-add" action="?open=elements-new" method="post">';
$ne_form .= '<input type="hidden" name="me_action" value="ELEMENTNEWADD" />';
$ne_form .= 'Element Code: <input type="text" class="iwbutton" name="elements_code" value="" style="width:200px" />';
$ne_form .= '<input type="submit" class="blue button" name="submit" value="Add" />';
$ne_form .= '</form>';
$ne_form .= '</div>';
$ne_form .= '<div>&nbsp;</div>';
$content = $ne_form;
$content .= '<form name="element-new-remove" action="?open=elements-new" method="post">';
$content .= '<input type="hidden" name="me_action" value="ELEMENTNEWREM" />';
$content .= tep_draw_table('products-selected', $new_elements);
$content .= '<div>&nbsp;</div>';
$content .= '<div><strong>There are ' . $total_ne . ' New Element(s)</strong></div>';
$content .= '<div>&nbsp;</div>';
$content .= '<input type="submit" class="red button" name="submit" value="Remove Selected" />';
$uppernotes = '<div style="color:#f00;">New Elements will be marked in Configurator</div>';
$uppernotes .= '<div><em>You can add multiple Code seperated by comma</em></div>';
$title = 'List of New Elements';

$invoice_date_end = date('Y-m-d 23:59:59', strtotime(tep_db_prepare_input($_GET['ide'])));
$filter = "invoice_date >= '{$invoice_date_start}' AND invoice_date <= '{$invoice_date_end}'";
$payment_summary_data = payone::getPaymentSummaryData('A', $filter);
$content = 'Invoice Date from ' . date('d-m-Y', strtotime($invoice_date_start));
$content .= '&nbsp;&nbsp;to ' . date('d-m-Y', strtotime($invoice_date_end));
if (count($payment_summary_data) > 0) {
    $table = array();
    $th = array();
    $th['d'] = 'Invoice<br/>Date';
    $th['d2'] = 'Invoice<br/>Due Date';
    $th['c'] = 'Customer Name';
    $th['o'] = 'Payment<br/>Method';
    $th['id2'] = 'Order No';
    $th['id3'] = 'Payone<br/>txid';
    $th['p'] = 'Saldo<br/>(EUR)';
    $table[] = $th;
    foreach ($payment_summary_data as $dt) {
        $tr = array();
        $tr['d'] = date('d-m-Y', strtotime($dt['invoice_date']));
        $tr['d2'] = date('d-m-Y', strtotime($dt['invoice_due_date']));
        $tr['c'] = $dt['customers_name'];
        $tr['o'] = $dt['payment_method'];
        $order_link = '?open=customer-care-order-detail&amp;source=' . ($dt['invoice_order_type'] == 'S' ? 'SP' : 'JG') . '&amp;id=' . $dt['invoice_order_id'] . '&amp;hidemenu=true';
        $tr['id2'] = '<a title="click to view order detail" class="view_webpage" href="' . $order_link . '">' . $dt['order_no'] . '</a>';
        $tr['id3'] = $dt['payone_txid'];
        $tr['p'] = displayCurrency('EUR', $dt['amount_saldo'], false);
        $table[] = $tr;
    }
    $content .= tep_draw_table('spo', $table);
}
$title = 'Payment Overview Orders List';

                $result .= '</h3>';
                //echo '<pre>';var_dump($tc_value); echo '</pre><br /><br />';
                //Prepare the total values
                foreach ($table_total[$table_key][$tc_key] as $tt_temp_key => $tt_temp_val) {
                    //Label column need no values
                    if ($tt_temp_key != $classname_label) {
                        if (is_array($tt_temp_val)) {
                            $total = array_sum($tt_temp_val) / count($tt_temp_val);
                        } else {
                            $total = $tt_temp_val;
                        }
                        $table_total[$table_key][$tc_key][$tt_temp_key] = scorecard::finalDisplayFormat($tc_key, $total);
                    }
                }
                $tc_value[$total_key] = $table_total[$table_key][$tc_key];
                $result .= tep_draw_table('scorecard', $tc_value, false, true);
            }
        }
        //That's it, now give back the table
        echo utf8_encode($result);
        exit;
    }
}
$period_options = array();
$period_options['all'] = 'Show All Months';
$period_options['actual'] = 'Show Actual Months';
$view_option = array();
$view_option['overview'] = 'Show Overview';
$view_option['details'] = 'Show Details';
$content .= '<div>' . '<select id="cmb_based" class="input">' . loadComboListFromArray($based_options, null, 'sp') . '</select>' . '<select id="cmb_period" class="input">' . loadComboListFromArray($period_options, null, 'actual') . '</select>' . '<select id="cmb_view" class="input">' . loadComboListFromArray($view_option, null, 'details') . '</select>' . '</div>' . '<div id="div_period_actual" class="w150 tac" style="margin:5px 0 5px 215px;">' . '<span class="ui-state-default ui-corner-all" style="float:left;">' . '<span id="icn-period-prev" class="ui-icon ui-icon-triangle-1-w pointer">' . '</span></span>' . 'Change Period' . '<span class="ui-state-default ui-corner-all" style="float:right;">' . '<span id="icn-period-next" class="ui-icon ui-icon-triangle-1-e pointer">' . '</span></span>' . '</div>' . '<div style="width:100%;padding-bottom:40px;overflow:auto;">' . '<div id="scorecard_container" style="width:2000px;">' . '</div></div>';
$javascript .= '

                }
                $elements_used .= '<div style="float:left;text-align:center;margin:5px 8px;">' . webImage($re['elements_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Element ' . $re['elements_id'], 'img-border') . '<br /><span class="' . $class . '">(' . implode(',', $finishing) . ')</span></div>';
            }
            $t['i'] = $elements_used;
            $button_el = '<span>';
            $button_el .= '<a href="?open=designs-products-elements-used&amp;products_id=' . $products_id . '&amp;act=LOAD&amp;hidemenu=true" class="view_webpage"></a>';
            $button_el .= '<input type="button" name="upd-elements" value="&raquo; Update Elements Used" class="input tal" />';
            $button_el .= '</span>';
            $button_pd = '<span>';
            $button_pd .= '<a href="?open=product-detail&amp;products_id=' . $products_id . '&amp;hidemenu=true#prodet-tab1d" class="view_webpage"></a>';
            $button_pd .= '<input type="button" name="upd-prodescs" value="&raquo; Update Product Description" class="input tal" />';
            $button_pd .= '</span>';
            $t['a'] = $button_el . $button_pd;
            $table[] = $t;
        }
        $tab_content .= tep_draw_table("spo designs-list", $table);
        if ($total_rows == 200) {
            $tab_content .= '<h3 class="red">Manobo only show 200 Most Recent Products</h3>';
        }
    } else {
        $tab_content .= '<h3 class="red">No Products found</h3>';
    }
    $tab_content .= '<div style="margin-top:20px;"><input type="button" name="reloadlist" class="button" value="Reload List" style="font-size:20px;" /></div>';
    echo utf8_encode($tab_content);
    exit;
}
$main_link = '?open=products-gold-non-finishing&amp;status=';
$content .= '<div id="tabs-products-lists">';
$content .= '<ul>';
$content .= '<li><a href="' . $main_link . '0">Goldplated Products with No Golplated Elements (<span id="tc-0"></span>)</a></li>';
$content .= '<li><a href="' . $main_link . '1">Silver Products with Goldplated Elements (<span id="tc-1"></span>)</a></li>';

 function analysis_overview($period, $price_type)
 {
     use_class('jng_warehouses');
     $class_jw = new jng_warehouses();
     $q = "SELECT jw.name, jw.warehouse_code, jw.warehouse_type";
     $q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_open), SUM(msp.stock_open)) AS stock_open";
     $q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_close), SUM(msp.stock_close)) AS stock_close";
     /*
     if($price_type=='mat_exp') {
     	$q .= ", IF(jw.warehouse_type='E', SUM(mse.mat_exp_open), SUM(msp.mat_exp_open)) AS stock_value_open";
     	$q .= ", IF(jw.warehouse_type='E', SUM(mse.mat_exp_close), SUM(msp.mat_exp_close)) AS stock_value_close";
     } else {
     	$q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.purchase_price_open)) AS stock_value_open";
     	$q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.purchase_price_close)) AS stock_value_close";
     }
     */
     if ($price_type == 'mat_exp') {
         $q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_open*mse.mat_exp_open), SUM(msp.stock_open*msp.mat_exp_open)) AS stock_value_open";
         $q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_close*mse.mat_exp_close), SUM(msp.stock_close*msp.mat_exp_close)) AS stock_value_close";
     } else {
         $q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.stock_open*msp.purchase_price_open)) AS stock_value_open";
         $q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.stock_close*msp.purchase_price_close)) AS stock_value_close";
     }
     $q .= " FROM jng_warehouses jw";
     $q .= " LEFT JOIN minierp_stock_elements mse ON mse.jng_warehouses_id=jw.jng_warehouses_id AND mse.stock_period='{$period}'";
     $q .= " LEFT JOIN minierp_stock_products msp ON msp.jng_warehouses_id=jw.jng_warehouses_id AND msp.stock_period='{$period}'";
     $q .= " GROUP BY jw.jng_warehouses_id";
     $q .= " ORDER BY jw.jng_warehouses_id";
     $r = tep_db_query($q);
     $stocks = array();
     $s = array();
     $s['name'] = 'Warehouse Name';
     $s['long_id'] = 'Code';
     $s['status'] = 'Type';
     $s['price'] = 'Inventory<br />BoP Value';
     $s['price2'] = 'Inventory<br />EoP Value';
     $s['price3'] = 'Inventory<br />Ave.Value';
     $stocks[] = $s;
     while ($row = tep_db_fetch_array($r)) {
         $bop = $row['stock_value_open'];
         $eop = $row['stock_value_close'];
         $avg = ($bop + $eop) / 2;
         $s['name'] = $row['name'];
         $s['long_id'] = $row['warehouse_code'];
         $s['status'] = $class_jw->typeName($row['warehouse_type']);
         if ($row['warehouse_type'] == 'E' && $price_type != 'mat_exp') {
             $s['price']