<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Re extends CI_Controller {
	public function __construct()
	{
		parent::__construct();
		session_start();
		
	
		
		$this->load->model('admin_m');		
		$this->load->model('audits_m');	
		$this->load->model('invoices_m');
	}
	
	public function aa()
	{
			print 's';
	}
	
	public function send_email($id2='',$sending='')
	{
		$listing = $this->invoices_m->get_unpaid_invoice();
		
		foreach($listing as $aa)
		{
			$id = $aa['id'];
		
			if($id == '')
			{
				print 'ERROR';
				exit;
			}
			
			
			$info = $this->invoices_m->info($id);
		
			$items = $this->invoices_m->get_invoice_items($id);
			
			$issue_date = date('d F Y',strtotime($info['issue_date']));
			$due_date = date('d F Y',strtotime($info['due_date']));
			$to = $info['company_name'];
			$to_address = $info['to_address'];
			
			$data = array(
				'invoice_number' => $info['invoice_no'],
				'po_reference' => $info['po_number'],
				'issue_date' => $issue_date,
				'due_date' => $due_date,
				'to' => $to,
				'to_address' => $to_address,
			);
			
			$gst = 0;
			$gst = ($s['qty']*$s['unit_price'])*0.09;
			$total = ($s['qty']*$s['unit_price'])*1.09;
		
			
			foreach($items as $s)
			{
				
				$item[] = array(
					'item' => $s['item'],
					'desc' => $s['description'],
					'qty' => $s['qty'],
					'price' => $s['unit_price'],
					'discount' => $s['discount'],
					'gst_value' => $s['gst_value'],
					'gst' => $gst,
					'total' => $total,
					'refund' => $s['refund'],
				);
			}
			
			$data['items'] = $item;
			
			$content = '';
			$html = '';
			
			$content = '<p>Dear Member,</p>
	<p>
	In case you have missed our email below due to your busy schedule, we are sending this again.  The attached invoice is currently still outstanding in our records and we would greatly appreciate if you could process the payment at your soonest convenience, please.
	</p>
	<p>Thank you for your attention as always.</p>';
			
			$data['content'] = $content;
			
			$html = $this->load->view('emails/mass-email.php',$data,TRUE);
			
			$html =  str_replace('[COMPANY NAME]',$info['company_name'],$html);
			$html =  str_replace('[RECIPIENT NAME]',$info['invoice_primary_name'],$html);
		
			$old_html = '';
			
			if($id != '')
			{
				$old_html = $this->old_send_email($id );
				$html .= $old_html;
			}
			
			
										
			$from = 'replies@imas.org.sg';
			$username = $this->config->item('username');
			$password = $this->config->item('password');
			$host = $this->config->item('host');
			$port = $this->config->item('port');
			$from_name = $this->config->item('from_name');
			
			$subject = '[REMINDER] IMAS Annual Membership Subscription Fees for FY2024/25 - [INVOICE NO]';
			
			$subject =  str_replace('[INVOICE NO]',$info['invoice_no'],$subject);
			
			$to = '';
			$cc = '';
			$to = $info['invoice_primary_email'];
			
			
			$cc = $info['invoice_cc_email'];
		
			$cc .= ',replies@imas.org.sg';
			
			$data['invoice_no'] = $invoice_no = $info['invoice_no'];
			$data['info'] = $info;
			
			
			$po_no = $info['invoice_no'];
				
			if($info['po_number'] != '')
			{
				$po_no = $info['po_number'];
			} 
			
			$data['po_no'] = $po_no;
			
			$data['date'] = date('d F Y');
			$data['companyname'] = $info['company_name'];
			
			$registration_info['invoice_address1'] = $info['to_address'];
			
			$registration_info['invoice_attention_to'] = $info['invoice_primary_name'];
			
			
			$data['registration_info'] = $registration_info;
			$data['date'] = date('d F Y');
			$html2 = $this->load->view('backend/invoices/invoice_pdf_1',$data,true);
			$invoice_no2 = str_replace("/", "-", $invoice_no);
			pdf_create($html2,$invoice_no2,false);	
			
			$invoice_no = $info['invoice_no'];
			
			$file = '';
			$filename = '';
			$file = 'uploads/'.$invoice_no2.'.pdf';
			$filename = $invoice_no2.'.pdf';	
			
			
			
			if($to != '' && $sending == 3)
			{
				if($cc == '0')
					$cc = '';
				
				send_email($to,$host,$port,$username,$password,$from,$from_name,$subject,$html,$file,$filename,$file2,$filename2,$cc);
				
				$data2 = array(
					'datetime_reminder_sent'	=> date('Y-m-d H:i:s'),
				);
				
				
				$this->invoices_m->update($id,$data2);
				
				
			}
		
		}
		
		print 'DONE';
	}
	public function old_send_email($id='')
	{
		
		$info = $this->invoices_m->info($id);
		$items = $this->invoices_m->get_invoice_items($id);
		
		$issue_date = date('d F Y',strtotime($info['issue_date']));
		$due_date = date('d F Y',strtotime($info['due_date']));
		$to = $info['company_name'];
		$to_address = $info['to_address'];
		
		$data = array(
			'invoice_number' => $info['invoice_no'],
			'po_reference' => $info['po_number'],
			'issue_date' => $issue_date,
			'due_date' => $due_date,
			'to' => $to,
			'to_address' => $to_address,
		);
		
		$gst = 0;
		$gst = ($s['qty']*$s['unit_price'])*0.09;
		$total = ($s['qty']*$s['unit_price'])*1.09;
	
		
		foreach($items as $s)
		{
			$item[] = array(
				'item' => $s['item'],
				'desc' => $s['description'],
				'qty' => $s['qty'],
				'price' => $s['unit_price'],
				'discount' => $s['discount'],
				'gst' => $gst,
				'total' => $total,
				'refund' => $s['refund'],
			);
		}
		
		$data['items'] = $item;
		$data['info'] = $info;
		
		$content = $info['email_content'];
		
		$data['content'] = $content;
		
		$html = $this->load->view('emails/mass-email-old.php',$data,TRUE);
		
		$html =  str_replace('[COMPANY NAME]',$info['company_name'],$html);
		$html =  str_replace('[RECIPIENT NAME]',$info['invoice_primary_name'],$html);

		return $html;
	}
	
}
/* End of file welcome.php */
/* Location: ./application/controllers/welcome.php */