Advertisement
xah

general

xah
Sep 28th, 2020 (edited)
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.24 KB | None | 0 0
  1. if( isset($_POST['stock_type']) ){
  2.     if( $_POST['stock_type'] == 'stock_general' ){
  3.       echo '<h2 class=\'align-center\'>Stock on Hand</h2>';
  4.       echo '<p class=\'align-center\'>As of : ' . date('d/m/Y h:i:s') . '<br />';
  5.       echo 'Item count : ' . $row_count . '</p>';
  6.  
  7.       $stock_general_fields = array('ItemCode', 'Location', 'AuditDate', 'Product', 'Manufacturer', 'Model', 'Customer', 'Status', 'PCSerialNo',
  8.                               'DisplayCode', 'BuyPrice', 'AuditCharge', 'FreightCharge', 'MiscCharge');
  9.  
  10.       create_table_rows($stock_general_fields, $all_stock_arr);}
  11.     elseif($_POST['stock_type'] == 'stock_condition'){
  12.       echo '<h2 class=\'align-center\'>Stock on Hand</h2>';
  13.       echo '<p class=\'align-center\'>As of : ' . date('d/m/Y h:i:s') . '</p><br />';
  14.  
  15.       $stock_condition_arr = array();
  16.  
  17.       foreach($all_stock_arr as $stock){
  18.         $item_code = $stock['ItemCode'];
  19.         $prod_code = $stock['Product'];
  20.         $cond_code = $stock['Condition'];
  21.         $test_code = $prod_code . $cond_code;
  22.  
  23.         if(! isset($key_code) || $key_code != $test_code ){
  24.           $key_code = $test_code; }
  25.  
  26.         $stock_condition_arr[$item_code]['prod_code'] = $prod_code;
  27.         $stock_condition_arr[$item_code]['cond_code'] = $cond_code;
  28.         $stock_condition_arr[$item_code]['cond_prod'] = $cond_code . '_' . $prod_code;
  29.  
  30.       }
  31.  
  32.       echo '<table><tr><th>Product</th>';
  33.  
  34.        foreach(array_count_values(array_column($stock_condition_arr, 'cond_code')) as $key => $val){
  35.          echo '<th>' . $key . '</th>';
  36.        }
  37.  
  38.        echo '</tr>';
  39.  
  40.        foreach(array_count_values(array_column($stock_condition_arr, 'prod_code')) as $prod_key => $prod_val){
  41.          echo '<tr><td>' . $prod_key . '</td>';
  42.  
  43.          foreach(array_count_values(array_column($stock_condition_arr, 'cond_code')) as $cond_key => $cond_val){
  44.  
  45.            $key_code = $cond_key . '_' . $prod_key;
  46.  
  47.            $new = array_count_values(array_column($stock_condition_arr, 'cond_prod'));
  48.  
  49.            if( isset($new[$key_code]) ){
  50.              echo '<td>' . $new[$key_code] . '</td>';
  51.            }else{
  52.              echo '<td></td>';
  53.            }
  54.          }
  55.          echo '</tr>';
  56.        }
  57.        echo '</table>';
  58.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement