bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
include_once("includes/application_includes.php");
//echo "yes";
//ini_set("display_errors",1);
exit;
 $ord = " AND ER.order_status =2 ";
 $where = " WHERE 1=1 ";
 
$rooms1 = $db->getRows("SELECT * FROM 
 (select 
 ER.id as roomid,
 ER.expo_id,
 ER.room_number,
 ER.price,
 M.id as memberid,
 M.name,
 M.email,
 E.name as expon,
 E.start_dttm,
 E.end_dttm,
 E.city,
 M.companyname,
 BC.title,
 O.insert_dttm,
 BC.referred_by,
 ER.special,
 OD.order_id,
 OD.discount,
 OD.booth_promotional_discount,
 OD.lecture_promotional_discount,
 ER.order_status,
 ER.status,
 ((BOH.order_amount - OD.discount -OD.booth_promotional_discount - OD.lecture_promotional_discount )- sum(BOH.paid_amount)) as pending_amount, 
 case
 when (count(BOH.order_id)=0) then 'view'
 when (BOH.order_amount = sum(BOH.paid_amount)) then 'view'
 else 'view/pay' end AS Installment
 from bmse_expo_rooms ER
 left join bmse_booth_configs BC on ER.id = BC.boothid
 left join bmse_order_details OD on ER.id = OD.item_id AND OD.item_type_id = 1
 left join bmse_orders O on O.id = OD.order_id
 left join bmse_members M on M.id = O.member_id
 left join bmse_expos E on E.id=ER.expo_id
 left join bmse_order_history BOH on O.id = BOH.order_id
 where ER.type=" . BOOTH . "
 AND ER.remove = " . ACTIVE ." $ord AND M.status=1
 AND ER.status = ".ACTIVE." AND E.status=1 AND E.remove=1
 group by ER.id
 ORDER BY E.start_dttm ASC) AS ROOMS $where");

if (!empty($rooms1)) {
  $i=1;
foreach ($rooms1 as $room) {

$message='';
 if (round($room['pending_amount'])>0 AND $room['pending_amount']!='') {
 # Mail message build and insert the records in to the scheduler table
 
 # message build
 $message.="Dear ".$room['name'].", ";
 $message.= "Thank you again for joining us in ".$room['city']."! We're looking forward to a fantastic show with you. ";
 $message.="In preparing for the expo, our records show that there is an outstanding balance of ".AmountFormat($room['pending_amount'])." due on your account for booth number #".$room['room_number']." in ".$room['city']." on ".displayDate($room['start_dttm'],'F j')."-".displayDate($room['end_dttm'],'j').", ".displayDate($room['start_dttm'],'Y').". Please take a moment to contact your sales rep at (541) 482-3722 to complete payment at your earliest convenience. Please note that any payments received within 45 days of the expo will result in a late payment fee of $35. ";
 
 $message.="We look forward to seeing you soon! ";
 $message.="Sincerely, 
 Your Body Mind Spirit Expo Event Team";
 
 # inserting the records
 // if ( $room['name']== 'Naomi McTester') {
 $values = array(
 'expo_id' => $room['expo_id'],
 'exponame' => $room['expon'],
 'room_id' => $room['roomid'],
 'room_number'=> $room['room_number'],
 'name'=>$room['name'],
 'email'=>$room['email'],
 //'email' => 'expos2naomi@gmail.com',
 'subject'=> 'Payment Reminder',
 'message'=>$message,
 'insert_dttm'=>$current_date
 
 );
 $db->insert('bmse_payment_reminder_emails', $values);
 // }
 
 }
 $i++;
 
}
}
exit;
exit;
# Sending emails to the exhibitors
$emailsToBeSend = $db->getRows('SELECT * FROM bmse_payment_reminder_emails WHERE strMailStatus = \'PENDING\' order by id ASC ');
$mailCount = 0;
if (!empty($emailsToBeSend)) {
 $mailstoupdate = '';
 $cronstarttime = date('Y-m-d H:i:s');
 foreach ($emailsToBeSend as $emailData) {
 //$to = $emailData['email'];
 //$to = 'expos2naomi@gmail.com';
 $subject = $emailData['subject'];
 $message = $emailData['message'];
 $mailStatus = '';
 $headers = '';
 if ($useMailType != '') {
 // $mailStatus = sendMailThroughSMTP($useMailType, $to, $subject, $message);
 $mailStatus =true;
 } else {
 $mailStatus =true;
 // $mailStatus = sendMailThroughPHP($to, $subject, $message, $headers);
 }

if ($mailStatus) {
            $mailstoupdate.=$emailData['id'] . ',';
            $mailCount++;
        }
    }
    $mailstoupdate.='0';
  $db->query("UPDATE bmse_payment_reminder_emails SET strMailStatus='SEND', update_dttm='$current_date' WHERE id IN ($mailstoupdate)");
} 
$cronendtime = date('Y-m-d H:i:s');
# cron status email
$toe='arvind.purohit@gmail.com';
$subjecte='Cron Run Status';
$messagee='Cron started at '.$cronstarttime.' and ends at '.$cronendtime.'' ;
$headers = '';
						  $headers.= 'From : believe@bmse.net'. "\r\n";
//@mail($toe, $subjecte, $messagee,$headers);