function view($id = FALSE)
{
$this->view_data['submenu'] = array($this->lang->line('application_back') => 'subscriptions');
$this->view_data['subscription'] = Subscription::find($id);
$this->view_data['items'] = SubscriptionHasItem::find('all', array('conditions' => array('subscription_id=?', $id)));
if ($this->view_data['subscription']->company_id != $this->client->company->id) {
redirect('csubscriptions');
}
$datediff = strtotime($this->view_data['subscription']->end_date) - strtotime($this->view_data['subscription']->issue_date);
$timespan = floor($datediff / (60 * 60 * 24));
switch ($this->view_data['subscription']->frequency) {
case '+7 day':
$this->view_data['run_time'] = round($timespan / 7);
$this->view_data['p3'] = "1";
$this->view_data['t3'] = "W";
break;
case '+14 day':
$this->view_data['run_time'] = round($timespan / 14);
$this->view_data['p3'] = "2";
$this->view_data['t3'] = "W";
break;
case '+1 month':
$this->view_data['run_time'] = round($timespan / 30);
$this->view_data['p3'] = "1";
$this->view_data['t3'] = "M";
break;
case '+3 month':
$this->view_data['run_time'] = round($timespan / 90);
$this->view_data['p3'] = "3";
$this->view_data['t3'] = "M";
break;
case '+6 month':
$this->view_data['run_time'] = round($timespan / 182);
$this->view_data['p3'] = "6";
$this->view_data['t3'] = "M";
break;
case '+1 year':
$this->view_data['run_time'] = round($timespan / 365);
$this->view_data['p3'] = "1";
$this->view_data['t3'] = "Y";
break;
}
$this->content_view = 'subscriptions/client_views/view';
}
function index()
{
$this->theme_view = 'blank';
$this->load->helper(array('dompdf', 'file'));
$timestamp = time();
$core_settings = Setting::first();
$date = date("Y-m-d");
if ($core_settings->cronjob == "1" && time() > $core_settings->last_cronjob + 300) {
$core_settings->last_cronjob = time();
$core_settings->save();
$this->load->database();
//Check Subscriptions
$sql = 'SELECT * FROM subscriptions WHERE status != "Inactive" AND end_date > "' . $date . '" AND "' . $date . '" >= next_payment ORDER BY next_payment';
$res = $this->db->query($sql);
$res = $res->result();
foreach ($res as $key2 => $value2) {
$eventline = 'New invoice created for subscription <a href="' . base_url() . 'subscriptions/view/' . $value2->id . '">#' . $value2->reference . '</a>';
$subscription = Subscription::find($value2->id);
$invoice = Invoice::last();
$invoice_reference = Setting::first();
if ($subscription) {
$_POST['subscription_id'] = $subscription->id;
$_POST['company_id'] = $subscription->company_id;
if ($subscription->subscribed != 0) {
$_POST['status'] = "Paid";
} else {
$_POST['status'] = "Open";
}
$_POST['currency'] = $subscription->currency;
$_POST['issue_date'] = $subscription->next_payment;
$_POST['due_date'] = date('Y-m-d', strtotime('+3 day', strtotime($subscription->next_payment)));
$_POST['currency'] = $subscription->currency;
$_POST['terms'] = $subscription->terms;
$_POST['discount'] = $subscription->discount;
$_POST['reference'] = $invoice_reference->invoice_reference;
$invoice = Invoice::create($_POST);
$invoiceid = Invoice::last();
$items = SubscriptionHasItem::find('all', array('conditions' => array('subscription_id=?', $value2->id)));
foreach ($items as $value) {
$itemvalues = array('invoice_id' => $invoiceid->id, 'item_id' => $value->item_id, 'amount' => $value->amount, 'description' => $value->description, 'value' => $value->value, 'name' => $value->name, 'type' => $value->type);
InvoiceHasItem::create($itemvalues);
}
$invoice_reference->update_attributes(array('invoice_reference' => $invoice_reference->invoice_reference + 1));
if ($invoice) {
$subscription->next_payment = date('Y-m-d', strtotime($subscription->frequency, strtotime($subscription->next_payment)));
$subscription->save();
//Send Invoice to Client via email
$this->load->library('parser');
$data["invoice"] = Invoice::find($invoiceid->id);
$data['items'] = InvoiceHasItem::find('all', array('conditions' => array('invoice_id=?', $invoiceid->id)));
$data["core_settings"] = Setting::first();
// Generate PDF
$html = $this->load->view($data["core_settings"]->template . '/' . 'invoices/preview', $data, true);
$filename = $this->lang->line('application_invoice') . '_' . $data["invoice"]->reference;
pdf_create($html, $filename, FALSE);
//email
$this->email->from($data["core_settings"]->email, $data["core_settings"]->company);
$this->email->to($data["invoice"]->company->client->email);
$this->email->subject($data["core_settings"]->invoice_mail_subject);
$this->email->attach("files/temp/" . $filename . ".pdf");
$due_date = date($data["core_settings"]->date_format, human_to_unix($data["invoice"]->due_date . ' 00:00:00'));
//Set parse values
$parse_data = array('client_contact' => $data["invoice"]->company->client->firstname . ' ' . $data["invoice"]->company->client->lastname, 'due_date' => $due_date, 'invoice_id' => $data["invoice"]->reference, 'client_link' => $data["core_settings"]->domain, 'company' => $data["core_settings"]->company, 'logo' => '<img src="' . base_url() . '' . $data["core_settings"]->logo . '" alt="' . $data["core_settings"]->company . '"/>', 'invoice_logo' => '<img src="' . base_url() . '' . $data["core_settings"]->invoice_logo . '" alt="' . $data["core_settings"]->company . '"/>');
$email_invoice = read_file('./application/views/' . $data["core_settings"]->template . '/templates/email_invoice.html');
$message = $this->parser->parse_string($email_invoice, $parse_data);
$this->email->message($message);
if ($this->email->send()) {
$data["invoice"]->update_attributes(array('status' => 'Sent', 'sent_date' => date("Y-m-d")));
}
log_message('error', $eventline);
unlink("files/temp/" . $filename . ".pdf");
}
}
}
//Check Subscriptions end
// Auto Backup every 7 days
if ($core_settings->autobackup == "1" && time() > $core_settings->last_autobackup + 7 * 24 * 60 * 60) {
$this->load->dbutil();
$prefs = array('format' => 'zip', 'filename' => 'Database-auto-full-backup_' . date('Y-m-d_H-i'));
$backup =& $this->dbutil->backup($prefs);
if (!write_file('./files/backup/Database-auto-full-backup_' . date('Y-m-d_H-i') . '.zip', $backup)) {
log_message('error', "Error while creating auto database backup!");
} else {
$core_settings->last_autobackup = time();
$core_settings->save();
log_message('error', "Auto backup has been created.");
}
}
echo "Success";
}
}
function item_delete($id = FALSE, $subscription_id = FALSE)
{
$item = SubscriptionHasItem::find($id);
$item->delete();
$this->content_view = 'subscriptions/view';
if (!$item) {
$this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_delete_item_error'));
} else {
$this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_delete_item_success'));
}
redirect('subscriptions/view/' . $subscription_id);
}
