function __construct()
{
parent::__construct();
$this->load->library('uri');
$this->load->helper('file');
$segments = $this->uri->segment_array();
array_shift($segments);
$path = APPPATH . '../assets';
foreach ($segments as $segment) {
$path .= '/' . $segment;
}
if (realpath($path) !== false) {
$data = read_file($path);
if (php_sapi_name() == 'apache2handler' || php_sapi_name() == 'apache') {
$headers = apache_request_headers();
if (isset($headers['If-Modified-Since']) && !empty($headers['If-Modified-Since'])) {
header('Not Modified', true, 304);
exit;
}
}
header('Content-Type: ' . get_mime_by_extension(basename($path)));
header('Cache-Control: max-age=3600, must-revalidate');
header('Last-Modified: ' . standard_date('DATE_COOKIE', filemtime($path)));
echo $data;
exit;
} else {
show_error('Asset does not exist in repository.', 404);
}
}
public function insert()
{
if (null === $this->time_recorded) {
$this->time_recorded = standard_date('DATE_ISO8601', time());
}
parent::insert();
}
function current_time($timezone, $daylight_saving)
{
$time = time();
$gmt = local_to_gmt($time);
$local = gmt_to_local($gmt, $timezone, $daylight_saving);
return standard_date("DATE_RFC822", $local);
}
/**
* Index Page for this controller.
*
* Maps to the following URL
* http://example.com/index.php/welcome
* - or -
* http://example.com/index.php/welcome/index
* - or -
* Since this controller is set as the default controller in
* config/routes.php, it's displayed at http://example.com/
*
* So any other public methods not prefixed with an underscore will
* map to /index.php/welcome/<method_name>
* @see http://codeigniter.com/user_guide/general/urls.html
*/
public function index($message = "")
{
$this->load->helper('form');
$this->load->helper('url');
$this->load->library('session');
if ($this->session->userdata('validated')) {
redirect('admin_view');
}
$form_elem = array('User Name' => array('input' => 'text', 'name' => 'UserName', 'id' => 'uid', 'type' => 'text', 'label' => 'User Name', 'class' => 'required'), 'Password' => array('input' => 'text', 'name' => 'Password', 'id' => 'pass', 'type' => 'password', 'label' => 'Password', 'class' => 'required'), 'Submit' => array('input' => 'submit', 'value' => 'Log In', 'type' => 'submit'));
$form_attr = array('id' => 'loginForm');
$this->load->helper('date');
$time = time();
$base_url = base_url();
date_default_timezone_set('Asia/Calcutta');
$institutename = 'IIIT-D';
$format = 'DATE_RFC822';
$datestring = standard_date($format, $time);
$data['date'] = $datestring;
$data['ins_name'] = $institutename;
$cssfiles[] = "styles.css";
$data['css'] = $cssfiles;
$data['form_elem'] = $form_elem;
$data['form_attr'] = $form_attr;
$data['msg'] = $message;
$data['scripts'] = array('jquery.js', 'jquery.infieldlabel.js', 'jquery.validate.js');
$this->load->view('admin_login', $data);
}
public function upload_profile_photo()
{
$date_dir = 'profile_photos/';
$config['upload_path'] = 'uploads/profile_photos/';
$config['allowed_types'] = 'gif|jpg|JPG|png';
$config['max_size'] = '5120';
$this->load->library('upload', $config);
$this->upload->display_errors('', '');
if ($this->upload->do_upload('photoimg')) {
$data = $this->upload->data();
$this->load->helper('date');
$format = 'DATE_RFC822';
$time = time();
$media['media_name'] = $data['file_name'];
$media['media_url'] = base_url() . 'uploads/profile_photos/' . $data['file_name'];
$media['create_time'] = standard_date($format, $time);
$media['status'] = 1;
create_square_thumb('./uploads/profile_photos/' . $data['file_name'], './uploads/profile_photos/thumb/');
$status['error'] = 0;
$status['name'] = $data['file_name'];
} else {
$errors = $this->upload->display_errors();
$errors = str_replace('<p>', '', $errors);
$errors = str_replace('</p>', '', $errors);
$status = array('error' => $errors, 'name' => '');
}
echo json_encode($status);
die;
}
function _build_feed( $posts = array() )
{
$this->data->rss->encoding = $this->config->item('charset');
$this->data->rss->feed_name = $this->settings->item('site_name');
$this->data->rss->feed_url = base_url();
$this->data->rss->page_description = sprintf($this->lang->line('blog_rss_posts_title'), $this->settings->item('site_name'));
$this->data->rss->page_language = 'en-gb';
$this->data->rss->creator_email = $this->settings->item('contact_email');
if(!empty($posts))
{
foreach($posts as $row)
{
//$row->created_on = human_to_unix($row->created_on);
$row->link = site_url('blog/' .date('Y/m', $row->created_on) .'/'. $row->slug);
$row->created_on = standard_date('DATE_RSS', $row->created_on);
$item = array(
//'author' => $row->author,
'title' => xml_convert($row->title),
'link' => $row->link,
'guid' => $row->link,
'description' => $row->intro,
'date' => $row->created_on
);
$this->data->rss->items[] = (object) $item;
}
}
}
function uploadImage($filename)
{
$config['upload_path'] = './assets/images/';
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = '1024';
$config['max_width'] = '';
$config['max_height'] = '';
$this->load->library('upload');
$this->upload->initialize($config);
$this->load->library('upload', $config);
if (!$this->upload->do_upload($filename)) {
$error = array('error' => $this->upload->display_errors());
return $this->upload->display_errors();
} else {
$data = $this->upload->data();
$this->load->helper('date');
$format = 'DATE_RFC822';
$time = time();
$media['media_name'] = $data['raw_name'] . '_thumb' . $data['file_ext'];
$media['media_url'] = base_url() . 'assets/images/thumb/' . $data['raw_name'] . '_thumb' . $data['file_ext'];
$media['create_time'] = standard_date($format, $time);
$media['created_by'] = $this->media_model->get_id_by_username($this->session->userdata('user_name'));
$media['status'] = 1;
$this->media_model->insert_media($media);
return $data;
}
return;
}
/**
* Registro de trazas al actualizar datos
*/
function after_update_log($value, $primary_key)
{
$format = 'DATE_RFC822';
$time = time();
$date = standard_date($format, $time);
$data = array('action' => 'update', 'user' => $this->session->userdata('username'), 'section' => 'Palabras Claves', 'fk_section' => $primary_key, 'date' => $date);
$this->db->insert('user_log', $data);
}
public function index()
{
$this->load->library('calendar');
$this->load->helper('date');
$datestring = "%Y-%m-%d";
$time = time();
echo mdate($datestring, $time) . "<br>";
echo mdate("%Y-%m-%d", time()) . "<br>";
$datestring = "Year: %Y Month: %m Day: %d - %h:%i %a";
$time = time();
echo mdate($datestring, $time) . "<br>";
$format = 'DATE_RFC822';
$time = time();
echo standard_date($format, $time) . "<br>";
$this->load->library('calendar');
echo $this->calendar->generate() . "<br>";
echo $this->calendar->generate(2006, 6) . "<br>";
$data = array(3 => 'http://01fes.com/news/article/2006/03/', 7 => 'http://01fes.com/news/article/2006/07/', 13 => 'http://01fes.com/news/article/2006/13/', 26 => 'http://01fes.com/news/article/2006/26/');
echo $this->calendar->generate(2006, 6, $data) . "<br>";
$prefs = array('show_next_prev' => TRUE, 'next_prev_url' => 'http://example.com/index.php/calendar/show/');
$this->load->library('calendar', $prefs);
echo $this->calendar->generate($this->uri->segment(3), $this->uri->segment(4)) . "<br>";
$prefs['template'] = '
{table_open}<table border="0" cellpadding="0" cellspacing="0">{/table_open}
{heading_row_start}<tr>{/heading_row_start}
{heading_previous_cell}<th><a href="{previous_url}"><<</a></th>{/heading_previous_cell}
{heading_title_cell}<th colspan="{colspan}">{heading}</th>{/heading_title_cell}
{heading_next_cell}<th><a href="{next_url}">>></a></th>{/heading_next_cell}
{heading_row_end}</tr>{/heading_row_end}
{week_row_start}<tr>{/week_row_start}
{week_day_cell}<td>{week_day}</td>{/week_day_cell}
{week_row_end}</tr>{/week_row_end}
{cal_row_start}<tr>{/cal_row_start}
{cal_cell_start}<td>{/cal_cell_start}
{cal_cell_content}<a href="{content}">{day}</a>{/cal_cell_content}
{cal_cell_content_today}<div class="highlight"><a href="{content}">{day}</a></div>{/cal_cell_content_today}
{cal_cell_no_content}{day}{/cal_cell_no_content}
{cal_cell_no_content_today}<div class="highlight">{day}</div>{/cal_cell_no_content_today}
{cal_cell_blank} {/cal_cell_blank}
{cal_cell_end}</td>{/cal_cell_end}
{cal_row_end}</tr>{/cal_row_end}
{table_close}</table>{/table_close}
';
$this->load->library('calendar', $prefs);
echo $this->calendar->generate();
}
function log($action)
{
$session_data = $this->session->userdata('logged_in');
$this->load->helper('date');
$format = 'DATE_RFC850';
$time = time();
$log = array('user_id' => $session_data['user_id'], 'action' => $action, 'time' => standard_date($format, $time));
$this->db->insert('logs', $log);
}
public function index()
{
$format = 'DATE_RFC822';
$time = now('America/Argentina/Buenos_Aires');
$data['fecha'] = standard_date($format, $time);
$data['ip_remota'] = $this->input->ip_address();
$txt = "\n" . $data['ip_remota'] . ";" . "acceso" . ";" . $data['fecha'] . ";" . $this->agente() . ";";
write_file('application/logs/accesos.txt', $txt, 'a+');
$this->load->view('welcome_message');
}
function new_comment()
{
$format = 'DATE_ATOM';
$time = time();
$data['name'] = $this->input->post('name');
$data['post_id'] = $this->input->post('post_id');
$post_id = $this->input->post('post_id');
$data['comment'] = $this->input->post('comment');
$data['posted_datetime'] = standard_date($format, $time);
$this->comments_model->new_comment($data);
echo "<h2 class='post'>" . $data['name'] . "</h2>";
echo "<p class='post'>" . $data['comment'] . "</p>";
}
function projectdetail($var = 'id', $id)
{
/* Database Initiation */
$q = $this->db->get_where('ch_project', array('project_id' => $id));
$row = $q->row();
$s = $this->db->get_where('ch_user', array('user_id' => $row->project_user_id));
$row_user = $s->row();
$r = $this->db->get_where('ch_projectreward', array('project_id' => $id));
$reward = $r->row();
/* Data Inititaion */
$time = $row->project_time;
$datetime = human_to_unix($time);
$data['project_until'] = standard_date('DATE_COOKIE', gmt_to_local($datetime, 'UP7', 'FALSE'));
$data['sidebar_amount_funding'] = $row->amount_funding;
$data['project_title'] = $row->project_name;
$data['project_author'] = $row_user->name;
$data['user_location'] = $row_user->location;
$data['user_bio'] = $row_user->bio;
$data['title'] = $row->project_name . ' by ' . $row_user->name;
$data['topmenu'] = $this->projectmodel->menu_top($var, $id);
$data['project_location'] = $row->project_location;
$data['user_avatar'] = $row_user->avatar;
for ($i = 1; $i < 6; $i++) {
$rew = "reward_{$i}";
$count = "count_{$i}";
$data["donate_{$i}"] = $reward->{$rew};
$data["count_{$i}"] = $reward->{$count};
}
switch ($var) {
case 'id':
$data['project_home'] = $row->project_home;
$data['project_video'] = $row->project_video;
$this->projectmodel->template($data, "chprojectdetail");
break;
case 'updates':
$data['project_updates'] = $this->projectmodel->project_updates($id);
$data['project_updates_form'] = $this->projectmodel->editor($id);
$this->projectmodel->template($data, "chprojectupdates");
break;
case 'comments':
$data['project_comments'] = $this->projectmodel->project_comments($id);
$this->projectmodel->template($data, "chprojectcomments");
break;
default:
$data['project_home'] = $row->project_home;
$this->projectmodel->template($data, "chprojectdetail");
break;
}
}
/**
* Index Page for this controller.
*
* Maps to the following URL
* http://example.com/index.php/welcome
* - or -
* http://example.com/index.php/welcome/index
* - or -
* Since this controller is set as the default controller in
* config/routes.php, it's displayed at http://example.com/
*
* So any other public methods not prefixed with an underscore will
* map to /index.php/welcome/<method_name>
* @see http://codeigniter.com/user_guide/general/urls.html
*/
public function index()
{
$this->load->helper('url');
$this->load->helper('date');
$time = time();
$base_url = base_url();
date_default_timezone_set('Asia/Calcutta');
$format = 'DATE_RFC822';
$datestring = standard_date($format, $time);
$data['date'] = $datestring;
$navigation_data['navTab'] = 'home';
$navigation_data['base_url'] = $base_url;
$cssfiles[] = "styles.css";
$data['css'] = $cssfiles;
$data['content_navigation'] = $this->load->view('navigation_bar', $navigation_data, true);
$this->load->view('error_page', $data);
}
function _build_feed($posts = array())
{
$this->data->rss->encoding = $this->config->item('charset');
$this->data->rss->feed_name = $this->settings->item('site_name');
$this->data->rss->feed_url = base_url();
$this->data->rss->page_description = 'News articles for ' . $this->settings->item('site_name');
$this->data->rss->page_language = 'en-gb';
$this->data->rss->creator_email = $this->settings->item('contact_email');
if (!empty($posts)) {
foreach ($posts as $row) {
//$row->created_on = human_to_unix($row->created_on);
$row->link = site_url('news/' . date('Y/m', $row->created_on) . '/' . $row->slug);
$row->created_on = standard_date('DATE_RSS', $row->created_on);
$item = array('title' => xml_convert($row->title), 'link' => $row->link, 'guid' => $row->link, 'description' => str_replace('/img/post_resources/', base_url() . 'img/post_resources/', $row->body), 'date' => $row->created_on);
$this->data->rss->items[] = (object) $item;
}
}
}
public function post()
{
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters("<p style='font-weight: bold; color:red;'>", '</p>');
$this->form_validation->set_rules('name', 'Name', 'required|min_length[2]');
$this->form_validation->set_rules('address', 'Address', 'required|min_length[2]');
$this->form_validation->set_rules('postal', 'Postal Code', 'required|callback_validate_postal');
$this->form_validation->set_rules('phone', 'Phone', 'required|callback_validate_phone');
$this->form_validation->set_rules('email', 'E-mail', 'valid_email');
$this->form_validation->set_rules('comment', 'Comment', 'required|min_length[2]');
// Load Google Maps
$this->load->library('googlemaps');
$config = array();
$marker = array();
$config['center'] = "21 Redwood Road, Brantford, ON";
$config['zoom'] = '16';
$marker['position'] = "21 Redwood Road, Brantford, ON";
$marker['infowindow_content'] = "SleepyMe Hotel";
$marker['animation'] = "DROP";
$this->googlemaps->add_marker($marker);
$this->googlemaps->initialize($config);
$TPL['map'] = $this->googlemaps->create_map();
if ($this->form_validation->run() == FALSE) {
// Validation error and show template
$TPL['validation'] = "The form contains errors: <br />";
$this->template->show('contact', 'Contact', $TPL);
} else {
// Validation success, send email, and show template
$TPL['validation'] = "The form has been successfully submitted";
// Load email library, set up message, and send it
$this->load->helper('date');
date_default_timezone_set('EST');
$this->email->from('*****@*****.**', 'SleepyMe_Form');
$this->email->to('*****@*****.**');
$this->email->cc('*****@*****.**');
$this->email->subject('Form Submission From SleepyMe Hotel');
$this->email->message('Date of submission: ' . standard_date('DATE_RFC1123', time()) . "\n" . 'Name: ' . $this->input->post('name') . "\n" . 'Address: ' . $this->input->post('address') . "\n" . 'Postal Code: ' . $this->input->post('postal') . "\n" . 'Phone: ' . $this->input->post('phone') . "\n" . 'E-mail: ' . $this->input->post('email') . "\n" . 'Comment: ' . $this->input->post('comment'));
if (!$this->email->send()) {
$TPL['validation'] = 'The form submission failed';
}
$this->template->show('contact', 'Contact', $TPL);
}
}
/**
* Index Page for this controller.
*
* Maps to the following URL
* http://example.com/index.php/welcome
* - or -
* http://example.com/index.php/welcome/index
* - or -
* Since this controller is set as the default controller in
* config/routes.php, it's displayed at http://example.com/
*
* So any other public methods not prefixed with an underscore will
* map to /index.php/welcome/<method_name>
* @see http://codeigniter.com/user_guide/general/urls.html
*/
public function index()
{
// Load the library
//$this->load->library('googlemaps');
// Initialize our map. Here you can also pass in additional parameters for customising the map (see below)
//$this->googlemaps->initialize();
// Create the map. This will return the Javascript to be included in our pages <head></head> section and the HTML code to be
// placed where we want the map to appear.
//$data['map'] = $this->googlemaps->create_map();
// Load our view, passing the map data that has just been created
//$this->load->view('maps_page', $data);
$this->load->helper('url');
$this->load->helper('date');
$time = time();
$base_url = base_url();
date_default_timezone_set('Asia/Calcutta');
$format = 'DATE_RFC822';
$datestring = standard_date($format, $time);
$data['date'] = $datestring;
$navigation_data['navTab'] = 'home';
$navigation_data['base_url'] = $base_url;
$cssfiles[] = "styles.css";
$data['css'] = $cssfiles;
$data['content_navigation'] = $this->load->view('navigation_bar', $navigation_data, true);
//$this->load->view('maps_page',$data);
// Load the library
$this->load->library('googlemaps');
$config['center'] = 'Delhi, India';
$config['zoom'] = '10';
$this->googlemaps->initialize($config);
$marker = array();
$marker['position'] = 'Indraprastha Institute of Information Technology, Delhi';
$marker['animation'] = 'DROP';
$marker['draggable'] = TRUE;
$this->googlemaps->add_marker($marker);
$data['map'] = $this->googlemaps->create_map();
$this->load->view('maps_page', $data);
}
echo xml_convert($content->title);
?>
</title>
<link><?php
echo base_url() . $content->title_url;
?>
</link>
<guid isPermaLink="true"><?php
echo $item_base_url . $content->content_id;
?>
</guid>
<description><![CDATA[<?php
echo $content->content;
?>
]]></description>
<author><?php
echo xml_convert($content->name);
?>
</author>
<pubdate><?php
echo standard_date('DATE_RSS', mysql_to_unix($content->created_at));
?>
</pubdate>
</item>
<?php
}
}
?>
</channel>
</rss>
/**
* RSS method
* @access public
* @param array $url_segments The URL segments
* @return void
*/
public function _rss($url_segments)
{
// Remove the .rss suffix
$url_segments += array(preg_replace('/.rss$/', '', array_pop($url_segments)));
// Fetch this page from the database via cache
$page = $this->cache->model('pages_m', 'get_by_path', array($url_segments));
// If page is missing or not live (and not an admin) show 404
if (empty($page) or $page->status == 'draft' and $this->user->group !== 'admin' or !$page->rss_enabled) {
// Will try the page then try 404 eventually
$this->_page('404');
return;
}
$children = $this->cache->model('pages_m', 'get_many_by', array(array('parent_id' => $page->id, 'status' => 'live')));
$data->rss->title = ($page->meta_title ? $page->meta_title : $page->title) . ' | ' . $this->settings->site_name;
$data->rss->description = $page->meta_description;
$data->rss->link = site_url($url_segments);
$data->rss->creator_email = $this->settings->contact_email;
if (!empty($children)) {
$this->load->helper(array('date', 'xml'));
foreach ($children as &$row) {
$path = $this->pages_m->get_path_by_id($row->id);
$row->link = site_url($path);
$row->created_on = standard_date('DATE_RSS', $row->created_on);
$item = array('title' => xml_convert($row->title), 'link' => $row->link, 'guid' => $row->link, 'description' => $row->meta_description, 'date' => $row->created_on);
$data->rss->items[] = (object) $item;
}
}
$this->load->view('rss', $data);
}
function processForgotPassword()
{
/*@author wildan
edited by : syifa
*/
$this->load->model('memberManager');
$this->load->helper('security');
$this->load->helper('text');
$this->load->helper('cookie');
$data = array('email' => $this->input->post('email'));
$hasil['query'] = $this->memberManager->checkForgotPassword($data);
if ($hasil['query'] == false) {
/*-------editan wildan-------------
$this->user = $this->facebook->getUser();
if($this->user)
{
$data['user_profile'] = $this->facebook->api('/me/');
$first_name = $data['user_profile']['first_name'];
$foto_facebook = "https://graph.facebook.com/".$data['user_profile']['id']."/picture";
if(get_cookie('username')!=null)
{
$this->load->view('header',$data);
$this->load->view('ForgotPassFailUI');
$this->load->view('footer');
}
else
{
setcookie("username_facebook", $data['user_profile']['first_name'], time()+3600, '/');
setcookie("username",$data['user_profile']['id'], time()+3600, '/');
setcookie("photo_facebook",$foto_facebook,time()+3600, '/');
setcookie("is_admin",0,time()+3600,'/');
header('Location: '.base_url('successLoginFB'));
}
}
else
{
$data['login_url'] = $this->facebook->getLoginUrl();
$this->load->view('header',$data);
$this->load->view('ForgotPassFailUI');
$this->load->view('footer');
}
-------end of editan wildan*/
$this->load->view('header');
$this->load->view('ForgotPassFailUI');
$this->load->view('footer');
} else {
//----------------set time---------------
$this->load->helper('date');
date_default_timezone_set('Asia/Jakarta');
$format = 'DATE_RFC850';
$time = time();
$date = standard_date($format, $time);
$arrayDate = explode(" ", $date);
//---------------end of set time---------------------
//-----------------set email--------------------------
$config = array('protocol' => 'smtp', 'smtp_host' => 'mail.jaktrip.net', 'smtp_port' => 587, 'smtp_user' => '*****@*****.**', 'smtp_pass' => 'adminjaktripa10', 'mailtype' => 'html', 'charset' => 'iso-8859-1', 'wordwrap' => TRUE);
//------------set password-----------
$length = 8;
$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
$password = substr(str_shuffle($chars), 0, $length);
$data['new_password'] = do_hash($password, 'md5');
//------------end of set password-------------
$this->memberManager->resetPassword($data);
$jam = intval($arrayDate[2]);
$message = "";
if ($jam >= 18 || $jam < 6) {
$message = $message . "Good evening,";
} else {
if ($jam >= 11) {
$message = $message . "Good afternoon,";
} else {
$message = $message . "Good morning,";
}
}
$this->load->library('email', $config);
$this->email->set_newline("\r\n");
$message = $message . "\n\n Your password has been reset to " . $password . ".";
$message = $message . "\n Please <a href='http://jaktrip.net/JAKtrip/home#openLogin'>login</a> and change your password to easily remember your password.";
$message = $message . "\nThank you. \n\n\nSincerely, \n\nJAKtrip.net";
$message = nl2br($message);
$this->email->from('*****@*****.**');
// change it to yours
$this->email->to($data['email']);
// change it to yours
$this->email->subject('[JAKtrip.net] Your New Password');
$this->email->message($message);
if ($this->email->send()) {
/*--------editan wildan--------------
$this->user = $this->facebook->getUser();
if($this->user)
{
$data['user_profile'] = $this->facebook->api('/me/');
$first_name = $data['user_profile']['first_name'];
$foto_facebook = "https://graph.facebook.com/".$data['user_profile']['id']."/picture";
if(get_cookie('username')!=null)
{
$this->load->view('header',$data);
$this->load->view('ForgotPassSuccessUI');
$this->load->view('footer');
}
else
{
setcookie("username_facebook", $data['user_profile']['first_name'], time()+3600, '/');
setcookie("username",$data['user_profile']['id'], time()+3600, '/');
setcookie("photo_facebook",$foto_facebook,time()+3600, '/');
setcookie("is_admin",0,time()+3600,'/');
header('Location: '.base_url('successLoginFB'));
}
}
else
{
$this->session->set_flashdata('form', array('message' => '<center><b>You successfully reset your password.</b><br>Please check your e-mail.</center>'));
redirect('home');
}
-----------end of editan wildan*/
$this->session->set_flashdata('form', array('message' => '<center><b>You successfully reset your password.</b><br>Please check your e-mail.</center>'));
redirect('home');
} else {
show_error($this->email->print_debugger());
}
//-----------------end of set email-------------------
}
}
public function uploadsearchbgfile()
{
$config['upload_path'] = './uploads/banner/';
$config['allowed_types'] = 'gif|jpg|JPG|png';
$config['max_size'] = '5120';
$config['min_width'] = '1024';
$config['min_height'] = '600';
$this->load->library('dbcupload', $config);
$this->dbcupload->display_errors('', '');
if ($this->dbcupload->do_upload('photoimg')) {
$data = $this->dbcupload->data();
$this->load->helper('date');
$format = 'DATE_RFC822';
$time = time();
$media['media_name'] = $data['file_name'];
$media['media_url'] = base_url() . 'uploads/banner/' . $data['file_name'];
$media['create_time'] = standard_date($format, $time);
$media['status'] = 1;
$status['error'] = 0;
$status['name'] = $data['file_name'];
} else {
$errors = $this->dbcupload->display_errors();
$errors = str_replace('<p>', '', $errors);
$errors = str_replace('</p>', '', $errors);
$status = array('error' => $errors, 'name' => '');
}
echo json_encode($status);
die;
}
<name><?php
echo $post->author_name;
?>
</name>
</author>
<content type="html" xml:lang="<?php
echo $this->fuel_blog->language(TRUE);
?>
" xml:base="<?php
echo $link;
?>
/article">
<![CDATA[<?php
echo strip_javascript($post->excerpt_formatted);
?>
]]>
</content>
<updated><?php
echo standard_date('DATE_ATOM', strtotime($post->last_modified));
?>
</updated>
</entry>
<?php
}
?>
<?php
}
?>
</feed>
/**
* Formats the date so things don't get screwed up
* by blank entries in the database
*
* @access private
* @param string
* @param string
* @param [bool]
* @return string
*/
private function format_date($format, $unix_date, $standard = false)
{
if (!$unix_date) {
return null;
}
if (!$standard) {
return date($format, $unix_date);
} else {
return standard_date($format, $unix_date);
}
}
echo xml_convert($post['title']);
?>
</title>
<link><?php
echo base_url() . 'blog/post/' . date('Y', strtotime($post['date_posted'])) . '/' . date('m', strtotime($post['date_posted'])) . '/' . date('d', strtotime($post['date_posted'])) . '/' . $post['url_title'] . '/';
?>
</link>
<guid><?php
echo base_url() . 'blog/post/' . date('Y', strtotime($post['date_posted'])) . '/' . date('m', strtotime($post['date_posted'])) . '/' . date('d', strtotime($post['date_posted'])) . '/' . $post['url_title'] . '/';
?>
</guid>
<description><![CDATA[
<?php
echo $post['excerpt'];
?>
]]>
</description>
<pubDate><?php
echo standard_date('DATE_RSS', strtotime($post['date_posted']));
?>
</pubDate>
</item>
<?php
}
?>
<?php
}
?>
</channel>
</rss>
public function addcategory()
{
$this->form_validation->set_rules('title', 'Title', 'required');
$this->form_validation->set_rules('parent', 'Parent', 'required');
if ($this->form_validation->run() == FALSE) {
$this->newcategory();
} else {
$this->load->helper('date');
$format = 'DATE_RFC822';
$time = time();
$data = array();
$data['title'] = $this->input->post('title');
$data['parent'] = $this->input->post('parent');
$data['create_time'] = standard_date($format, $time);
$data['created_by'] = get_id_by_username($this->session->userdata('user_name'));
$data['status'] = 1;
if (constant("ENVIRONMENT") == 'demo') {
$this->session->set_flashdata('msg', '<div class="alert alert-success">Data updated.[NOT AVAILABLE ON DEMO]</div>');
} else {
$this->category_model->insert_category($data);
$this->session->set_flashdata('msg', '<div class="alert alert-success">Data inserted</div>');
}
redirect(site_url('admin/category/newcategory'));
}
}
function report()
{
//load our new PHPExcel library
$this->load->library('excel');
$this->load->library('Sanitizer');
$EmployeeMeta = new Sanitizer($EmpId);
$employee = $this->uri->segment(3);
$from = date('Y-m-d', strtotime($this->input->post('FromDate')));
$to = date('Y-m-d', strtotime($this->input->post('endDate')));
$this->db->select('*');
$this->db->from('ecc_calls_call');
//$this->db->join('ecc_employees_emp', 'idemp_call = id_emp', 'inner');
$this->db->join('ecc_company_co', 'idco_call = id_co', 'inner');
$this->db->where('status_call', 'active');
$this->db->where('callStatus_call', 'done');
$this->db->where('idemp_call', $employee);
$this->db->where('inDate_call >=', $from);
$this->db->where('inDate_call <=', $to);
$getCalls = $this->db->get();
$cell = 9;
$meta = $EmployeeMeta->EmployeeMeta($employee);
$callNumber = 1;
foreach ($getCalls->result() as $row) {
$cell = $cell + 4;
$this->db->select('*');
$this->db->from('ecc_companyCategory_cocat');
$getCat = $this->db->get();
$this->db->select('*');
$this->db->from('ecc_feedback_feed');
$this->db->where('idcall_feed', $row->id_call);
$getFeed = $this->db->get();
//call meta
$this->db->SELECT('*');
$this->db->FROM('ecc_call_cmeta');
$this->db->WHERE('idcall_cmeta', $row->id_call);
$metaCall = $this->db->GET();
$thisMetaCall = array();
foreach ($metaCall->result() as $row2) {
$thisMetaCall[$row2->metaKey_cmeta] = $row2->metaValue_cmeta;
}
//meta
$MetaCall = array('reason' => $thisMetaCall['reason'], 'contact' => $thisMetaCall['contact']);
//call meta
$this->db->SELECT('*');
$this->db->FROM('ecc_call_cmeta');
$this->db->WHERE('idcall_cmeta', $row->id_call);
$this->db->WHERE('metaKey_cmeta', 'contact');
$metaContact = $this->db->GET();
$name = $meta['first_name'] . " " . $meta['last_name'];
$position = $meta['position'];
$totalCalls = $getCalls->num_rows();
$company = $row->name_co;
$date = $row->date_call;
$doneDate = $row->inDate_call;
$objective = $MetaCall['reason'];
//$feedback = $MetaCall['feedback'];
$status = $row->callStatus_call;
//$logo = imagecreatefromjpeg(base_url() . "assets/bofficr/images/ecc_report_logo.png");
$author = $this->name;
//date
$format = 'DATE_RFC1036';
$time = time();
$creationDate = standard_date($format, $time);
//activate worksheet number 1
$this->excel->setActiveSheetIndex(0);
//name the worksheet
$this->excel->getActiveSheet()->setTitle($name . ' Calls Report');
$this->excel->getActiveSheet()->setCellValue('A1', $name);
$this->excel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20);
$this->excel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('A1:G1');
$this->excel->getActiveSheet()->setCellValue('A2', $position);
$this->excel->getActiveSheet()->getStyle('A2')->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('A2:G2');
$this->excel->getActiveSheet()->setCellValue('A4', 'Total Calls');
$this->excel->getActiveSheet()->getStyle('A4')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('A4')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('A4:C4');
$this->excel->getActiveSheet()->setCellValue('E4', 'From');
$this->excel->getActiveSheet()->getStyle('E4')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('E4')->getFont()->setBold(true);
$this->excel->getActiveSheet()->setCellValue('H4', 'To');
$this->excel->getActiveSheet()->getStyle('H4')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('H4')->getFont()->setBold(true);
//$this->excel->getActiveSheet()->setCellValue('A5', 'Companies');
$this->excel->getActiveSheet()->getStyle('A5')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('A5')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('A5:C5');
$this->excel->getActiveSheet()->setCellValue('A7', 'Company to call');
$this->excel->getActiveSheet()->getStyle('A7')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('A7')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('A7:D11');
$this->excel->getActiveSheet()->setCellValue('E7', 'Created in');
$this->excel->getActiveSheet()->getStyle('E7')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('E7')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('E7:G11');
$this->excel->getActiveSheet()->setCellValue('H7', 'Done in date');
$this->excel->getActiveSheet()->getStyle('H7')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('H7')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('H7:I11');
$this->excel->getActiveSheet()->setCellValue('J7', 'Call objective');
$this->excel->getActiveSheet()->getStyle('J7')->getFont()->setSize(16);
$this->excel->getActiveSheet()->getStyle('J7')->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('J7:K11');
$this->excel->getActiveSheet()->setCellValue('D4', $totalCalls);
$this->excel->getActiveSheet()->getStyle('D4')->getFont()->setSize(12);
//$this->excel->getActiveSheet()->mergeCells('C4:D4');
$this->excel->getActiveSheet()->setCellValue('F4', $from);
$this->excel->getActiveSheet()->getStyle('F4')->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('F4:G4');
$this->excel->getActiveSheet()->setCellValue('I4', $to);
$this->excel->getActiveSheet()->getStyle('I4')->getFont()->setSize(12);
$this->excel->getActiveSheet()->getStyle('A7:V11')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FF555555');
$this->excel->getActiveSheet()->getStyle('A7:V11')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$this->excel->getActiveSheet()->getStyle('A7:V11')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$this->excel->getActiveSheet()->getStyle('A7:V8')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->getStyle('A7:V11')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
/*
$this->excel->getActiveSheet()->setCellValue('B6', '0');
$this->excel->getActiveSheet()->setCellValue('D6', '0');
$this->excel->getActiveSheet()->setCellValue('F6', '0');
$this->excel->getActiveSheet()->setCellValue('H6', '0');
$this->excel->getActiveSheet()->setCellValue('J6', '0');
$catCell = 1;
foreach($getCat->result() as $rowCat){
if($catCell == 1){
$this->excel->getActiveSheet()->setCellValue('A6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('A6')->getFont()->setSize(12);
$catCell = $catCell+1;
}elseif($catCell == 2){
$cat{$catCell} = 1;
$this->excel->getActiveSheet()->setCellValue('C6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('C6')->getFont()->setSize(12);
$catCell = $catCell+1;
}elseif($catCell == 3){
$cat{$catCell} = 1;
$this->excel->getActiveSheet()->setCellValue('E6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('E6')->getFont()->setSize(12);
$catCell = $catCell+1;
}elseif($catCell == 4){
$cat{$catCell} = 1;
$this->excel->getActiveSheet()->setCellValue('G6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('G6')->getFont()->setSize(12);
$catCell = $catCell+1;
}elseif($catCell == 5){
$cat{$catCell} = 1;
$this->excel->getActiveSheet()->setCellValue('I6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('I6')->getFont()->setSize(12);
$catCell = $catCell+1;
}elseif($catCell == 6){
$cat{$catCell} = 1;
$this->excel->getActiveSheet()->setCellValue('K6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('K6')->getFont()->setSize(12);
$catCell = $catCell+1;
}elseif($catCell == 7){
$this->excel->getActiveSheet()->setCellValue('M6', $rowCat->name_cocat);
$this->excel->getActiveSheet()->getStyle('M6')->getFont()->setSize(12);
$catCell = $catCell+1;
}
};
$callCat = 1;
$callCat2 = 1;
if($row->idcocat_co == 1){
$this->excel->getActiveSheet()->setCellValue('B6', $callCat);
$callCat++;
}elseif($row->idcocat_co == 2){
$this->excel->getActiveSheet()->setCellValue('D6', +1);
}elseif($row->idcocat_co == 3){
$this->excel->getActiveSheet()->setCellValue('F6', +1);
}elseif($row->idcocat_co == 4){
$this->excel->getActiveSheet()->setCellValue('H6', +1);
$callCat2++;
};
*/
//echo $row->idcocat_co ."<br />";
$this->excel->getActiveSheet()->getStyle('A' . $cell . ':V' . $cell)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFdcdcdc');
$this->excel->getActiveSheet()->getStyle('A' . $cell . ':V' . $cell)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$this->excel->getActiveSheet()->setCellValue('A' . $cell, $callNumber);
$this->excel->getActiveSheet()->getStyle('A' . $cell)->getFont()->setSize(20);
$this->excel->getActiveSheet()->getStyle('A' . $cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$this->excel->getActiveSheet()->getStyle('A' . $cell)->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('B' . ($cell + 1))->getFont()->setBold(true);
$this->excel->getActiveSheet()->getColumnDimension('A')->setWidth(5);
$this->excel->getActiveSheet()->setCellValue('B' . $cell, $company);
$this->excel->getActiveSheet()->getStyle('B' . $cell)->getFont()->setSize(14);
$this->excel->getActiveSheet()->mergeCells('B' . $cell . ':D' . $cell);
$this->excel->getActiveSheet()->getStyle('B' . $cell)->getFont()->setBold(true);
$this->excel->getActiveSheet()->getRowDimension($cell)->setRowHeight(40);
$this->excel->getActiveSheet()->getStyle('A' . $cell . ':V' . $cell)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->setCellValue('E' . $cell, $date);
$this->excel->getActiveSheet()->getStyle('E' . $cell)->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('E' . $cell . ':F' . $cell);
$this->excel->getActiveSheet()->setCellValue('H' . $cell, $doneDate);
$this->excel->getActiveSheet()->getStyle('H' . $cell)->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('H' . $cell . ':I' . $cell);
$this->excel->getActiveSheet()->setCellValue('J' . $cell, $objective);
$this->excel->getActiveSheet()->getStyle('J' . $cell)->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('J' . $cell . ':V' . $cell);
$this->excel->getActiveSheet()->setCellValue('B' . ($cell + 1), 'Feedbacks');
$this->excel->getActiveSheet()->getStyle('B' . ($cell + 1))->getFont()->setSize(14);
$this->excel->getActiveSheet()->getStyle('B' . ($cell + 1))->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('B' . ($cell + 1) . ':V' . ($cell + 1));
$this->excel->getActiveSheet()->getRowDimension($cell + 1)->setRowHeight(30);
$this->excel->getActiveSheet()->getStyle('B' . ($cell + 1) . ':V' . ($cell + 1))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->getStyle('B' . ($cell + 1) . ':V' . ($cell + 1))->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFf0f0f0');
$this->excel->getActiveSheet()->getStyle('B' . ($cell + 1) . ':V' . ($cell + 1))->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$this->excel->getActiveSheet()->mergeCells('J7:V8');
$this->excel->getActiveSheet()->mergeCells('C7:D7');
$this->excel->getActiveSheet()->mergeCells('C8:D8');
$this->excel->getActiveSheet()->mergeCells('A1:V1');
$this->excel->getActiveSheet()->mergeCells('A2:V2');
$this->excel->getActiveSheet()->mergeCells('A3:V3');
$this->excel->getActiveSheet()->mergeCells('A6:V6');
//$this->excel->getActiveSheet()->mergeCells('A9:V11');
$cellFeed = $cell + 2;
if ($getFeed->num_rows() == 0) {
$this->excel->getActiveSheet()->setCellValue('B' . $cellFeed, 'No Feedbacks avalable');
$this->excel->getActiveSheet()->mergeCells('B' . $cellFeed . ':V' . $cellFeed);
$this->excel->getActiveSheet()->getRowDimension($cellFeed)->setRowHeight(30);
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed . ':V' . $cellFeed)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed . ':V' . $cellFeed)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFf0f0f0');
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed . ':V' . $cellFeed)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
} else {
foreach ($getFeed->result() as $rowFeed) {
$metaFeed = $EmployeeMeta->EmployeeMeta($rowFeed->idemp_feed);
$this->excel->getActiveSheet()->getRowDimension($cellFeed)->setRowHeight(25);
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed . ':V' . $cellFeed)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->setCellValue('B' . $cellFeed, $metaFeed['first_name'] . " " . $metaFeed['last_name']);
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed)->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('B' . $cellFeed . ':D' . $cellFeed);
$this->excel->getActiveSheet()->setCellValue('E' . $cellFeed, '(' . $rowFeed->date_feed . ') ' . $rowFeed->feedback_feed);
$this->excel->getActiveSheet()->getStyle('E' . $cellFeed)->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('E' . $cellFeed . ':V' . $cellFeed);
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed . ':V' . $cellFeed)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFf0f0f0');
$this->excel->getActiveSheet()->getStyle('B' . $cellFeed . ':V' . $cellFeed)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$cellFeed++;
}
}
$this->excel->getActiveSheet()->setCellValue('B' . ($cellFeed + 1), 'In Contact List');
$this->excel->getActiveSheet()->getStyle('B' . ($cellFeed + 1))->getFont()->setSize(14);
$this->excel->getActiveSheet()->getStyle('B' . ($cellFeed + 1))->getFont()->setBold(true);
$this->excel->getActiveSheet()->mergeCells('B' . ($cellFeed + 1) . ':V' . ($cellFeed + 1));
$this->excel->getActiveSheet()->getRowDimension($cellFeed + 1)->setRowHeight(30);
$this->excel->getActiveSheet()->getStyle('B' . ($cellFeed + 1) . ':V' . ($cellFeed + 1))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->getStyle('B' . ($cellFeed + 1) . ':V' . ($cellFeed + 1))->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFf0f0f0');
$this->excel->getActiveSheet()->getStyle('B' . ($cellFeed + 1) . ':V' . ($cellFeed + 1))->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//$i = 1;
$contactList = array();
$cellContact = $cellFeed;
if ($metaContact->num_rows() == '0') {
$this->excel->getActiveSheet()->setCellValue('B' . ($cellContact + 2), 'No contact asigned to this call');
$this->excel->getActiveSheet()->mergeCells('B' . ($cellContact + 2) . ':V' . ($cellContact + 2));
} else {
foreach ($metaContact->result() as $rowContact) {
$this->db->select('*');
$this->db->from('ecc_companyContact_cocontact');
$this->db->where('id_cocontact', $rowContact->metaValue_cmeta);
$contactName = $this->db->get();
foreach ($contactName->result() as $rowContactName) {
$this->excel->getActiveSheet()->getRowDimension($cellContact + 2)->setRowHeight(25);
$this->excel->getActiveSheet()->getStyle('B' . ($cellContact + 2) . ':V' . ($cellContact + 2))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$this->excel->getActiveSheet()->setCellValue('B' . ($cellContact + 2), $rowContactName->name_cocontact);
$this->excel->getActiveSheet()->setCellValue('E' . ($cellContact + 2), $rowContactName->email_cocontact);
$this->excel->getActiveSheet()->setCellValue('J' . ($cellContact + 2), '(' . $rowContactName->mobile_cocontact . ')');
$this->excel->getActiveSheet()->getStyle('J' . ($cellContact + 2))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$this->excel->getActiveSheet()->getStyle('B' . ($cellContact + 2))->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('B' . ($cellContact + 2) . ':D' . ($cellContact + 2));
$this->excel->getActiveSheet()->mergeCells('E' . ($cellContact + 2) . ':I' . ($cellContact + 2));
$this->excel->getActiveSheet()->mergeCells('J' . ($cellContact + 2) . ':V' . ($cellContact + 2));
$this->excel->getActiveSheet()->getStyle('B' . ($cellContact + 2) . ':V' . ($cellContact + 2))->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFf0f0f0');
$this->excel->getActiveSheet()->getStyle('B' . ($cellContact + 2) . ':V' . ($cellContact + 2))->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
}
$i++;
$cellContact++;
}
}
$cell = $cellContact;
//set aligment to center for that merged cell (A1 to D1)
$this->excel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$this->excel->getActiveSheet()->getStyle('D4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$filename = $name . " (from " . $from . ' to ' . $to . ').xls';
//save our workbook as this file name
header('Content-Type: application/vnd.ms-excel');
//mime type
header('Content-Disposition: attachment;filename="' . $filename . '"');
//tell browser what's the file name
header('Cache-Control: max-age=0');
//no cache
//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
//if you want to save it as .XLSX Excel 2007 format
$objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
//force user to download the Excel file without writing it to server's HD
$callNumber++;
}
//foreach
/*
$this->excel->getActiveSheet()->setCellValue('A'.($cell+3), 'this report was generated by the ECC Sales Quality System in ' . $creationDate .', by the request of '. $author);
$this->excel->getActiveSheet()->getStyle('A'.($cell+3))->getFont()->setSize(12);
$this->excel->getActiveSheet()->mergeCells('A'.($cell+3).':Q'.($cell+3));
*/
$objWriter->save('php://output');
}
public function test_standard_date_w3c()
{
$this->assertEquals(date(DATE_W3C, $this->time), standard_date('DATE_W3C', $this->time));
}
echo $post->url;
?>
" />
<id>tag:<?php
echo $this->fuel_blog->settings('domain');
?>
,<?php
echo date('Y-m-d', strtotime($post->date_added));
?>
:article/<?php
echo $post->permalink;
?>
</id>
<published><?php
echo standard_date('DATE_ATOM', strtotime($post->date_added));
?>
</published>
<summary><![CDATA[<?php
echo strip_tags(word_limiter($post->excerpt, 100, '...'));
?>
]]></summary>
<author>
<name><?php
echo $post->author_name;
?>
</name>
</author>
<content type="html" xml:lang="en" xml:base="<?php
echo $link;
?>
xmlns:content="http://purl.org/rss/1.0/modules/content/">
<channel>
<title><?php
echo $title;
?>
</title>
<link><?php
echo $link;
?>
</link>
<description><![CDATA[<?php
echo $description;
?>
]]></description>
<pubDate><?php
echo standard_date('DATE_RSS', strtotime($last_updated));
?>
</pubDate>
<language><?php
echo $this->fuel_blog->language(TRUE);
?>
</language>
<latestFuelVersion><?php
echo FUEL_VERSION;
?>
</latestFuelVersion>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<dc:rights>Copyright <?php
echo gmdate('Y', strtotime($last_updated));
?>
<?php
if (!defined('BASEPATH')) {
exit(__('No direct script access allowed'));
}
?>
<div class="welcome">
<span class="userInfo"><?php
echo Model('data')->welcome_get();
?>
| <a onclick="language_selection();" href="javascript:void(0)">Select
Language</a> | </span><span>
<?php
$format = 'DATE_RFC822';
$time = time();
echo standard_date($format, $time);
?>
</span>
</div>
