bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ini_set('display_errors',1);
include('includes/application_includes.php');
exit;
$creditsinfo = $db->getRows('select `exhibitor_id`,`credit_notes`, `credit_by`, `name`, `email`, `companyname`, `purchase_through`, DATE(`insert_dttm`) as insdate, `update_dttm`,   `credit_value` as "crval" from bmse_exhibitor_credits where `creditsone`="assigned"  order by id ASC');

//ArrayDisplay($creditsinfo);

if (!empty($creditsinfo)) {
    $i=0;
    foreach($creditsinfo as $creditsin){
        
        if ( $creditsin['insdate']!='' AND strtotime($creditsin['insdate']) <= strtotime('2021-8-01')) {
            $twoyrdate = '2022-01-01';
        } else {
             $twoyrdate = date('Y-m-d', strtotime($creditsin['insdate'].'+2 years'));
        }
        
        # inserting master values
        $values = array(
                        'exhibitor_id'=>$creditsin['exhibitor_id'],
                        'credit_value'=>$creditsin['crval'],
                        'credit_notes'=>$creditsin['credit_notes'],
                        'credit_by'=>$creditsin['credit_by'],
                        'name'=>$creditsin['name'],
                        'email'=>$creditsin['email'],
                        'companyname'=>$creditsin['companyname'],
                        'purchase_through'=>$creditsin['purchase_through'],
                        'insert_dttm'=>$creditsin['insdate'],
                        'update_dttm'=>$creditsin['update_dttm'],
                        'credit_balance'=>$creditsin['crval'],
                        'expiry_dttm' => $twoyrdate
                        );
     
        $insertid = $db->insert('bmse_exhibitor_credits_master',$values);
        
        /*$consumedcredits = $db->getOne('SELECT sum(`credit_value`) as `usedcr` from `bmse_exhibitor_credits` where `credits`="used" and `exhibitor_id`='.$creditsin['exhibitor_id'].' and DATE(`insert_dttm`)<"2021-08-01"');
        
        $consumedcreditval = $db->getRows('SELECT * from `bmse_exhibitor_credits` where `credits`="used" and `exhibitor_id`='.$creditsin['exhibitor_id'].' and DATE(`insert_dttm`)<"2021-08-01"');
        echo $consumedcredits.'<br/>';
        # insertig consumed values
        if (!empty($consumedcreditval )) {
            foreach($consumedcreditval as $consumedcredit){
                $convalues = array(
                                   'exhibitor_credits_masterid '=>$insertid,
                                   'order_id'=> $consumedcredit['order_id'],
                                   'booth_id'=> $consumedcredit['booth_id'],
                                   'event_id'=> $consumedcredit['event_id'],
                                   'credit_value' => $consumedcredit['credit_value'],
                                   'credit_notes' => $consumedcredit['credit_notes'],
                                   'purchase_through'=>$consumedcredit['purchase_through'],
                                   'insert_dttm'=>$current_date,
                                   'update_dttm'=>$current_date
                                   );
               $db->insert('bmse_exhibitor_credits_detail', $convalues);
            }        
        }
        # updating credit balance
        $crdbal = abs($consumedcredits);
        echo $crdbal;
        $db->query('update `bmse_exhibitor_credits_master` set `credit_balance`=(`credit_value`-'.$crdbal.') WHERE `id`='.$insertid.'');*/
        $i++;
    }
}

echo ''.$i.' Records are inserted.';