function alterTables()
{
$this->loadAdapter();
$CI = new CI(-1);
$CIA = $CI->newAttributes();
switch ($this->A("PatchType")) {
case "mysql":
$v = explode("\n", $this->A("PatchValue"));
foreach ($v as $key => $value) {
$CIA->MySQL = $value;
$this->Adapter->alterTable($CIA);
}
break;
}
}
function index()
{
header("Content-type: text/plain");
$segs = $this->uri->segment_array();
$cron_group = false;
$force = false;
$action = false;
foreach ($segs as $segment) {
if (stristr($segment, 'g:') == true) {
$cron_group = substr($segment, 2, strlen($segment));
/// exit($cron_group);
}
if (stristr($segment, 'force:true') == true) {
$force = true;
}
if (stristr($segment, 'a:') == true) {
$action = substr($segment, 2, strlen($segment));
}
}
$job = CI::model('core')->cronjobGetOne($cron_group, $force, $action);
if (!empty($job)) {
print "\n\n" . 'Begin - ' . date("Y-m-d H:i:s") . ' - ' . $job['cronjob_name'] . "\n";
$to_exc = '$this->' . $job['model_name'] . '->' . $job['function_to_execute'];
//print $to_exc;
eval($to_exc . ';');
print "\n" . 'End - ' . date("Y-m-d H:i:s") . ' - ' . $job['cronjob_name'] . "\n\n";
} else {
print "\n" . 'No jobs - ' . date("Y-m-d H:i:s") . "\n\n";
}
//var_dump($job);
//print 'cron-' . date("Y-m-d H:i:s");
}
public function index($slug)
{
$product = \CI::Products()->slug($slug);
if (!$product) {
throw_404();
} else {
$product->images = json_decode($product->images, true);
if ($product->images) {
$product->images = array_values($product->images);
} else {
$product->images = [];
}
//set product options
$data['options'] = \CI::ProductOptions()->getProductOptions($product->id);
$data['posted_options'] = \CI::session()->flashdata('option_values');
//get related items
$data['related'] = $product->related_products;
//create view variable
$data['page_title'] = $product->name;
$data['meta'] = $product->meta;
$data['seo_title'] = !empty($product->seo_title) ? $product->seo_title : $product->name;
$data['product'] = $product;
//load the view
$this->view('product', $data);
}
}
public function logout()
{
\CI::auth()->logout();
//when someone logs out, automatically redirect them to the login page.
\CI::session()->set_flashdata('message', lang('message_logged_out'));
redirect('admin/login');
}
function getTerm($code)
{
CI::db()->select('term');
$result = CI::db()->get_where('search', array('code' => $code));
$result = $result->row();
return $result->term;
}
function delete()
{
$id = $_POST['to_table_id'];
if (intval($id) == 0) {
exit('id?');
} else {
global $cms_db_tables;
$id = intval($_POST['to_table_id']);
$real_table = $cms_db_tables[$_POST['to_table']];
$q = "delete from {$real_table} where id={$id} ";
$q = CI::model('core')->dbQ($q);
$table = $cms_db_tables['table_reports'];
$q = "delete from {$table} where to_table='{$_POST['to_table']}' and to_table_id='{$_POST['to_table_id']}' ";
$q = CI::model('core')->dbQ($q);
CI::model('core')->cleanCacheGroup('reports');
switch ($_POST['to_table']) {
case 'table_content':
CI::model('core')->cleanCacheGroup('content');
break;
case 'table_comments':
CI::model('core')->cleanCacheGroup('comments');
break;
default:
CI::model('core')->cacheDeleteAll();
break;
}
//CI::model('comments')->commentsDeleteById ( $id );
}
}
public function generate()
{
$type = CI::uri()->segment(1);
$slug = CI::uri()->segment(2);
if (!$type || !$slug) {
return;
//return blank
}
if ($type == 'category') {
$category = CI::Categories()->slug($slug);
if (!$category) {
return;
}
$this->trace_categories($category->id);
} elseif ($type == 'product') {
$product = CI::Products()->slug($slug);
if (!$product) {
return;
}
array_unshift($this->breadcrumbs, ['link' => site_url('product/' . $product->slug), 'name' => $product->name]);
$this->trace_categories($product->primary_category);
} elseif ($type == 'page') {
$page = CI::Pages()->slug($slug);
if (!$page) {
return;
}
$this->trace_pages($page->id);
}
echo GoCart\Libraries\View::getInstance()->get('breadcrumbs', ['breadcrumbs' => $this->breadcrumbs]);
}
public function generator($eng, $alt)
{
$cos_phi = 0.8;
$engine = \CI::Products()->getProduct($eng);
$engine->manufacturer = \CI::Products()->getManufacturers($engine->manufacturers);
$alternator = \CI::Products()->getProduct($alt);
$alternator->manufacturer = \CI::Products()->getManufacturers($alternator->manufacturers);
$engine_parameters = \CI::Products()->getParameters($engine->id, 'engines');
$engine_alternator = \CI::Products()->getParameters($alternator->id, 'alternators');
//echo '<pre>';print_r($alternator);exit;
$data['page_title'] = $engine->name;
$data['meta'] = $engine->meta;
$data['seo_title'] = !empty($engine->seo_title) ? $engine->seo_title : $engine->name;
$data['product'] = $engine;
$data['engine_parameters'] = $engine_parameters;
$data['alt'] = $alternator;
$data['engine_alternator'] = $engine_alternator;
$generators = array();
$generators['kVA'] = $generators['kVA_standby'] = $engine_parameters->standby / $cos_phi * ($engine_alternator->efficiency * 0.01);
$generators['kVA_prime'] = $engine_parameters->prime / $cos_phi * ($engine_alternator->efficiency * 0.01);
$generators['price'] = $engine->price_1 + $alternator->price_1;
if ($engine_alternator->power < $generators['kVA']) {
$generators['kVA'] = $engine_alternator->power;
}
if ($engine->days > $alternator->days) {
$generators['days'] = $engine->days;
} else {
$generators['days'] = $alternator->days;
}
$generators['name'] = 'G50-' . round($generators['kVA']) . $engine->manufacturer->code . $alternator->manufacturer->code . 'BA';
//echo '<pre>';print_r($generators);exit;
$data['generators'] = $generators;
$this->view('generator', $data);
}
public function index($slug, $sort = 'id', $dir = "ASC", $page = 0)
{
\CI::lang()->load('categories');
//define the URL for pagination
$pagination_base_url = site_url('category/' . $slug . '/' . $sort . '/' . $dir);
//how many products do we want to display per page?
//this is configurable from the admin settings page.
$per_page = config_item('products_per_page');
//grab the categories
$categories = \CI::Categories()->get($slug, $sort, $dir, $page, $per_page);
//no category? show 404
if (!$categories) {
throw_404();
}
//load up the pagination library
\CI::load()->library('pagination');
$config['base_url'] = $pagination_base_url;
$config['uri_segment'] = 5;
$config['per_page'] = $per_page;
$config['num_links'] = 3;
$config['total_rows'] = $categories['total_products'];
\CI::pagination()->initialize($config);
//load the view
$this->view('categories/category', $categories);
}
/**
*
*/
function __construct()
{
date_default_timezone_set('Asia/Calcutta');
$ci = CI::get_instance();
$ci->load->Model('Email_settings/Mdl_email_settings');
//load email settings model
$smtp = $ci->Mdl_email_settings->toArray();
//get object valeus in array
$config = array();
$config['protocol'] = 'smtp';
$config['mailpath'] = '/usr/sbin/sendmail';
$config['smtp_host'] = $smtp['smtp_host'];
$config['smtp_pass'] = $smtp['smtp_pass'];
// email's password - set smtp values
$config['smtp_user'] = $smtp['smtp_user'];
$config['smtp_port'] = $smtp['smtp_port'];
//gmail port 465 (ssl) and 587 (TSL) required
$config['smtp_timeout'] = 10;
//smtp timeout in seconds
$config['wordwrap'] = TRUE;
$config['wrapchars'] = 76;
$config['mailtype'] = 'html';
$config['charset'] = 'utf-8';
$config['validate'] = TRUE;
$config['priority'] = 3;
$config['crif'] = "\r\n";
$config['newline'] = "\r\n";
$config['bcc_batch_mode'] = TRUE;
$config['bcc_batch_size'] = 200;
parent::__construct($config);
}
function get_visits_by_url($url, $start_time = false)
{
global $cms_db_tables;
$idsite = $this->site_id();
$table = $cms_db_tables['table_log_action'];
$cache_group = 'global/stats';
$q = "SELECT * FROM {$table} WHERE name = '{$url}' ";
$q = CI::model('core')->dbQuery($q, __FUNCTION__ . md5($q), $cache_group, '- 5 minutes');
if (!empty($q)) {
$q = $q[0];
$idaction = $q['idaction'];
$table2 = $cms_db_tables['table_log_link_visit_action'];
if ($start_time == false) {
$start_time = strtotime("4 weeks ago");
$start_time = date("Y-m-d H:i:s", $start_time);
} else {
$start_time = strtotime($start_time);
$start_time = date("Y-m-d H:i:s", $start_time);
}
$q = " SELECT idaction_name as id, \n COUNT(idlink_va) as views, \n COUNT(DISTINCT idvisitor) as visits, \n COUNT(IF(idaction_url_ref=0, 1, null)) as entry, \n log_action.name as page \n FROM {$table2}, {$table} \n WHERE {$table2}.idsite={$idsite} \n \n and idaction_url = {$idaction} \n \n AND {$table2}.idaction_name = {$table}.idaction \n AND server_time >='{$start_time}'\n \n ";
$q = " SELECT idaction_name as id, \n COUNT(idlink_va) as views \n \n FROM {$table2} \n WHERE \n \n idaction_url = {$idaction} \n \n \n AND server_time >='{$start_time}'\n \n ";
$q = CI::model('core')->dbQuery($q, __FUNCTION__ . md5($q), $cache_group, '- 5 minutes');
return intval($q[0]["views"]);
} else {
return 0;
}
}
function load()
{
$plugin_name = $this->uri->segment(4);
$this->template['functionName'] = strtolower(__FUNCTION__);
$this->template['pluginName'] = $plugin_name;
$this->load->vars($this->template);
$layout = CI::view('admin/layout', true, true);
$primarycontent = '';
$secondarycontent = '';
$plugindata = CI::model('core')->plugins_getPluginConfig($plugin_name);
//
//print PLUGINS_DIRNAME . $dirname .$plugin_name.'/'.$plugindata['plugin_admin_dir']. '/controller.php' ;
if (is_file(PLUGINS_DIRNAME . $dirname . $plugin_name . '/' . $plugindata['plugin_admin_dir'] . '/controller.php') == true) {
$firecms = get_instance();
define('THIS_PLUGIN_URL', site_url('admin/plugins/load') . '/' . $plugin_name . '/');
define('THIS_PLUGIN_DIRNAME', PLUGINS_DIRNAME . $dirname . $plugin_name . '/');
define('THIS_PLUGIN_DIRNAME_ADMIN', PLUGINS_DIRNAME . $dirname . $plugin_name . '/' . $plugindata['plugin_admin_dir'] . '/');
require_once PLUGINS_DIRNAME . $dirname . $plugin_name . '/' . $plugindata['plugin_admin_dir'] . '/controller.php';
}
//$primarycontent = CI::view ( 'admin/comments/index', true, true );
//$secondarycontent = CI::view ( 'admin/content/sidebar', true, true );
$layout = str_ireplace('{primarycontent}', $primarycontent, $layout);
$layout = str_ireplace('{secondarycontent}', $secondarycontent, $layout);
//CI::view('welcome_message');
CI::library('output')->set_output($layout);
}
function edit()
{
$this->template['functionName'] = strtolower(__FUNCTION__);
$this->load->vars($this->template);
if ($_POST) {
$save = $this->cacaomail_model->saveMailAccounts($_POST);
redirect('mailaccounts');
}
$segs = $this->uri->segment_array();
$the_id = false;
foreach ($segs as $segment) {
if (stristr($segment, 'id:') == true) {
$the_id = $segment;
$the_id = substr($the_id, 3, strlen($the_id));
}
}
if (intval($the_id) != 0) {
$form_values = $this->cacaomail_model->getMailAccounts(array('id' => $the_id), 1);
$form_values = $form_values[0];
$this->template['form_values'] = $form_values;
} else {
//$this->template ['form_values'] = false;
}
$this->template['form_values']['account_groups'] = $this->cacaomail_model->getMailAccountsGroups();
$this->load->vars($this->template);
$layout = CI::view('layout', true, true);
$primarycontent = '';
$secondarycontent = '';
$primarycontent = CI::view('mailaccounts/edit', true, true);
$secondarycontent = CI::view('mailaccounts/sidebar', true, true);
$layout = str_ireplace('{primarycontent}', $primarycontent, $layout);
$layout = str_ireplace('{secondarycontent}', $secondarycontent, $layout);
//CI::view('welcome_message');
CI::library('output')->set_output($layout);
}
function lap_dat()
{
\CI::load()->model(['Materials']);
$tmp = \CI::Materials()->getMaterials();
echo '<pre>';
print_r($tmp);
exit;
}
function mediaDelete()
{
$id = $_POST['id'];
if (intval($id) != 0) {
CI::model('core')->mediaDelete($id);
}
exit;
}
public function shortcode($slug = false, $perPage = false)
{
if (!$perPage) {
$perPage = config_item('products_per_page');
}
$products = \CI::Categories()->get($slug, 'id', 'ASC', 0, $perPage);
return $this->partial('categories/products', $products);
}
public function rates()
{
$settings = \CI::Settings()->get_settings('FlatRate');
if ($settings['enabled'] && $settings['enabled'] > 0) {
return ['Flat Rate' => $settings['rate']];
} else {
return [];
}
}
function getVideos($criteria = false)
{
$table = TABLE_PREFIX . 'masterdebate_videos';
$q = " SELECT * FROM {$table} order by id DESC ";
//print $q ;
$query = CI::db()->query($q);
$query = $query->result_array();
return $query;
}
function delete()
{
$id = $_POST['id'];
if (intval($id) == 0) {
exit('id');
} else {
CI::model('comments')->commentsDeleteById($id);
}
}
public function rates()
{
$settings = \CI::Settings()->get_settings('FlatRate');
if (isset($settings['enabled']) && (bool) $settings['enabled']) {
return ['фирма Спиди' => $settings['rate']];
} else {
return [];
}
}
public function delete($direction = false, $id = false)
{
if ($id) {
\CI::db()->delete($this->_db_table[$direction], array('id' => $id));
} else {
//if they do not provide an id send them to the product list page with an error
\CI::session()->set_flashdata('error', lang('error_not_found'));
}
redirect('admin/materials/' . $direction);
}
function useremail_check($username)
{
$check = CI::model('users')->doUserExist('email', $username);
if ($check == true) {
$this->validation->set_message('useremail_check', "The email {$username} is already assigned to another user! Please choose new one!");
return FALSE;
} else {
return TRUE;
}
}
public function getAreaTaxRate()
{
$rate = CI::db()->where(array('code' => $this->address['zip'], 'zone_id' => $this->address['zone_id']))->get('country_zone_areas')->row();
if ($rate) {
$rate = $rate->tax / 100;
} else {
$rate = 0;
}
return $rate;
}
function ajax_delete_by_id()
{
$id = $_POST['id'];
if (intval($id) == 0) {
exit(0);
} else {
CI::model('core')->optionsDeleteById($id);
exit(1);
}
}
public function completeSitemap()
{
$xml = $this->partial('sitemap_xml_foot', [], true);
echo $xml;
$file = fopen('sitemap.xml', 'a');
fwrite($file, $xml);
fclose($file);
\CI::session()->set_flashdata('message', lang('success_sitemap_generate') . ' File location ' . site_url('sitemap.xml'));
redirect('admin/sitemap');
}
public function api($slug)
{
\CI::load()->language('page');
$page = $this->Page_model->slug($slug);
if (!$page) {
$json = json_encode(['error' => lang('error_page_not_found')]);
} else {
$json = json_encode($page);
}
$this->view('json', ['json' => json_encode($json)]);
}
public function index($code = false, $page = 0)
{
$pagination_base_url = site_url('search/' . $code);
//how many products do we want to display per page?
//this is configurable from the admin settings page.
$per_page = config_item('products_per_page');
\CI::load()->model('Search');
//check to see if we have a search term
if (!$code) {
//if the term is in post, save it to the db and give me a reference
$term = \CI::input()->post('term', true);
if (empty($term)) {
//if there is still no search term throw an error
$data['error'] = lang('search_error');
$this->view('search_error', $data);
return;
} else {
$code = \CI::Search()->recordTerm($term);
// no code? redirect so we can have the code in place for the sorting.
// I know this isn't the best way...
redirect('search/' . $code . '/' . $page);
}
} else {
//if we have the md5 string, get the term
$term = \CI::Search()->getTerm($code);
}
//fix for the category view page.
$data['base_url'] = [];
$sortArray = array('name/asc' => array('by' => 'name', 'sort' => 'ASC'), 'name/desc' => array('by' => 'name', 'sort' => 'DESC'), 'price/asc' => array('by' => 'price', 'sort' => 'ASC'), 'price/desc' => array('by' => 'price', 'sort' => 'DESC'));
$sortBy = array('by' => false, 'sort' => false);
if (isset($_GET['by'])) {
if (isset($sortArray[$_GET['by']])) {
$sortBy = $sortArray[$_GET['by']];
}
}
if (empty($term)) {
//if there is still no search term throw an error
$this->view('search_error', $data);
return;
} else {
$result = \CI::Products()->search_products($term, $per_page, $page, $sortBy['by'], $sortBy['sort']);
$config['total_rows'] = $result['count'];
\CI::load()->library('pagination');
$config['base_url'] = $pagination_base_url;
$config['uri_segment'] = 3;
$config['per_page'] = $per_page;
$config['num_links'] = 3;
$config['total_rows'] = $result['count'];
\CI::pagination()->initialize($config);
$data['products'] = $result['products'];
$data['category'] = (object) ['name' => str_replace('{term}', $term, lang('search_title'))];
$this->view('categories/category', $data);
}
}
public function __construct() {
/* assign the application instance */
self::$APP = $this;
/* re-assign language and config for modules */
if ( ! is_a($this->lang, 'MX_Lang')) $this->lang = new MX_Lang;
if ( ! is_a($this->config, 'MX_Config')) $this->config = new MX_Config;
parent::__construct();
}
public function index()
{
\CI::auth()->check_access('Admin', true);
\CI::lang()->load('settings');
\CI::load()->helper('inflector');
global $shippingModules;
$data['shipping_modules'] = $shippingModules;
$data['enabled_modules'] = \CI::Settings()->get_settings('shipping_modules');
$data['page_title'] = lang('common_shipping_modules');
$this->view('shipping_index', $data);
}
function google_Analytics_getKeywordsForProfile($profile_id, $start_date = false, $end_date = false)
{
$email = CI::model('content')->optionsGetByKey('google_analytics_login');
$pass = CI::model('content')->optionsGetByKey('google_analytics_pass');
require_once "Zend/Loader.php";
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_Query');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
$client = Zend_Gdata_ClientLogin::getHttpClient($email, $pass, "analytics");
$gdClient = new Zend_Gdata($client);
if ($start_date == false) {
$start_date = date("Y-m-d", mktime(0, 0, 0, date("m") - 1, date("d"), date("Y")));
}
if ($end_date == false) {
$end_date = date("Y-m-d", mktime(0, 0, 0, date("m") - 0, date("d"), date("Y")));
}
try {
$dimensions = array("ga:region", "ga:city", "ga:latitude", "ga:longitude");
$metrics = array("ga:visits", "ga:pageviews");
$dimensions = array("ga:keyword");
$metrics = array("ga:pageviews");
//dimensions=ga:country&metrics=ga:visitors
$reportURL = "https://www.google.com/analytics/feeds/data?ids={$profile_id}&" . "dimensions=" . @implode(",", $dimensions) . "&" . "metrics=" . @implode(",", $metrics) . "&max-results=50" . '&sort=ga:pageviews' . "&" . "start-date={$start_date}&" . "end-date={$end_date}";
// var_dump($reportURL);
$results = $gdClient->getFeed($reportURL);
$titleRow = 1;
// To output a row of column labels
foreach ($results as $rep) {
if ($titleRow) {
foreach ($rep->extensionElements as $elem) {
$titles[] = $elem->extensionAttributes["name"]["value"];
}
// echo implode ( ",", $titles ) . "\n";
//echo "<hr>";
$titleRow = 0;
}
foreach ($rep->extensionElements as $elem) {
//var_dump($elem);
$the_item = $elem->extensionAttributes["value"]["value"];
var_dump($the_item);
if (strlen($the_item) > 5) {
print '<pre>';
$row[] = $the_item;
print '</pre>';
}
}
//echo implode ( ",", $row ) . "\n";
//echo "<br>";
}
} catch (Zend_Exception $e) {
echo "Caught exception: " . get_class($e) . "\n";
echo "Message: " . $e->getMessage() . "\n";
}
}
