Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace App\Console;
- use Illuminate\Console\Scheduling\Schedule;
- use Illuminate\Foundation\Console\Kernel as ConsoleKernel;
- class Kernel extends ConsoleKernel
- {
- /**
- * The Artisan commands provided by your application.
- *
- * @var array
- */
- protected $commands = [
- 'App\Console\Commands\emailcron1'
- ];
- /**
- * Define the application's command schedule.
- *
- * @param \Illuminate\Console\Scheduling\Schedule $schedule
- * @return void
- */
- protected function schedule(Schedule $schedule)
- {
- $schedule->command('emailcron2')
- ->everyMinute()
- ->sendOutputTo("/home/mainbiz/conapp/public/test.txt");
- }
- }
- namespace App\Console\Commands;
- use Illuminate\Foundation\Bus\DispatchesJobs;
- use Illuminate\Routing\Controller as BaseController;
- use Illuminate\Foundation\Validation\ValidatesRequests;
- use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
- use Illuminate\Console\Command;
- use DB;
- use Queue;
- use App\Http\Controllers\Controller;
- use App\Fileentry;
- use Request;
- use Session;
- use Redirect;
- use Hash;
- use Mail;
- use App\Http\external\external_cron\MYPDF1;
- use Illuminate\Support\Facades\Storage;
- use Illuminate\Support\Facades\File;
- use Illuminate\Http\Response;
- use App\Company;
- use App\Data;
- use App\SuperAdmin;
- use App\Multiothernames;
- use App\Countries;
- use App\Cities;
- use App\Preview;
- use App\Publish;
- use App\PublishDate;
- use App\Pageno;
- use App\Emailcron;
- use App\Documentbank;
- use App\Spacelimit;
- use App\Demo;
- use View;
- use App\Console\Commands\phpmailer\PHPMailer;
- use Illuminate\Pagination\Facades\LengthAwarePaginator;
- class emailcron1 extends Command
- {
- /**
- * The name and signature of the console command.
- *
- * @var string
- */
- protected $signature = 'emailcron2';
- /**
- * The console command description.
- *
- * @var string
- */
- protected $description = 'Send mails';
- /**
- * Create a new command instance.
- *
- * @return void
- */
- public function __construct()
- {
- parent::__construct();
- //$this->loadAndAuthorizeResource(['class' => "App\\Console\\Commands\\emailcron1"]);
- }
- /**
- * Execute the console command.
- *
- * @return mixed
- */
- public function handle()
- {
- $s="";
- $d = new emailcron1();
- // $d->jb();
- Queue::push("emailcron1@jb",array('string' => 'Hello World '));
- }
- public function show($data,$data1,$news_id,$pub_date){
- $r100="";$r110="";$r12="";$r13="";$r14="";$r15="";$r11="";
- $rt = "✔";
- $id=0;
- $text1="";$j=0;$text2="";
- // require_once('tc.php');
- if($news_id=="12"){
- foreach($data1 as $da){
- $j++;
- if($da->id == $id){
- $rt = "✔";
- }
- if($da->id !== $id){
- $rt = "";
- }
- if($j==1){
- if($da->service == "Change of name" && $da->category == "Single User"){
- $text1 ='<div style="background-color:black;color:white;width:100%; padding:0px;" align="center">'.$da->new_firstname.'</div>I formerly Known as '.'<strong>'.$da->frm_lastname.' '.$da->frm_middlename.' '.$da->frm_firstname.'</strong>'.' henceforth wish to be addressed as '.'<strong>'.$da->new_lastname.' '.$da->new_middlename.' '.$da->new_firstname.'</strong>'.'. All former documents remain valid, general public take note '.$rt;
- }
- if($da->service == "Confirmation of name" && $da->category == "Single User"){
- $text1 ="<strong>CONFIRMATION OF NAME : </strong>"."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." is the same person as "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." All former documents remain valid, general public take note ".$rt;
- }
- if($da->service == "Correction of name" && $da->category == "Single User"){
- $j++;
- if($j%2 ==0 ){
- $text1 ="<strong>CORRECTION OF NAME :</strong> My name is " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." not <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong> ".". All former documents remain valid, general public take note".$rt;
- }
- else if(($j)%2 ==0){
- $text1 ="<strong>CORRECTION OF NAME :</strong> My name was wrongly spelt as " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>" ." instead of <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname. "</strong>. All former documents remain valid, general public take note".$rt;
- // $text4 = $da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname;
- }
- else if(($j)%4 ==0){
- $text1 ="<strong>CORRECTION OF NAME :</strong> Formerly "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." now <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid, general public take note".$rt;
- }
- else{
- $text1 ="<strong>CORRECTION OF NAME : </strong>This is to inform that "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong> "."is the same person as <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid, general public take note".$rt;
- }
- }
- }
- if($j==2){
- if($da->service == "Change of name" && $da->category == "Single User"){
- $text2 ='<div style="background-color:black;color:white;width:100%; padding:0px;" align="center">'.$da->new_firstname.'</div>I formerly Known as '.'<strong>'.$da->frm_lastname.' '.$da->frm_middlename.' '.$da->frm_firstname.'</strong>'.' henceforth wish to be addressed as '.'<strong>'.$da->new_lastname.' '.$da->new_middlename.' '.$da->new_firstname.'</strong>'.'. All former documents remain valid, general public take note '.$rt;
- }
- if($da->service == "Confirmation of name" && $da->category == "Single User"){
- $text2 ="<strong>CONFIRMATION OF NAME : </strong>"."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." is the same person as "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." All former documents remain valid, general public take note ".$rt;
- }
- if($da->service == "Correction of name" && $da->category == "Single User"){
- $j++;
- if($j%2 ==0 ){
- $text2 ="<strong>CORRECTION OF NAME :</strong> My name is " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." not <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong> ".". All former documents remain valid, general public take note ".$rt;
- }
- else if(($j)%2 ==0){
- $text2 ="<strong>CORRECTION OF NAME :</strong> My name was wrongly spelt as " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>" ." instead of <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname. "</strong>. All former documents remain valid, general public take note ".$rt;
- // $text4 = $da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname;
- }
- else if(($j)%4 ==0){
- $text2 ="<strong>CORRECTION OF NAME :</strong> Formerly "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." now <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid, general public take note ".$rt;
- }
- else{
- $text2 ="<strong>CORRECTION OF NAME : </strong>This is to inform that "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong> "."is the same person as <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid, general public take note ".$rt;
- }
- }
- }
- }
- $day = date("l",strtotime($pub_date));
- $month = date("F",strtotime($pub_date));
- $da1 = date("d" ,strtotime($pub_date));
- $da2 = date("Y" ,strtotime($pub_date));
- $tf1 = '<span style="font-size:7px;"><strong >DAILY TRUST,'.$day.','.$month.' '.$da1.', '.$da2.'</strong></span><h2 style="width:100%;border-top: 2px solid black;width:100%; font-size:16px; "><table><tr><td width="470">4</td><td><table><tr><td><span style="font-size:8px;"><strong>Like us on facebook.com/dailytrust</strong></span></td></tr><tr><td><span style="font-size:8px;"><strong>follow us on Twitter: @daily_trust</strong></span></td></tr></table></td></tr></table><hr><span style="font-size:0.5;color:white">nnn</span><hr><span style="font-size:11px;"> Daily Trust</span><br><table cellspacing="10" cellpadding="1" width="100%" ><tr><td width="350"><table>
- <tr><td><span style="font-size:20px;">Classifieds made easy</span></td></tr><tr><td><br><div style="background-color:black;color:white;width:100px;position: absolute;bottom: 0;">CHANGE OF NAME</div></td></tr></table></td><td style="border: 2px solid black;text-align:justify;width:120px;font-size:6.5px; ">'.$text1.'</td> <td style="border: 2px solid black;text-align:justify;width:120px;font-size:6.5px; ">'.$text2.'</td></tr></table><table style="table-layout:fixed;max-width:100%;font-size:7.2px;" cellspacing="10" cellpadding="1" >';
- $r10='';
- $re2="";
- $r1 =""; $r2 ="";$r3 =""; $r4 ="";$r5 =""; $r6 ="";$r7 =""; $r8 ="";$r9 ="";
- $rr1 =""; $rr2 ="";$rr3 =""; $rr4 ="";$rr5 =""; $rr6 ="";$rr7 =""; $rr8 ="";$rr9 ="";
- $k=0;
- $rr1="";
- $text1="";
- $text2="";
- $text3 ="";
- $text4= "";
- $j=0;
- $i=0;
- foreach($data as $da){
- $k++;
- if($da->id== $id){
- $rt = html_entity_decode("✔", ENT_QUOTES | ENT_XML1, 'UTF-8') ;
- }
- if($da->id !== $id){
- $rt = "";
- }
- if($da->service == "Change of name" && $da->category == "Single User"){
- $text1 ='<div style="background-color:black;color:white;width:100%; padding:0px;" align="center">'.$da->new_firstname.'</div>I formerly Known as '.'<strong>'.$da->frm_lastname.' '.$da->frm_middlename.' '.$da->frm_firstname.'</strong>'.' henceforth wish to be addressed as '.'<strong>'.$da->new_lastname.' '.$da->new_middlename.' '.$da->new_firstname.'</strong>'.'. All former documents remain valid, general public take note '.$rt;
- }
- if($da->service == "Confirmation of name" && $da->category == "Single User"){
- $text1 ="<strong>CONFIRMATION OF NAME : </strong>"."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." is the same person as "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." All former documents remain valid, general public take note ".$rt;
- }
- if($da->service == "Correction of name" && $da->category == "Single User"){
- $j++;
- if($j%2 ==0 ){
- $text1 ="<strong>CORRECTION OF NAME :</strong> My name is " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." not <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong> ".". All former documents remain valid, general public take note ".$rt;
- }
- else if(($j)%2 ==0){
- $text1 ="<strong>CORRECTION OF NAME :</strong> My name was wrongly spelt as " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>" ." instead of <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname. "</strong>. All former documents remain valid, general public take note ".$rt;
- // $text4 = $da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname;
- }
- else if(($j)%4 ==0){
- $text1 ="<strong>CORRECTION OF NAME :</strong> Formerly "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." now <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid, general public take note " .$rt;
- }
- else{
- $text1 ="<strong>CORRECTION OF NAME : </strong>This is to inform that "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong> "."is the same person as <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid, general public take note " .$rt;
- }
- }
- if($k<7){
- $i++;
- // $re2 .="<td style='padding:10px;' ><div style='border-top: 2px solid black;'>".$text1."</div></td>";
- $re2 .='<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=7 && $k<=12){
- $rr1 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=13 && $k<=18){
- $rr2 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=19 && $k<=24){
- $rr3 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=25 && $k<=30){
- $rr4 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=31 && $k<=36){
- $rr5 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=37 && $k<=42){
- $rr6 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=43 && $k<=48){
- $rr7 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- if($k>=49 && $k<=50){
- $rr8 .= '<td style="border: 2px solid black;text-align:justify; ">'.$text1.'</td>';
- }
- }
- if($re2!=""){
- $r1 .= "<tr>".$re2."</tr>";
- // $r1 .= "<div>".$re2."</div>";
- }
- if($rr1!=""){
- $r2 .= "<tr>".$rr1."</tr>";
- }
- if($rr2!=""){
- $r3 .= "<tr>".$rr2."</tr>";
- }
- if($rr3!=""){
- $r4 .= "<tr>".$rr3."</tr>";
- }
- if($rr4!=""){
- $r5 .= "<tr>".$rr4."</tr>";
- }
- if($rr5!=""){
- $r6 .= "<tr>".$rr5."</tr>";
- }
- if($rr6!=""){
- $r7 .= "<tr>".$rr6."</tr>";
- }
- if($rr7!=""){
- $r8 .= "<tr>".$rr7."</tr>";
- }
- if($rr8!=""){
- $r9 .= "<tr>".$rr8."</tr>";
- }
- $r11="";
- $r11.= "</table></span></h2>";
- // Print a text
- $html = $tf1.$r10.$r1.$r2.$r3.$r4.$r5.$r6.$r7.$r8.$r9.$r11;
- return $html;
- }
- else if($news_id == "13"){
- $r10='<table style="table-layout:fixed;max-width:100%;font-size:6.7px;" cellspacing="3" cellpadding="1">';
- $re2="";
- $r1 =""; $r2 ="";$r3 =""; $r4 ="";$r5 =""; $r6 ="";$r7 =""; $r8 ="";$r9 ="";
- $rr1 =""; $rr2 ="";$rr3 =""; $rr4 ="";$rr5 =""; $rr6 ="";$rr7 =""; $rr8 ="";$rr9 ="";
- $rr10 =""; $rr11 ="";$rr12 =""; $rr13 ="";$rr14 =""; $rr15 ="";
- $k=0;
- $rr1="";
- $text1="";
- $text2="";
- $text3 ="";
- $text4= "";
- $j=0;
- $id=0;
- $i=0;
- $rt ="✔";
- $id=0;
- foreach($data as $da){
- $k++;
- if($da->id == $id){
- $rt = html_entity_decode("✔", ENT_QUOTES | ENT_XML1, 'UTF-8') ;
- }
- if($da->id !== $id){
- $rt = "";
- }
- $rt="";
- if($da->service == "Change of name" && $da->category == "Single User"){
- $text1 ='<span style="text-transform: uppercase;"><strong>'.$da->new_firstname.'</strong></span>:'.' I formerly '.$da->frm_lastname.' '.$da->frm_middlename.' '.$da->frm_firstname.''.' now '.$da->new_lastname.' '.$da->new_middlename.' '.$da->new_firstname.' . All former documents remain valid. General public take note <span style="font-size:12px;">'.$rt.'</span>';
- }
- if($da->service == "Confirmation of name" && $da->category == "Single User"){
- $text1 ="<strong>CONFIRMATION OF NAME:</strong><strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." is the same person as "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." All former documents remain valid.General public take note ".$rt;
- }
- if($da->service == "Correction of name" && $da->category == "Single User"){
- $j++;
- if($j%2 ==0 ){
- $text1 ="<strong>CORRECTION OF NAME:</strong> My name is " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." not <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong> ".". All former documents remain valid. general public take note ".$rt;
- }
- else if(($j)%2 ==0){
- $text1 ="<strong>CORRECTION OF NAME:</strong> My name was wrongly spelt as " ."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>" ." instead of <strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname. "</strong>. All former documents remain valid. General public take note ".$rt;
- // $text4 = $da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname;
- }
- else if(($j)%4 ==0){
- $text1 ="<strong>CORRECTION OF NAME:</strong> Formerly "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong>"." now <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid. General public take note " .$rt;
- }
- else{
- $text1 ="<strong>CORRECTION OF NAME:</strong> This is to inform that "."<strong>".$da->frm_lastname." ".$da->frm_middlename." ".$da->frm_firstname."</strong> "."is the same person as <strong>".$da->new_lastname." ".$da->new_middlename." ".$da->new_firstname."</strong>".". All former documents remain valid. General public take note " .$rt;
- }
- }
- if($k<7){
- $i++;
- // $re2 .="<td style='padding:10px;' ><div style='border-top: 2px solid black;'>".$text1."</div></td>";
- $re2 .='<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=7 && $k<=12){
- $rr1 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=13 && $k<=18){
- $rr2 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=19 && $k<=24){
- $rr3 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=25 && $k<=30){
- $rr4 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=31 && $k<=36){
- $rr5 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=37 && $k<=42){
- $rr6 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=43 && $k<=48){
- $rr7 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=49 && $k<=54){
- $rr8 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=55 && $k<=60){
- $rr9 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=61 && $k<=66){
- $rr10 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=67 && $k<=72){
- $rr11 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=73 && $k<=78){
- $rr12 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=79 && $k<=84){
- $rr13 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- else if($k>=85 && $k<=90){
- $rr14 .= '<td style="text-align:justify; ">'.$text1.'</td>';
- }
- }
- if($re2!=""){
- $r1 .= "<tr>".$re2."</tr>";
- // $r1 .= "<div>".$re2."</div>";
- }
- if($rr1!=""){
- $r2 .= "<tr>".$rr1."</tr>";
- }
- if($rr2!=""){
- $r3 .= "<tr>".$rr2."</tr>";
- }
- if($rr3!=""){
- $r4 .= "<tr>".$rr3."</tr>";
- }
- if($rr4!=""){
- $r5 .= "<tr>".$rr4."</tr>";
- }
- if($rr5!=""){
- $r6 .= "<tr>".$rr5."</tr>";
- }
- if($rr6!=""){
- $r7 .= "<tr>".$rr6."</tr>";
- }
- if($rr7!=""){
- $r8 .= "<tr>".$rr7."</tr>";
- }
- if($rr8!=""){
- $r9 .= "<tr>".$rr8."</tr>";
- }
- if($rr9!=""){
- $r100 = "<tr>".$rr9."</tr>";
- }
- if($rr10!=""){
- $r110 = "<tr>".$rr10."</tr>";
- }
- if($rr11!=""){
- $r12 = "<tr>".$rr11."</tr>";
- }
- if($rr12!=""){
- $r13 = "<tr>".$rr12."</tr>";
- }
- if($rr13!=""){
- $r14 = "<tr>".$rr13."</tr>";
- }
- if($rr14!=""){
- $r15 = "<tr>".$rr14."</tr>";
- }
- $r11="";
- $r11.= "</table>";
- $page1="";
- $day = date("l",strtotime($pub_date));
- $month = date("F",strtotime($pub_date));
- $da1 = date("d",strtotime($pub_date));
- $da2 = date("Y",strtotime($pub_date));
- //$page = Pageno::whereRaw("newspaper_id='".$idj."'")->get();
- $tfr = '<div style="font-size:7px">11 | '.$day.','.$month.','.$da1.','.$da2.' THE GUARDIAN www.ngrguardiannews.com<hr></div><div style="border:0.5px solid black;"><div style="font-size:18px; background-color:black;color:white">Change of Name</div>';
- // Print a text
- $html = $tfr.$r10.$r1.$r2.$r3.$r4.$r5.$r6.$r7.$r8.$r9.$r100.$r110.$r12.$r13.$r14.$r15.$r11."</div>";
- //$pdf->writeHTML($html, true, false, true, false, '');
- return $html;
- //$i++;
- // $re2 .="<td style='padding:10px;' ><div style='border-top: 2px solid black;'>".$text1."</div></td>";
- //$r2= slot2($a->id,$data);
- // add a page
- // Print a text
- // ---------------------------------------------------------
- //Close and output PDF document
- //$pdf->Output('Template1.pdf', 'I');
- //============================================================+
- // END OF FILE
- //============================================================+
- //return view('preview_temp');
- }
- //$filename =$dd.".pdf";
- }
- public function jb(){
- echo 3;
- $email_cron = DB::table('email_cron')
- ->orderBy('id', 'asc')->take(1)
- ->get();
- foreach($email_cron as $er){
- $idfs = $er->id;
- $news_id = $er->newspaper_id;
- $pub_date = $er->date;
- $pageno = $er->pageno;
- }
- $spacelimit = Spacelimit::whereRaw("status='enabled' and newspaper_id='".$news_id."'")->get();
- foreach($spacelimit as $sp){
- $space_limit1 = $sp->newspaper_id;
- }
- $data1="";
- if($space_limit1==50){
- $data = Data::whereRaw("status='enabled' and status_main='onQueue' newspaper='".$news_id."' order by id desc limit 48 ")->get();
- $data3 = Data::whereRaw("status='enabled' and status_main='onQueue' newspaper='".$news_id."' order by id desc limit 48 ")->get();
- $data1 = Data::whereRaw("status='enabled' and status_main='onQueue' newspaper='".$news_id."' order by id desc limit 2 ")->get();
- }
- else{
- $data3 = Data::whereRaw("status='enabled' and status_main='onQueue' and newspaper='".$news_id."' order by id desc limit 90 ")->get();
- $data = Data::whereRaw("status='enabled' and status_main='onQueue' and newspaper='".$news_id."' order by id desc limit 90 ")->get();
- // $data1 = Data::whereRaw("status='enabled' and status_main='onQueue' newspaper='".$news_id."' order by id desc limit 2 ")->get();
- }
- $k=0;
- $d = new emailcron1();
- foreach($data as $ae){
- $k++;
- $pdf = new MYPDF1(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
- $pdf->SetCreator(PDF_CREATOR);
- $pdf->SetAuthor('Nicola Asuni');
- $pdf->SetTitle('TCPDF Example 051');
- $pdf->SetSubject('TCPDF Tutorial');
- $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
- // set header and footer fonts
- $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
- // set default monospaced font
- $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
- // set margins
- $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
- $pdf->SetHeaderMargin(0);
- $pdf->SetFooterMargin(0);
- // remove default footer
- $pdf->setPrintFooter(false);
- // set auto page breaks
- //$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
- // set image scale factor
- $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
- // set some language-dependent strings (optional)
- if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
- require_once(dirname(__FILE__).'/lang/eng.php');
- $pdf->setLanguageArray($l);
- }
- //$pdf->setFontSubsetting(false) ;
- //$pdf->pdfa_mode(false);
- $pdf->SetFont('dejavusans', '', 1);
- // add a page
- $pdf->AddPage();
- //echo $i;
- //$compressed = gzcompress(, 9);
- //break;
- $pdf->writeHTML($d->show($data3,$data1,$news_id,$pub_date), true, false, true, false, '');
- $pdf->output("/home/mainbiz/public_html/conapp_update/t1/".$k.".pdf","F");
- $file = "/home/mainbiz/public_html/conapp_update/t1/".$k.".pdf";
- $first_name = $ae->new_firstname;
- if($ae->service=="Confirmation of name"){
- $first_name = $ae->frm_firstname;
- }
- $datart = array("hi",$file,$ae->email,$first_name,$ae->service);
- if($k<=6){
- $row = 1;
- $column = $k;
- }
- else if($k>=7 && $k<=12 ){
- $row = 2;
- $column = $k-6;
- }
- else if($k>=13 && $k<=18 ){
- $row = 3;
- $column = $k-12;
- }
- else if($k>=19 && $k<=24 ){
- $row = 4;
- $column = $k-18;
- }
- else if($k>=25 && $k<=30 ){
- $row = 5;
- $column = $k-24;
- }
- else if($k>=31 && $k<=36 ){
- $row = 6;
- $column = $k-30;
- }
- else if($k>=37 && $k<=42 ){
- $row = 7;
- $column = $k-36;
- }
- else if($k>=43 && $k<=48 ){
- $row = 8;
- $column = $k-42;
- }
- else if($k>=49 && $k<=54 ){
- $row = 9;
- $column = $k-48;
- }
- else if($k>=55 && $k<=60 ){
- $row = 10;
- $column = $k-54;
- }
- else if($k>=61 && $k<=66 ){
- $row = 11;
- $column = $k-60;
- }
- else if($k>=67 && $k<=72 ){
- $row = 12;
- $column = $k-66;
- }
- else if($k>=73 && $k<=78 ){
- $row = 13;
- $column = $k-72;
- }
- else if($k>=79 && $k<=84 ){
- $row = 14;
- $column = $k-78;
- }
- else if($k>=85 && $k<=90 ){
- $row = 15;
- $column = $k-84;
- }
- $_SESSION['firstname_em2'] = $first_name ;
- $_SESSION['pub_date_em2'] = date("jS F Y",strtotime($pub_date)) ;
- $_SESSION['row_em2'] = $row ;
- $_SESSION['column_em2'] = $column;
- $_SESSION['pageno_em2'] = $pageno;
- $_SESSION['service_em2'] = $ae->service;
- //return $ae->service;
- $d = Data::find($ae->id);
- $d->status_main= "Processed";
- $d->save();
- /* Mail::send('email2', $datart, function($message) use ($datart)
- {
- $message->from('noreply@conapp.com', 'CONAPP');
- $message->to($datart[2])->subject($datart[4]." For ".$datart[3]);
- $message->attach($datart[1]);
- });
- } */
- $message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Conapp</title>
- </head>
- <body>
- Dear '.$_SESSION['firstname_em2'].',
- <br /><br />
- Your <b>advert request</b> for <b>'.$_SESSION['service_em2'].' </b> has been successfully processed and the <b>digital version</b> of your <b>advert publication</b> is attached herewith. Spot your <b>advert</b> in the slot/space marked with this tick <span style="font-size:18px;"> ✔</span> icon.
- <br /><br />
- Other advert publication details are as follows;
- <br /><br />
- <b>Your Newspaper Advert:</b>
- <br /><br />
- ✔ Publication Date – '.$_SESSION['pub_date_em2'].'.<br />
- ✔ Advert Space statistics – Row '.$_SESSION['row_em2'].' Column '.$_SESSION['column_em2'].' on page '.$_SESSION['pageno_em2'].' .<br />
- ✔ Newspaper copy – 1 free copy.<br />
- ✔ Newspaper dispatch – free delivery 7 days from now.<br /><br />
- <b>Your Digital Advert:</b><br /><br />
- ✔ Publication Date – Today.<br />
- ✔ Advert Space Statistics – ;Advert Space statistics – Row '.$_SESSION['row_em2'].' Column '.$_SESSION['column_em2'].' on page '.$_SESSION['pageno_em2'].'. <br />
- ✔ Digital copy – <span style="color:#0F9;">Download from attachment, share or print</span>.<br /><br />
- We value your patronage, please spare three (3) minutes of your time, click on the link below to rate our App vis-à-vis your user experience.
- <br /> <br />
- Thank you.
- <br /><br />
- Conapp Project Team<br />
- <b>Mainstream System Solutions </b>
- <br /><br />
- <img src="http://www.mainstreamss.biz/conapp_update/images/inq.png"/>
- <img src="http://www.mainstreamss.biz/conapp_update/t1/1.pdf"/>
- </body>
- </html>';
- //$file = "/home/mainbiz/public_html/conapp_update/t1/1.pdf";
- $datart = array("hi",$file,$ae->email,$first_name,$ae->service);
- $email = new PHPMailer();
- $email->IsSMTP(); // enable SMTP
- $email->SMTPDebug = 1; // debugging: 1 = errors and messages, 2 = messages only
- $email->SMTPAuth = true; // authentication enabled
- $email->SMTPSecure = 'ssl'; // secure transfer enabled REQUIRED for Gmail
- $email->Host = "gator3099.hostgator.com";
- $email->Port = 465; // or 587
- $email->IsHTML(true);
- $email->Username = "shola@mainstreamss.biz";
- $email->Password = "shola.2015";
- $email->From = 'shola@mainstreamss.biz';
- $email->FromName = 'CONAPP';
- $email->Subject = $datart[4]." For ".$datart[3];
- $email->Body = $message;
- $email->AddAddress( $ae->email );
- $file_to_attach = 'PATH_OF_YOUR_FILE_HERE';
- $email->AddAttachment( $file , 'L2.pdf' );
- return $email->Send();
- $cp = Emailcron::find($idfs);
- //$cp->delete();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement