xah icon

general

xah | PRO | 09/30/20 10:16:06 PM UTC (Edited) | 0 ⭐ | 422 👁️ | Never ⏰ | []
PHP |

2.24 KB

|

None

|

0 👍

/

0 👎

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