<?php if(customer_any_cell($this->session->userdata('customer_id'), 'reseller_level') == '3'){?>
<!--****** check logo for admin ********-->
<?php if(settings_any_cell('logo', '0') != ''){ ?>
<img src="<?php echo base_url();?>media/images/<?php echo settings_any_cell('logo', '0');?>" height="33" />
<!--****** apply default ********-->
<?php } else { ?>
<img src="<?php echo base_url();?>assets/images/logo.png" alt="Digital Linx" height="33" width="167">
<?php } ?>
<?php } else { ?>
<!--****** check logo for reseller parent ********-->
<?php if(settings_any_cell('logo', customer_any_cell($this->session->userdata('customer_id'), 'parent_id')) != ''){ ?>
<img src="<?php echo base_url();?>media/images/<?php echo settings_any_cell('logo', customer_any_cell($this->session->userdata('customer_id'), 'parent_id'));?>" height="33" />
<?php } else { ?>
<!--****** check logo for admin ********-->
<?php if(settings_any_cell('logo', '0') != ''){ ?>
<img src="<?php echo base_url();?>media/images/<?php echo settings_any_cell('logo', '0');?>" height="33" />
<!--****** apply default ********-->
<?php } else { ?>
<img src="<?php echo base_url();?>assets/images/logo.png" alt="Digital Linx" height="33" width="167">
<?php } ?>
<?php } ?>
<?php } ?>
<?php } ?>
<?php } ?>
</div>
<?php if(!isset($dont_show_this)){?>
<div id="top-links">
<?php
//]]>
</script>
<title><?php echo $this->lang->line('main_screen_title_bar');?></title>
</head>
<body class="login">
<div class="login-box">
<div class="login-border">
<div class="login-style">
<div class="login-header">
<div class="logo clear">
<?php if(settings_any_cell('logo', '0') != ''){ ?>
<img src="<?php echo base_url();?>media/images/<?php echo settings_any_cell('logo', '0');?>" class="picture" />
<?php } else { ?>
<img src="<?php echo base_url();?>assets/images/logo.png" alt="" class="picture">
<?php } ?>
</div>
</div>
<div class="error" id="err_div" <?php if($this->session->flashdata('error_message') == '') { echo 'style="display:none;"'; }?>><?php echo $this->session->flashdata('error_message');?> </div>
<div class="success" id="success_div" style="display:none;"></div>
<form name="loginForm" id="loginForm" action="<?php echo base_url();?>home/do_login" method="post" enctype="multipart/form-data">
<div class="login-inside">
<div class="login-data">
<div class="row clear">
<label for="user"><?php echo $this->lang->line('main_screen_username');?>
</label>
function generate_invoices_parent_r3_child_r2()
{
$current_date = date('Y-m-d');
$current_date_time = strtotime($current_date);
$sql = "SELECT customer_id, customer_billing_cycle, customer_prepaid, next_invoice_date, customer_firstname, customer_lastname, customer_address, customer_city, customer_country, customer_phone_prefix, customer_phone, customer_send_cdr, customer_billing_email, parent_id, grand_parent_id FROM customers WHERE next_invoice_date = '".$current_date_time."' && reseller_level = '2' && parent_id != '0'";
$query = $this->db->query($sql);
/*//for testing only
$sql = "SELECT customer_id, customer_billing_cycle, customer_prepaid, next_invoice_date, customer_firstname, customer_lastname, customer_address, customer_city, customer_country, customer_phone_prefix, customer_phone, customer_send_cdr, customer_billing_email, parent_id, grand_parent_id FROM customers WHERE reseller_level = '2' && parent_id != '0'";*/
if($query->num_rows() > 0) //if there are resellers whose next inv date is today
{
foreach($query->result() as $row)
{
$customer_id = $row->customer_id;
$billing_cycle = $row->customer_billing_cycle;
$is_prepaid = $row->customer_prepaid;
//other info
$customer_name = $row->customer_firstname.' '.$row->customer_lastname;
$customer_address = $row->customer_address;
$customer_city_country = $row->customer_city.', '.$row->customer_country;
$customer_contact = $row->customer_phone_prefix.$row->customer_phone;
$customer_send_cdr = $row->customer_send_cdr;
$customer_email = $row->customer_billing_email;
$customer_parent_id = $row->parent_id;
$customer_grand_parent_id = $row->grand_parent_id;
//get the last invoice id generated for particular customer
$sql2 = "SELECT MAX(id) AS id FROM invoices WHERE customer_id = '".$customer_id."' ";
$query2 = $this->db->query($sql2);
$row2 = $query2->row();
if($row2->id != '') //if there is invoice generated last time
{
$sql3 = "SELECT to_date FROM invoices WHERE id = '".$row2->id."' ";
$query3 = $this->db->query($sql3);
$row3 = $query3->row();
$date_from = $row3->to_date;
}
else //this is the first invoice
{
$m= date("m");
$d= date("d");
$y= date("Y");
if($billing_cycle == 'daily')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d-1),$y));
$date_from = strtotime($dd);
}
else if($billing_cycle == 'weekly')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d-7),$y));
$date_from = strtotime($dd);
}
else if($billing_cycle == 'bi_weekly')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d-14),$y));
$date_from = strtotime($dd);
}
else if($billing_cycle == 'monthly')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d-30),$y));
$date_from = strtotime($dd);
}
}
// to 2011-12-16 00:00:00 (less or equal to 2011-12-16 00:00:00)
// from 2011-12-15 00:00:00 (greater than from starting from 2011-12-15 00:00:01)
$cdr_from = $date_from * 1000000; //convert into micro seconds
$cdr_to = $current_date_time * 1000000; //convert into micro seconds
/*//for testing only
$cdr_to = time() * 1000000; //convert into micro seconds*/
//sum total invoice amount from cdr between 2 dates
//get the reseller 2 own total invoice amount and total calls he made (than we will see for his customers )
$sql4 = "SELECT SUM(total_sell_cost) as total_invoice_amount, COUNT(*) as total_calls FROM cdr WHERE customer_id = '".$customer_id."' AND (hangup_cause = 'ALLOTTED_TIMEOUT' || hangup_cause = 'NORMAL_CLEARING') AND billsec > 0 AND created_time > '".sprintf("%.0f", $cdr_from)."' AND created_time <= '".sprintf("%.0f", $cdr_to)."' AND parent_id = '0'";
$query4 = $this->db->query($sql4);
$row4 = $query4->row();
$total_invoice_amount = $row4->total_invoice_amount;
if($total_invoice_amount == '')
{
$total_invoice_amount = 0;
}
$total_calls_made = $row4->total_calls;
$status = "pending";
if($total_invoice_amount == 0)
{
$status = "paid";
}
else if($is_prepaid == '1')
{
$status = "paid";
}
//now sum total sell cost for his customers and total calls his childrens makes according to reseller 3 rates
$sqlResellerChild = "SELECT SUM(total_reseller_sell_cost) as total_invoice_amount, COUNT(*) as total_calls FROM cdr WHERE (parent_reseller_id = '".$customer_id."' || grand_parent_reseller_id = '".$customer_id."') AND (hangup_cause = 'ALLOTTED_TIMEOUT' || hangup_cause = 'NORMAL_CLEARING') AND billsec > 0 AND created_time > '".sprintf("%.0f", $cdr_from)."' AND created_time <= '".sprintf("%.0f", $cdr_to)."' AND parent_id = '0'";
$queryResellerChild = $this->db->query($sqlResellerChild);
$rowResellerChild = $queryResellerChild->row();
$total_reseller_children_invoice_amount = $rowResellerChild->total_invoice_amount;
if($total_reseller_children_invoice_amount == '')
{
$total_reseller_children_invoice_amount = 0;
}
$total_reseller_children_calls_made = $rowResellerChild->total_calls;
$grand_reseller_inv_amt = $total_invoice_amount + $total_reseller_children_invoice_amount;
$grand_reseller_tot_calls = $total_calls_made + $total_reseller_children_calls_made;
//generate random invoice number
$invoice_number = 'INV-'.rand(1,999).rand(1,9).time();
//due date
$due_date = $current_date_time + 604800; //generated date + 7 days
//now we are all good to insert the invoice
$sql5 = "INSERT INTO invoices (invoice_id , customer_id, from_date, to_date, total_charges, total_calls, customer_prepaid, invoice_generated_date, due_date, status, parent_id, grand_parent_id) VALUES ('".$invoice_number."', '".$customer_id."', '".$date_from."', '".$current_date_time."', '".$grand_reseller_inv_amt."', '".$grand_reseller_tot_calls."' ,'".$is_prepaid."', '".$current_date_time."', '".$due_date."', '".$status."', '".$customer_parent_id."', '".$customer_grand_parent_id."')";
$query5 = $this->db->query($sql5);
//update the next invoice date for customer
$m= date("m");
$d= date("d");
$y= date("Y");
if($billing_cycle == 'daily')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d+1),$y));
$next_invoice_date = strtotime($dd);
}
else if($billing_cycle == 'weekly')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d+7),$y));
$next_invoice_date = strtotime($dd);
}
else if($billing_cycle == 'bi_weekly')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d+14),$y));
$next_invoice_date = strtotime($dd);
}
else if($billing_cycle == 'monthly')
{
$dd = date('Y-m-d',mktime(0,0,0,$m,($d+30),$y));
$next_invoice_date = strtotime($dd);
}
$sql6 = "UPDATE customers SET next_invoice_date = '".$next_invoice_date."' WHERE customer_id = '".$customer_id."'";
$query6 = $this->db->query($sql6);
//generate pdf invoice and save
$obj = new $this->pdf;
// set document information
$obj->SetSubject('Invoice');
$obj->SetKeywords('Digital Linx, Invoice, CDR');
// add a page
$obj->AddPage();
$obj->SetFont('helvetica', '', 6);
$tbl = '<table width="100%" cellspacing="0" cellpadding="0" border="0" style="margin:0px;margin-left:auto;margin-right:auto;padding:5px">
<tbody>
<tr>
<td align="center" colspan="2">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody><tr>
<td align="right" style="font-weight:bold;color:red" colspan="2">Invoice # '.$invoice_number.'</td>
</tr>
<tr>
<td align="right" style="font-weight:bold;" colspan="2">Date: '.$current_date.'</td>
</tr>
<tr>
<td align="right" style="font-weight:bold;" colspan="2">Due Date: '.date('Y-m-d H:i:s', $due_date).'</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td align="center">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody>
<tr>
<td style="background-color:#777777;color:#fff;padding-left:10px" align="left">
From:
</td>
</tr>
<tr>
<td align="left">
<table width="100%">
<tbody><tr><td>DigitalLinx.com</td></tr>
<tr><td>P.O. Box 305319</td></tr>
<tr><td>Riyadh, Saudi Arabia</td></tr>
<tr><td>Contact: +966-548805579</td></tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
<td align="center">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody>
<tr>
<td style="background-color:#777777;color:#fff;padding-left:10px" align="left">
To:
</td>
</tr>
<tr>
<td align="left">
<table width="100%" style="float:right">
<tbody><tr><td>'.$customer_name.'</td></tr>
<tr><td>'.$customer_address.'</td></tr>
<tr><td>'.$customer_city_country.'</td></tr>
<tr><td>Contac: '.$customer_contact.'</td></tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td align="center">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody>
<tr>
<td style="background-color:#777777;color:#fff;padding-left:10px" align="left">
Billing Period From:
</td>
</tr>
<tr>
<td align="left">
'.date('Y-m-d', $date_from).'
</td>
</tr>
</tbody></table>
</td>
<td align="center">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody>
<tr>
<td style="background-color:#777777;color:#fff;padding-left:10px" align="left">
Billing Period To:
</td>
</tr>
<tr>
<td align="left">
'.$current_date.'
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td colspan="2" style="background-color:#777777;color:#fff" align="center">Your Billing Details</td>
</tr>
<tr>
<td align="center" colspan="2">
<table width="100%" style="border: 5px solid #dadada;">
<tbody><tr style="background-color:#777777;color:#fff">
<td>Destination</td>
<td>Total Calls</td>
<td align="center">Total Charges</td>
</tr>';
$sql99 = "SELECT SUM(total_sell_cost) as total_invoice_amount, COUNT(*) as total_calls, destination_number FROM cdr WHERE customer_id = '".$customer_id."' AND (hangup_cause = 'ALLOTTED_TIMEOUT' || hangup_cause = 'NORMAL_CLEARING') AND billsec > 0 AND created_time > '".sprintf("%.0f", $cdr_from)."' AND created_time <= '".sprintf("%.0f", $cdr_to)."' AND parent_id = '0' GROUP BY destination_number";
$query99 = $this->db->query($sql99);
$e_grand_total = 0;
if($query99->num_rows() > 0)
{
foreach($query99->result() as $row99)
{
$e_tot_inv_amt = $row99->total_invoice_amount;
$e_grand_total = $e_grand_total + $e_tot_inv_amt;
if($e_tot_inv_amt == '')
{
$e_tot_inv_amt = 0;
}
$e_total_calls_made = $row99->total_calls;
$e_destination = $row99->destination_number;
$tbl .= '<tr style="background-color:#ccc">
<td>'.$e_destination.'</td>
<td>'.$e_total_calls_made.'</td>
<td align="center">'.$e_tot_inv_amt.'</td>
</tr>';
}
}
else
{
$tbl .= '<tr style="background-color:#ccc">
<td>--</td>
<td>0</td>
<td align="center">0</td>
</tr>';
}
$tbl .= '<tr style="background-color:#ccc">
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr style="background-color:#ccc">
<td> </td>
<td align="right" style="font-weight:bold;color:#3172C6">Total</td>
<td style="font-weight:bold;color:#3172C6;text-align:center">'.$e_grand_total.'</td>
</tr>';
$tbl .= '</tbody></table>
</td>
</tr>';
/***********************************************************/
//now we have to show his childrens data group by destination
/***********************************************************/
$tbl .= '<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td colspan="2" style="background-color:#777777;color:#fff" align="center">Your Customers Billing Details</td>
</tr>
<tr>
<td align="center" colspan="2">
<table width="100%" style="border: 5px solid #dadada;">
<tbody><tr style="background-color:#777777;color:#fff">
<td>Destination</td>
<td>Total Calls</td>
<td align="center">Total Charges</td>
</tr>';
$sql100 = "SELECT SUM(total_reseller_sell_cost) as total_invoice_amount, COUNT(*) as total_calls, destination_number FROM cdr WHERE (parent_reseller_id = '".$customer_id."' || grand_parent_reseller_id = '".$customer_id."') AND (hangup_cause = 'ALLOTTED_TIMEOUT' || hangup_cause = 'NORMAL_CLEARING') AND billsec > 0 AND created_time > '".sprintf("%.0f", $cdr_from)."' AND created_time <= '".sprintf("%.0f", $cdr_to)."' AND parent_id = '0' GROUP BY destination_number";
$query100 = $this->db->query($sql100);
$child_e_grand_total = 0;
if($query100->num_rows() > 0)
{
foreach($query100->result() as $row100)
{
$child_e_tot_inv_amt = $row100->total_invoice_amount;
if($child_e_tot_inv_amt == '')
{
$child_e_tot_inv_amt = 0;
}
$child_e_grand_total = $child_e_grand_total + $child_e_tot_inv_amt;
$child_e_total_calls_made = $row100->total_calls;
$child_e_destination = $row100->destination_number;
$tbl .= '<tr style="background-color:#ccc">
<td>'.$child_e_destination.'</td>
<td>'.$child_e_total_calls_made.'</td>
<td align="center">'.$child_e_tot_inv_amt.'</td>
</tr>';
}
}
else
{
$tbl .= '<tr style="background-color:#ccc">
<td>--</td>
<td>0</td>
<td align="center">0</td>
</tr>';
}
$tbl .= '<tr style="background-color:#ccc">
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr style="background-color:#ccc">
<td> </td>
<td align="right" style="font-weight:bold;color:#3172C6">Total</td>
<td style="font-weight:bold;color:#3172C6;text-align:center">'.$child_e_grand_total.'</td>
</tr>';
$tbl .= '<tr>
<td height="30px" colspan="2"> </td>
</tr>';
$tbl .= '<tr style="background-color:#777777;color:#fff">
<td colspan="3" align="center">Grand Total</td>
</tr>';
$tbl .= '<tr style="background-color:#ccc">
<td> </td>
<td align="right" style="font-weight:bold;">Tax</td>
<td style="font-weight:bold;text-align:center;">N/A</td>
</tr>
<tr style="background-color:#ccc">
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr style="background-color:#ccc">
<td> </td>
<td align="right" style="font-weight:bold;">Other</td>
<td style="font-weight:bold;text-align:center;">N/A</td>
</tr>
<tr style="background-color:#ccc">
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr style="background-color:#ccc">
<td> </td>
<td align="right" style="font-weight:bold;color:#3172C6">Grand Total</td>
<td style="font-weight:bold;color:#3172C6;text-align:center">'.$grand_reseller_inv_amt.'</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>';
$terms = settings_any_cell('invoice_terms', customer_any_cell($customer_id, 'parent_id'));
if($terms != '')
{
$tbl .='<tr>
<td style="text-align: justify; font-style: italic; color: rgb(136, 136, 136); padding: 55px;" colspan="2">
'.$terms.'
</td>
</tr>';
}
$tbl .='</tbody></table>';
$obj->writeHTML($tbl, true, false, false, false, '');
//Close and output PDF document
$obj->Output('media/invoices/'.$invoice_number.'.pdf', 'F');
//create cdr pdf
$objcdr = new $this->pdf;
// set document information
$objcdr->SetSubject('Invoice CDR');
$objcdr->SetKeywords('Digital Linx, Invoice, CDR');
// add a page
$objcdr->AddPage();
$objcdr->SetFont('helvetica', '', 6);
$sql6 = "SELECT * FROM cdr WHERE customer_id = '".$customer_id."' AND (hangup_cause = 'ALLOTTED_TIMEOUT' || hangup_cause = 'NORMAL_CLEARING') AND billsec > 0 AND created_time > '".sprintf("%.0f", $cdr_from)."' AND created_time <= '".sprintf("%.0f", $cdr_to)."' AND parent_id = '0' ";
$query6 = $this->db->query($sql6);
$tbl_cdr = '<table width="100%" cellspacing="0" cellpadding="0" border="0" style="margin:0px;margin-left:auto;margin-right:auto;padding:5px">
<tbody>
<tr>
<td align="center" colspan="2">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody><tr>
<td align="right" style="font-weight:bold;color:red" colspan="2">Invoice # '.$invoice_number.'</td>
</tr>
<tr>
<td align="right" style="font-weight:bold;" colspan="2">Date: '.$current_date.'</td>
</tr>
<tr>
<td align="right" style="font-weight:bold;" colspan="2">Due Date: '.date('Y-m-d H:i:s', $due_date).'</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
<tr>
<td align="center">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody>
<tr>
<td style="background-color:#777777;color:#fff;padding-left:10px" align="left">
Billing Period From:
</td>
</tr>
<tr>
<td align="left">
'.date('Y-m-d', $date_from).'
</td>
</tr>
</tbody></table>
</td>
<td align="center">
<table width="100%" style="background-color:#dadada;padding:5px;border:5px solid #cccccc;">
<tbody>
<tr>
<td style="background-color:#777777;color:#fff;padding-left:10px" align="left">
Billing Period To:
</td>
</tr>
<tr>
<td align="left">
'.$current_date.'
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="30px" colspan="2"> </td>
</tr>
</tbody></table>';
$tbl_cdr .= '<table cellspacing="0" cellpadding="1" border="1" width="100%">';
$tbl_cdr .= '<tr style="background-color:grey; color:#ffffff;">
<td height="20" align="center" colspan="4">Your CDR Details</td>
</tr>';
$tbl_cdr .= '<tr style="background-color:grey; color:#ffffff;">
<td height="20" align="center">Date/Time</td>
<td align="center">Destination</td>
<td align="center">Bill Duration</td>
<td align="center">Total Charges</td>
</tr>';
if($query6->num_rows() > 0)
{
foreach ($query6->result() as $row6)
{
$tbl_cdr .= '<tr>
<td align="center" height="30">'.date("Y-m-d H:i:s", $row6->created_time/1000000).'</td>
<td align="center">'.$row6->destination_number.'</td>
<td align="center">'.$row6->billsec.'</td>
<td align="center">'.$row6->total_sell_cost.'</td></tr>';
}
}
else
{
$tbl_cdr .= '<tr><td colspan="4" style="color:red;" align="center">No Calls Made During This Period</td></tr>';
}
$tbl_cdr .= '<tr style="background-color:grey; color:#ffffff;">
<td height="20" align="center" colspan="4">Your Customers CDR Details</td>
</tr>';
$sql7 = "SELECT * FROM cdr WHERE (parent_reseller_id = '".$customer_id."' || grand_parent_reseller_id = '".$customer_id."') AND (hangup_cause = 'ALLOTTED_TIMEOUT' || hangup_cause = 'NORMAL_CLEARING') AND billsec > 0 AND created_time > '".sprintf("%.0f", $cdr_from)."' AND created_time <= '".sprintf("%.0f", $cdr_to)."' AND parent_id = '0' ";
$query7 = $this->db->query($sql7);
if($query7->num_rows() > 0)
{
foreach ($query7->result() as $row7)
{
$tbl_cdr .= '<tr>
<td align="center" height="30">'.date("Y-m-d H:i:s", $row7->created_time/1000000).'</td>
<td align="center">'.$row7->destination_number.'</td>
<td align="center">'.$row7->billsec.'</td>
<td align="center">'.$row7->total_reseller_sell_cost.'</td></tr>';
}
}
else
{
$tbl_cdr .= '<tr><td colspan="4" style="color:red;" align="center">No Calls Made During This Period</td></tr>';
}
$tbl_cdr .= '</table>';
$objcdr->writeHTML($tbl_cdr, true, false, false, false, '');
//Close and output PDF document
$objcdr->Output('media/invoices/'.$invoice_number.'_cdr.pdf', 'F');
//time to send email to the customer
if($customer_email != '')
{
if($customer_send_cdr == 0) //dont attach cdr
{
$this->load->library('email');
$this->email->clear(TRUE);
$this->email->from('*****@*****.**', 'Digital Linx');
$this->email->to($customer_email);
//$this->email->cc('*****@*****.**');
$this->email->subject('Invoice -- (Dated: '.$current_date.')');
$this->email->message('Please see the attachment with this email to view your invoice:<br/><br/>
<b>Billing Period From: '.date('Y-m-d', $date_from).'</b><br/>
<b>Billing Period To: '.$current_date.'</b><br/>
<br/><br/>
Thanks & Regards,<br/>
Digital Linx,
');
$this->email->attach('media/invoices/'.$invoice_number.'.pdf');
$this->email->send();
}
else
{
$this->load->library('email');
$this->email->clear(TRUE);
$this->email->from('*****@*****.**', 'Digital Linx');
$this->email->to($customer_email);
//$this->email->cc('*****@*****.**');
$this->email->subject('Invoice -- (Dated: '.$current_date.')');
$this->email->message('Please see the attachment with this email to view your invoice:<br/><br/>
<b>Billing Period From: '.date('Y-m-d', $date_from).'</b><br/>
<b>Billing Period To: '.$current_date.'</b><br/>
<br/><br/>
Thanks & Regards,<br/>
Digital Linx,
');
$this->email->attach('media/invoices/'.$invoice_number.'.pdf');
$this->email->attach('media/invoices/'.$invoice_number.'_cdr.pdf');
$this->email->send();
}
}
}
}
}