='".$genDate1."' and date(o.order_date)<='".$genDate2."' "; $cpReportSql = $obj->Query("SELECT count(*) as num_of_trans,sum(o.total_amount) as orderAmount,o.coupon_code, o.cp_source,cs.name FROM `tbl_order` o left join coupon_source as cs on cs.id=o.cp_source WHERE o.payment_status=1 and (o.discount_via !='') and o.coupon_code !='' $where group by o.coupon_code order by orderAmount desc "); $enq_message = ''; $enq_message .= "Coupon-Revenue-Report-".date("dMY_H:i")."

"; $enq_message .= "

"; while($result=$obj->fetchNextObject($cpReportSql)){ $noOfTransaction = $result->num_of_trans; $totalReveneu = $result->orderAmount; $couponCode = $result->coupon_code; $website_currency_symbol = "$"; $enq_message .= ""; //selected_option_groups } $enq_message .= " Coupon Code Number Of Transaction Order Amount       $couponCode $noOfTransaction $website_currency_symbol".$totalReveneu."

"; //echo $enq_message;die; $saveOrderItem=1; if($saveOrderItem) { $sendmail = new Sendemail(); $fromEmail = "hello@quicklly.com"; $fromName = "Quicklly.com"; $toEmail = "vivektalko@gmail.com"; $toName = "Coupon-Revenue-Report"; $emailBody = $enq_message; $replyTo = "hello@quicklly.com"; //$replyTo = "vivektalko@gmail.com"; $subject = "Coupon-Revenue-Report-".date("dMY_H:i"); //$bccEmailList="vivektalko@gmail.com"; // $bcc ="hello@quicklly.com,chinglifreshfarms@gmail.com,teammyvalue365@gmail.com"; //$sendmail->sendEmail($fromEmail, $fromName, $toEmail, $toName, $subject, $emailBody, $bcc, $replyTo); //Simple web mail $headers = "MIME-Version: 1.0"."\r\n"; $headers .= "Content-type:text/html;charset=windows-1254"."\r\n"; $headers .= "From: Quicklly.com \r\n"; $headers .= "Bcc: $bccEmailList\r\n"; //@mail($toEmail, $subject, $emailBody, $headers); $sendmail->sendEmail($fromEmail, $fromName, $toEmail, $toName, $subject, $emailBody, $bcc, $replyTo); echo "Report sent successfully!"; } } else { echo "Report sent successfully2!"; } ?>