bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
require_once("includes/application_includes.php");
$currentdate = date('Y-m-d');

$expirecredits = $db->getRows("SELECT `id`, `exhibitor_id`, `name`, `email`, `companyname`, `credit_balance`, `expiry_dttm`, `insert_dttm` FROM `bmse_exhibitor_credits_master` WHERE date(`expiry_dttm`) < '".$currentdate."'   and `status`=1 and `remove`=1  and `credit_balance`!=0 ORDER BY `bmse_exhibitor_credits_master`.`insert_dttm` DESC");

if(count($expirecredits) > 0) {
	$insvalues = array(
		'staff_name' => 'system',
		'insert_dttm' => $current_date
	);
	$insertedbid = $db->insert('bmse_credits_expiry_batch', $insvalues);	
}

$num=0;

if (!empty($expirecredits)) {
    $ideas = array();
    foreach ($expirecredits as $val) {
      $ideas[] = $val['id'];
	  $num++;
    }
}
$ids = implode(',', $ideas);

$db->query('update `bmse_exhibitor_credits_master` SET `status`=0, `update_dttm`="' . $current_date . '", `expiry_batch_id`='.$insertedbid.' WHERE `id` in (' . $ids . ')');
echo $num. ' Records are Expired';