<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

ERROR - 2024-07-02 16:17:59 --> Severity: Warning --> trim() expects parameter 1 to be string, array given /home/shagoon/public_html/application/helpers/common_function_helper.php 2418
ERROR - 2024-07-02 16:17:59 --> Query error: Unknown column 'Array' in 'field list' - Invalid query: INSERT INTO `refill_sales_transaction` (`dispenser_sales_id`, `tracking_numbers`, `product_id`, `duration_days`, `quantity`, `unit_of_measurment`, `refill_date`, `next_refill_date`, `refill_location`, `comments`, `modified_by`, `is_active`, `modified_on`) VALUES ('34', '71', '8', '7', '100', Array, '2024-07-02', '2024-07-09', 'W', 'aasd', '1', '1', '2024-07-02 16:17:59')
ERROR - 2024-07-02 16:17:59 --> Severity: Warning --> Cannot modify header information - headers already sent by (output started at /home/shagoon/public_html/system/core/Exceptions.php:271) /home/shagoon/public_html/system/core/Common.php 564
ERROR - 2024-07-02 16:18:44 --> Query error: Unknown column 'Array' in 'field list' - Invalid query: INSERT INTO `refill_sales_transaction` (`dispenser_sales_id`, `tracking_numbers`, `product_id`, `duration_days`, `quantity`, `unit_of_measurment`, `refill_date`, `next_refill_date`, `refill_location`, `comments`, `modified_by`, `is_active`, `modified_on`) VALUES ('34', '71', '8', '7', '100', Array, '2024-07-02', '2024-07-09', 'W', 'aasd', '1', '1', '2024-07-02 16:18:44')
ERROR - 2024-07-02 16:28:21 --> Query error: Unknown column 'r' in 'field list' - Invalid query: SELECT `d`.`dispenser_sales_id`, `c`.`customer_name`, `c`.`customer_id`, `u`.`first_name`, `u`.`last_name`, `b`.`company_branch_name`, `p`.`product_name`, `p`.`product_type`, `d`.`sales_type`, `d`.`dispenser_quantity` as `stock_quantity`, `d`.`comments`, `r`.`refill_location`, `d`.`price` AS `total`, `d`.`dispenser_sales_id`, `d`.`installation_date`, `r`.`dispenser_refill_details_id`, `p`.`product_id`, `r`.`quantity` as `refil_qty`, `pa`.`product_name` as `refill_name`, `r`.`tracking_numbers`, `r`, `unit_of_measurment`
FROM `dispenser_sales_transaction` as `d`
INNER JOIN `customer` as `c` ON `c`.`customer_id` = `d`.`customer_id`
LEFT JOIN `company_branch` as `b` ON `b`.`company_branch_id` = `c`.`company_branch_id`
LEFT JOIN `product` as `p` ON `p`.`product_id` = `d`.`product_id`
LEFT JOIN `users` as `u` ON `u`.`user_id` = `d`.`sales_person_id`
INNER JOIN `refill_sales_transaction` as `r` ON `r`.`dispenser_sales_id` = `d`.`dispenser_sales_id`
LEFT JOIN `product` as `pa` ON `pa`.`product_id` = `r`.`product_id`
WHERE `d`.`company_branch_id` = '1'
AND `d`.`customer_id` = '4'
AND `r`.`next_has_been_refilled` = 'no'
AND `r`.`stop_refill` = 'no'
AND `d`.`dispenser_quantity` > '0'
ORDER BY `customer_name` ASC
 LIMIT 30
