Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>';
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement