<?php
		$stmt = $con->prepare("SELECT ca.id_cashier,
									cr.cash_register,
									ent.tradename,
									bo.tradename,
									u.first_name,
									u.last_name,
									ca.open_date,
									ca.open_amount,
									ca.close_date,
									SUM(i.amount_total) AS sales_day,
									ca.open_amount + COALESCE(SUM(i.amount_total), 0) AS total_amount,
									ca.status
								FROM tbl_cashier AS ca
								LEFT JOIN tbl_invoice AS i USING (id_seller)
								LEFT JOIN tbl_cash_register cr ON ca.id_cash_register=cr.id_cash_register
								LEFT JOIN tbl_users u ON ca.id_seller=u.id_user
								LEFT JOIN tbl_enterprise ent ON i.id_enterprise=ent.id_enterprise
								LEFT JOIN tbl_branch_office bo ON i.id_branch_office=bo.id_branch_office
								WHERE ca.id_seller = ?
								AND (
									i.id_invoice IS NULL
									OR (
										i.payer_date >= ca.open_date
										AND (
											ca.close_date IS NULL
											OR i.payer_date <= ca.close_date
										)
									)
								)
								GROUP BY 1 DESC LIMIT ?, ?");

PD9waHAKCQkkc3RtdCA9ICRjb24tPnByZXBhcmUoIlNFTEVDVCBjYS5pZF9jYXNoaWVyLAoJCQkJCQkJCQljci5jYXNoX3JlZ2lzdGVyLAoJCQkJCQkJCQllbnQudHJhZGVuYW1lLAoJCQkJCQkJCQliby50cmFkZW5hbWUsCgkJCQkJCQkJCXUuZmlyc3RfbmFtZSwKCQkJCQkJCQkJdS5sYXN0X25hbWUsCgkJCQkJCQkJCWNhLm9wZW5fZGF0ZSwKCQkJCQkJCQkJY2Eub3Blbl9hbW91bnQsCgkJCQkJCQkJCWNhLmNsb3NlX2RhdGUsCgkJCQkJCQkJCVNVTShpLmFtb3VudF90b3RhbCkgQVMgc2FsZXNfZGF5LAoJCQkJCQkJCQljYS5vcGVuX2Ftb3VudCArIENPQUxFU0NFKFNVTShpLmFtb3VudF90b3RhbCksIDApIEFTIHRvdGFsX2Ftb3VudCwKCQkJCQkJCQkJY2Euc3RhdHVzCgkJCQkJCQkJRlJPTSB0YmxfY2FzaGllciBBUyBjYQoJCQkJCQkJCUxFRlQgSk9JTiB0YmxfaW52b2ljZSBBUyBpIFVTSU5HIChpZF9zZWxsZXIpCgkJCQkJCQkJTEVGVCBKT0lOIHRibF9jYXNoX3JlZ2lzdGVyIGNyIE9OIGNhLmlkX2Nhc2hfcmVnaXN0ZXI9Y3IuaWRfY2FzaF9yZWdpc3RlcgoJCQkJCQkJCUxFRlQgSk9JTiB0YmxfdXNlcnMgdSBPTiBjYS5pZF9zZWxsZXI9dS5pZF91c2VyCgkJCQkJCQkJTEVGVCBKT0lOIHRibF9lbnRlcnByaXNlIGVudCBPTiBpLmlkX2VudGVycHJpc2U9ZW50LmlkX2VudGVycHJpc2UKCQkJCQkJCQlMRUZUIEpPSU4gdGJsX2JyYW5jaF9vZmZpY2UgYm8gT04gaS5pZF9icmFuY2hfb2ZmaWNlPWJvLmlkX2JyYW5jaF9vZmZpY2UKCQkJCQkJCQlXSEVSRSBjYS5pZF9zZWxsZXIgPSA/CgkJCQkJCQkJQU5EICgKCQkJCQkJCQkJaS5pZF9pbnZvaWNlIElTIE5VTEwKCQkJCQkJCQkJT1IgKAoJCQkJCQkJCQkJaS5wYXllcl9kYXRlID49IGNhLm9wZW5fZGF0ZQoJCQkJCQkJCQkJQU5EICgKCQkJCQkJCQkJCQljYS5jbG9zZV9kYXRlIElTIE5VTEwKCQkJCQkJCQkJCQlPUiBpLnBheWVyX2RhdGUgPD0gY2EuY2xvc2VfZGF0ZQoJCQkJCQkJCQkJKQoJCQkJCQkJCQkpCgkJCQkJCQkJKQoJCQkJCQkJCUdST1VQIEJZIDEgREVTQyBMSU1JVCA/LCA/Iik7