if( isset($_POST['stock_type']) ){
if( $_POST['stock_type'] == 'stock_general' ){
echo '<h2 class=\'align-center\'>Stock on Hand</h2>';
echo '<p class=\'align-center\'>As of : ' . date('d/m/Y h:i:s') . '<br />';
echo 'Item count : ' . $row_count . '</p>';
$stock_general_fields = array('ItemCode', 'Location', 'AuditDate', 'Product', 'Manufacturer', 'Model', 'Customer', 'Status', 'PCSerialNo',
'DisplayCode', 'BuyPrice', 'AuditCharge', 'FreightCharge', 'MiscCharge');
create_table_rows($stock_general_fields, $all_stock_arr);}
elseif($_POST['stock_type'] == 'stock_condition'){
echo '<h2 class=\'align-center\'>Stock on Hand</h2>';
echo '<p class=\'align-center\'>As of : ' . date('d/m/Y h:i:s') . '</p><br />';
$stock_condition_arr = array();
foreach($all_stock_arr as $stock){
$item_code = $stock['ItemCode'];
$prod_code = $stock['Product'];
$cond_code = $stock['Condition'];
$test_code = $prod_code . $cond_code;
if(! isset($key_code) || $key_code != $test_code ){
$key_code = $test_code; }
$stock_condition_arr[$item_code]['prod_code'] = $prod_code;
$stock_condition_arr[$item_code]['cond_code'] = $cond_code;
$stock_condition_arr[$item_code]['cond_prod'] = $cond_code . '_' . $prod_code;
}
echo '<table><tr><th>Product</th>';
foreach(array_count_values(array_column($stock_condition_arr, 'cond_code')) as $key => $val){
echo '<th>' . $key . '</th>';
}
echo '</tr>';
foreach(array_count_values(array_column($stock_condition_arr, 'prod_code')) as $prod_key => $prod_val){
echo '<tr><td>' . $prod_key . '</td>';
foreach(array_count_values(array_column($stock_condition_arr, 'cond_code')) as $cond_key => $cond_val){
$key_code = $cond_key . '_' . $prod_key;
$new = array_count_values(array_column($stock_condition_arr, 'cond_prod'));
if( isset($new[$key_code]) ){
echo '<td>' . $new[$key_code] . '</td>';
}else{
echo '<td></td>';
}
}
echo '</tr>';
}
echo '</table>';
}
Comments