bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
include('includes/application_includes.php');

$temp_values['cob_amount']=50;
   $temp_values['order_id']=100018765;
   $temp_cart['user_id']=916300059;
   
if (isset($temp_values['cob_amount']) AND ($temp_values['cob_amount']>0)) {
                           
                             $exinfo = $db->getRow('SELECT `name`, `email`, `companyname` FROM `bmse_members` WHERE `id`='.$temp_cart['user_id'].'');
                                        
                                        /* $InsertCredit = array(
                                                               'exhibitor_id' => $temp_cart['user_id'],
                                                               'order_id' => $temp_values['order_id'],
                                                               'credit_value'=> -$temp_values['cob_amount'],
                                                               'credit_notes' => $temp_values['order_notes'],
                                                               'credits' => 'used',
                                                               'purchase_through'=> 'admin',
                                                               'name' => $exinfo['name'],
                                                               'email' => $exinfo['email'],
                                                               'companyname' => $exinfo['companyname'],
                                                               'insert_dttm' => $current_date
                                                               );
                                         $db->insert('bmse_exhibitor_credits', $InsertCredit); */
                                        
                     $creditsinfoea = $db->getRows('SELECT `id`, `exhibitor_id`, `credit_value`, `credit_balance` FROM `bmse_exhibitor_credits_master` WHERE  `exhibitor_id`='.$temp_cart['user_id'].' AND `status`=1 AND `remove`=1 AND `credit_balance` > 0  order by `insert_dttm` ASC');
                    
                    $requiredea =$temp_values['cob_amount'];
                    ArrayDisplay($creditsinfoea);
                    if (!empty($creditsinfoea)) {
                        $val=0;
                         $val1=0;
                        $crar=array();
                        foreach($creditsinfoea as $creditsin){
                               //10 < 50
                                if ($requiredea>0) {
                                    if ($creditsin['credit_balance'] <= $requiredea ) {
                                    // echo 'yes';
                                       $val+= $creditsin['credit_balance'];
                                       $creditsin['credits_used']=$creditsin['credit_balance'];
                                       $crar[]=$creditsin;
                                       $requiredea = $requiredea-$creditsin['credit_balance'];
                                    }
                                     // 40 >  10
                                    else if ($creditsin['credit_balance'] >= $requiredea ) {
                                    //  echo 'yes1';
                                       $creditsin['credits_used']=$requiredea;
                                        $crar[]=$creditsin;
                                        $requiredea = $requiredea-$creditsin['credit_balance'];
                                      }
                                }
                          }
                    }
                   ArrayDisplay($crar);
                    if (isset($temp_values['cob_amount']) AND ($temp_values['cob_amount']!='')) {
                         if (!empty($crar)) {
                                foreach($crar as $crarin){
                                   $crvalues = array(
                                                     'exhibitor_credits_masterid' =>  $crarin['id'],
                                                     'order_id'=>$temp_values['order_id'],
                                                     'credit_value'=>-$crarin['credits_used'],
                                                     'credit_notes'=>'Vendor Paid Installment from UI through EA',
                                                     'purchase_through'=>'UI',
                                                     'credit_comments'=> 'Vendor Paid Installment from UI through EA',
                                                     'insert_dttm'=>$current_date,
                                                     'update_dttm'=>$current_date
                                                     );
                                  ArrayDisplay($crvalues);
                                 // $db->insert('bmse_exhibitor_credits_detail', $crvalues);
                                // $db->query('update `bmse_exhibitor_credits_master` SET `credit_balance`=(`credit_balance`-'.$crarin['credits_used'].') WHERE `id`='.$crarin['id'].'' );
                                }
                         }
                        
                    }
                    
}                  
?>