if( isset($_POST['stock_type']) ){ if( $_POST['stock_type'] == 'stock_general' ){ echo '

Stock on Hand

'; echo '

As of : ' . date('d/m/Y h:i:s') . '
'; echo 'Item count : ' . $row_count . '

'; $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 '

Stock on Hand

'; echo '

As of : ' . date('d/m/Y h:i:s') . '


'; $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 ''; foreach(array_count_values(array_column($stock_condition_arr, 'cond_code')) as $key => $val){ echo ''; } echo ''; foreach(array_count_values(array_column($stock_condition_arr, 'prod_code')) as $prod_key => $prod_val){ echo ''; 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 ''; }else{ echo ''; } } echo ''; } echo '
Product' . $key . '
' . $prod_key . '' . $new[$key_code] . '
'; }