<?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
										)
									)
								)
								OR ((? IS NULL) OR u.first_name LIKE ?)
								GROUP BY 1 DESC LIMIT ?, ?");

PD9waHAKCgkJJHN0bXQgPSAkY29uLT5wcmVwYXJlKCJTRUxFQ1QgY2EuaWRfY2FzaGllciwKCQkJCQkJCQkJY3IuY2FzaF9yZWdpc3RlciwKCQkJCQkJCQkJZW50LnRyYWRlbmFtZSwKCQkJCQkJCQkJYm8udHJhZGVuYW1lLAoJCQkJCQkJCQl1LmZpcnN0X25hbWUsCgkJCQkJCQkJCXUubGFzdF9uYW1lLAoJCQkJCQkJCQljYS5vcGVuX2RhdGUsCgkJCQkJCQkJCWNhLm9wZW5fYW1vdW50LAoJCQkJCQkJCQljYS5jbG9zZV9kYXRlLAoJCQkJCQkJCQlTVU0oaS5hbW91bnRfdG90YWwpIEFTIHNhbGVzX2RheSwKCQkJCQkJCQkJY2Eub3Blbl9hbW91bnQgKyBDT0FMRVNDRShTVU0oaS5hbW91bnRfdG90YWwpLCAwKSBBUyB0b3RhbF9hbW91bnQsCgkJCQkJCQkJCWNhLnN0YXR1cwoJCQkJCQkJCUZST00gdGJsX2Nhc2hpZXIgQVMgY2EKCQkJCQkJCQlMRUZUIEpPSU4gdGJsX2ludm9pY2UgQVMgaSBVU0lORyAoaWRfc2VsbGVyKQoJCQkJCQkJCUxFRlQgSk9JTiB0YmxfY2FzaF9yZWdpc3RlciBjciBPTiBjYS5pZF9jYXNoX3JlZ2lzdGVyPWNyLmlkX2Nhc2hfcmVnaXN0ZXIKCQkJCQkJCQlMRUZUIEpPSU4gdGJsX3VzZXJzIHUgT04gY2EuaWRfc2VsbGVyPXUuaWRfdXNlcgoJCQkJCQkJCUxFRlQgSk9JTiB0YmxfZW50ZXJwcmlzZSBlbnQgT04gaS5pZF9lbnRlcnByaXNlPWVudC5pZF9lbnRlcnByaXNlCgkJCQkJCQkJTEVGVCBKT0lOIHRibF9icmFuY2hfb2ZmaWNlIGJvIE9OIGkuaWRfYnJhbmNoX29mZmljZT1iby5pZF9icmFuY2hfb2ZmaWNlCgkJCQkJCQkJV0hFUkUgY2EuaWRfc2VsbGVyID0gPwoJCQkJCQkJCUFORCAoCgkJCQkJCQkJCWkuaWRfaW52b2ljZSBJUyBOVUxMCgkJCQkJCQkJCU9SICgKCQkJCQkJCQkJCWkucGF5ZXJfZGF0ZSA+PSBjYS5vcGVuX2RhdGUKCQkJCQkJCQkJCUFORCAoCgkJCQkJCQkJCQkJY2EuY2xvc2VfZGF0ZSBJUyBOVUxMCgkJCQkJCQkJCQkJT1IgaS5wYXllcl9kYXRlIDw9IGNhLmNsb3NlX2RhdGUKCQkJCQkJCQkJCSkKCQkJCQkJCQkJKQoJCQkJCQkJCSkKCQkJCQkJCQlPUiAoKD8gSVMgTlVMTCkgT1IgdS5maXJzdF9uYW1lIExJS0UgPykKCQkJCQkJCQlHUk9VUCBCWSAxIERFU0MgTElNSVQgPywgPyIpOw==