/** * Метод загрузки данных * * @param Sppc_Dashboard_DateRange $range */ protected function loadResults(Sppc_Dashboard_DateRange $range, $sortField = '', $sortDirection = '') { // Подключаем объект фидов $this->CI->load->model('feeds'); /* @var $feeds Feeds */ $feeds = $this->CI->feeds; if (empty($sortField)) { $sortField = $this->getSortField(); } if (empty($sortDirection)) { $sortDirection = $this->getSortDirection(); } // Формируем колонки $this->addColumn('name', 'Feed Name'); $this->addColumn('impressions', 'Impressions', 'numeric', 'desc'); $this->addColumn('clicks', 'Clicks', 'numeric', 'desc'); $this->addColumn('ctr', '% CTR', 'numeric', 'desc'); $this->addColumn('revenue', 'Earnings', 'numeric', 'desc'); // Получаем данные по фидам $rowsData = $feeds->top($sortField, $sortDirection, array('from' => $range->getUnixStartDate(), 'to' => $range->getUnixEndDate())); foreach ($rowsData as $data) { $rowData = array(type_to_str($data['title'], 'encode'), type_to_str($data['impressions'], 'integer'), type_to_str($data['clicks'], 'integer'), type_to_str($data['ctr'], 'procent'), type_to_str($data['revenue'], 'money')); $this->addRow($rowData); } // Устанавливаем title $this->title = sprintf(__('Top Feeds (%d)'), count($rowsData)); }
/** * функция по умолчанию * * @return ничего не возвращает */ public function index() { $this->load->model('groups', '', TRUE); $this->groups->end_fl_status(); if (is_null($this->id_campaign)) { if (is_null($this->id_group)) { $usercode = type_to_str($this->user_id, 'textcode'); $node = 'user' . $usercode; $startitem = "show_campaigns('{$usercode}');"; } else { $node = 'group' . $this->id_group; $id_campaign_type = $this->groups->group_type(type_cast($this->id_group, 'textcode')); $startitem = "show_ads('{$this->id_group}', '', '{$id_campaign_type}');"; } } else { $node = 'camp' . $this->id_campaign; $id_campaign = type_cast($this->id_campaign, 'textcode'); $id_campaign_type = $this->groups->campaign_type($id_campaign); $startitem = "show_groups('{$this->id_campaign}', '{$id_campaign_type}');"; } $vars = array('TREE' => $this->groups->get_html_tree($this->user_id, $this->user_name), 'TABLE' => 'table', 'STARTITEM' => $startitem, 'NODE' => $node, 'TAB' => $this->tab, 'NUMBERFORMAT' => get_number_format()); $vars['PLUGIN_COLOR_HINT'] = implode($this->plugins->run('get_colors_hint_html', $this)); $vars['PLUGIN_JS_FUNCTIONS'] = implode($this->plugins->run('get_js_functions_html', $this)); $plugin_controller = ''; foreach ($this->plugins->run('get_controller', $this) as $controllers) { foreach ($controllers as $id_campaign_type => $return_value) { $plugin_controller .= " case '{$id_campaign_type}': return {$return_value}; "; } } $vars['PLUGIN_CONTROLLER'] = $plugin_controller; $this->_set_content($this->parser->parse('advertiser/manage_ads/template.html', $vars, TRUE)); $this->_display(); }
/** * возвращает список выплат * * @param array параметры списка выплат * int id_entity идентификатор сущности, которой выплачивались деньги, - опционально * array flow_program фильтр по типам денежных потоков, - опционально * array fields поля БД для запроса списка - опционально * array order ('by' => 'field', 'direction' => 'asc') параметры сортировки списка - опционально * array date_range ('from' => unixtimestamp, 'to' => unixtimestamp) фильтр по дате выплаты - опционально * int id_gateway фильтр по платежным шлюзам - опционально (0 - все шлюзы) * @return array */ public function get_list($params) { $result = array(); if (isset($params['id_entity'])) { $this->db->where('id_entity_receipt', $params['id_entity']); } if (isset($params['id_gateway'])) { if ($params['id_gateway']) { $this->db->where('payment_gateways.id_entity', $params['id_gateway']); } } if (isset($params['flow_program'])) { $this->db->where_in('flow_program', $params['flow_program']); } if (isset($params['fields'])) { $this->db->select($params['fields']); } if (isset($params['order'])) { $this->db->order_by($params['order']['by'], $params['order']['direction']); } if (isset($params['date_range'])) { $this->db->where(array('flow_date >=' => type_to_str($params['date_range']['from'], 'databasedatetime'), 'flow_date <=' => type_to_str($params['date_range']['to'], 'databasedatetime'))); } $this->db->join('money_flows', self::TABLE . '.id_flow = money_flows.id_flow')->join('payment_gateways', 'money_flows.id_entity_expense = payment_gateways.id_entity')->join('entities', 'payment_gateways.id_entity = entities.id_entity')->join('entities pe', 'money_flows.id_entity_receipt = pe.id_entity')->join('payment_requests', 'money_flows.id_flow = payment_requests.id_flow', 'left'); $query = $this->db->get(self::TABLE); //echo $this->db->last_query(); foreach ($query->result() as $row) { //$ids[] = $row->id_entity_receipt; $result[] = $row; } return $result; }
/** * @see Sppc_Dashboard_Block_Interface::getContent * * @param Sppc_Dashboard_DateRange $range * @return string */ public function getContent(Sppc_Dashboard_DateRange $range) { // Получаем заработок за период $this->CI->load->model('entity'); $stat = $this->CI->entity->publisher_range_stat(array('from' => mktime(0, 0, 0), 'to' => time())); // Выводим $data = array('REVENUE' => type_to_str($stat['revenue'], 'money')); return $this->CI->parser->parse('common/dashboard/today_earnings.html', $data, true); }
public function index() { $this->load->model('ads', '', TRUE); $this->load->model('groups', '', TRUE); $id_ad = $this->input->post('id'); if ($id_ad) { $id_ad_decoded = type_cast($id_ad, 'textcode'); $this->load->model('ads', '', TRUE); $id_group_decoded = $this->ads->group($id_ad_decoded); $group_code = type_to_str($id_group_decoded, 'textcode'); $this->id_group = $group_code; } else { $this->load->model('new_campaign'); $this->new_campaign->free_storage($this->id_xml); $this->session->unset_userdata('id_xml'); } $id_group = $this->input->post('id_group'); if (isset($id_ad_decoded)) { $this->img_src = $this->ads->image($id_ad_decoded, TRUE); $this->img_dim = $this->ads->get_ad_dimensions($id_ad_decoded); } if ($id_group) { $id_group_decoded = type_cast($id_group, 'textcode'); $group_code = type_to_str($id_group_decoded, 'textcode'); $this->id_group = $id_group; } $campaign_name = type_to_str($this->groups->parent_campaign($id_group_decoded), 'encode'); $id_campaign = type_to_str($this->groups->id_parent_campaign($id_group_decoded), 'textcode'); $group_name = type_to_str($this->groups->name($id_group_decoded), 'encode'); $this->cancel_creation_controller = "advertiser/manage_ads/group/{$group_code}/ads"; if ($id_ad) { $this->next_step = 'advertiser/create_ad/success/' . $group_code . '/true'; } else { $this->next_step = 'advertiser/create_ad/success/' . $group_code . '/false'; } $this->upload_controller = "advertiser/create_ad/upload_image/{$group_code}"; $this->form_title = '<a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads">{@Manage Ads@}</a> → ' . '<a href="advertiser/manage_ads/campaign/' . $id_campaign . '">{@Campaign@}:</a> <span class="green i">„' . $campaign_name . '“</span> → ' . '<a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads/group/' . $group_code . '/ads">{@Group@}:</a> <span class="green i">„' . $group_name . '“</span> → '; if ($id_ad) { $ad_info = $this->ads->get($id_ad_decoded); if ($ad_info['ad_type'] == 'richmedia') { $ad_info['title'] = __('Rich Media Ad'); } $this->ad_id = $id_ad; $this->form_title .= __('Edit Ad') . ': <span class="green i">„' . type_to_str($ad_info['title'], 'encode') . '“</span>'; $this->image_dir = $this->config->item('path_to_images'); } else { $this->form_title .= __('Create Ad'); } parent::index('create_ad'); }
/** * конструктор класса, * вносит изменения в структуру базового класса * * @return ничего не возвращает */ public function Account_settings() { parent::Parent_entity(); $this->form_data["id"] = $this->user_id; $this->form_data["kill"] = array("terms_and_conditions", "confirm_password", "cancel_button"); $this->form_data["redirect"] = "advertiser/account_settings/success"; unset($this->form_data["fields"]["confirm"]); $this->button_name = "{@Update Account@}"; $this->content['SROLE'] = $this->role; $this->content['CODE'] = type_to_str($this->user_id, 'textcode'); $this->content["CANCEL"] = $this->site_url . $this->index_page . "advertiser/account_settings"; $this->content["INFO"] = $this->load->view("advertiser/account_settings/info.html", "", TRUE); $this->_set_title(implode(self::TITLE_SEP, array(__("Advertiser"), __("Account Settings")))); $this->_set_help_index("advertiser_account_settings"); }
public function index($group_code = FALSE, $program_type = null) { $this->set_campaign_type('edit_channels'); $this->setCurrentStep('/advertiser/edit_channels'); $this->load->model('groups', '', TRUE); $code = $this->input->post('group'); if (FALSE === $code) { $code = $group_code; } else { //Если код группы есть в POST, то на страницу пришли из раздела Manage Ads (производим очистку XML) $this->new_campaign->free_storage($this->id_xml); $this->id_xml = uniqid(); $this->session->set_userdata('id_xml', $this->id_xml); } if (2 == $this->new_campaign->init_storage($this->id_xml)) { //на первом шаге создаем xml-файл и наполняем его данными выбранной группы $id_group = type_cast($code, 'textcode'); //$this->new_campaign->free_storage($this->id_xml); //$this->new_campaign->init_storage($this->id_xml); $this->new_campaign->set_group_name($code); /*$channels = $this->groups->get_channels($id_group); foreach ($channels as $channel) { $this->new_campaign->add_channel($channel); }*/ $this->new_campaign->set_program_type($program_type); $site_channels = $this->groups->get_site_channels($id_group, false); foreach ($site_channels as $site_channel) { $this->new_campaign->add_site_channel($site_channel); } $this->new_campaign->apply_sites_channels(); $frequency_coup = $this->groups->get_frequency_coup($id_group); $this->new_campaign->set_daily_impressions($frequency_coup > 0 ? $frequency_coup : ''); $this->new_campaign->save_data(); } else { //на остальных шагах работаем с xml-файлом //$this->new_campaign->init_storage($this->id_xml); $code = $this->new_campaign->get_group_name(); $id_group = type_cast($code, 'textcode'); } $this->cancel_creation_controller = 'advertiser/manage_ads/group/' . $code . '/channels'; $this->load->model('campaigns', '', TRUE); $campaign_name = type_to_str($this->groups->parent_campaign($id_group), 'encode'); $id_campaign = type_to_str($this->groups->id_parent_campaign($id_group), 'textcode'); $group_name = type_to_str($this->groups->name($id_group), 'encode'); $group_code = type_to_str($id_group, 'textcode'); $this->form_title = '<h1><a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads">{@Manage Ads@}</a> → ' . '<a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads/campaign/' . $id_campaign . '">{@Campaign@}:</a> <span class="green i">„' . $campaign_name . '“</span> → ' . '<a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads/group/' . $group_code . '/channels">{@Group@}:</a> <span class="green i">„' . $group_name . '“</span></h1>'; parent::index('edit_channels'); }
public function index() { $this->load->model('groups', '', TRUE); $this->new_campaign->init_storage($this->id_xml); $code = $this->new_campaign->get_group_name(); $this->id_group = type_cast($code, 'textcode'); $this->cancel_creation_controller = 'advertiser/manage_ads/group/' . $code . '/channels'; $this->load->model('campaigns', '', TRUE); $campaign_name = type_to_str($this->groups->parent_campaign($this->id_group), 'encode'); $id_campaign = type_to_str($this->groups->id_parent_campaign($this->id_group), 'textcode'); $group_name = type_to_str($this->groups->name($this->id_group), 'encode'); $group_code = type_to_str($this->id_group, 'textcode'); $this->form_title = '<h1><a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads">{@Manage Ads@}</a> → ' . '<a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads/campaign/' . $id_campaign . '">{@Campaign@}:</a> <span class="green i">„' . $campaign_name . '“</span> → ' . '<a href="<%SITEURL%><%INDEXPAGE%>advertiser/manage_ads/group/' . $group_code . '/channels">{@Group@}:</a> <span class="green i">„' . $group_name . '“</span></h1>'; $this->next_step = 'advertiser/edit_set_pricing/success/' . $code; parent::index('edit_channels'); }
/** * отправляет письмо * * @param array $fields массив со значениями полей формы * @return string при успехе - пустая строка, иначе текст ошибки */ public function _create($fields) { $title = $this->global_variables->get('SiteName'); $CI =& get_instance(); $CI->load->library('email'); $config['charset'] = 'utf-8'; $config['wordwrap'] = FALSE; $CI->email->initialize($config); $CI->email->from($fields['e_mail'], type_to_str($fields['name'], 'mime')); $CI->email->to($this->global_variables->get("SystemEMail")); $subject = $title . ' ' . __('Contact Us Message'); $CI->email->subject(type_to_str($subject, 'mime')); $CI->email->message($fields['message']); $CI->email->send(); $this->global_variables->set('MsgID_' . $this->messageid, 'true', 0); return ""; }
/** * Метод загрузки данных * * @param Sppc_Dashboard_DateRange $range */ protected function loadResults(Sppc_Dashboard_DateRange $range) { // Получаем данные за период $this->CI->load->model('entity'); $stat = $this->CI->entity->publisher_range_stat(array('from' => $range->getUnixStartDate(), 'to' => $range->getUnixEndDate())); // Формируем строки для отображения $this->addRow(__('Total Earnings'), type_to_str($stat['revenue'], 'money')); $this->addRow(__('Total Impressions'), type_to_str($stat['impressions'], 'integer')); $this->addRow(__('Total Clicks'), type_to_str($stat['clicks'], 'integer')); $this->addRow(__('CTR'), type_to_str($stat['ctr'], 'procent')); // add additional summary performance fields from plugins foreach ($this->_hooks as $hookObj) { $fields = $hookObj->addSummaryPerformanceFields($stat); foreach ($fields as $field) { $this->addRow($field['title'], $field['value']); } } }
public function _load($id) { $fields = array(); $id_campaign = type_cast($id, 'textcode'); $this->load->model('campaigns', '', TRUE); $info = $this->campaigns->info($id_campaign); $fields['campaign_name'] = $info['name']; $fields['targeting_type'] = $info['targeting_type']; $fields['id_targeting_group'] = type_to_str($info['id_targeting_group'], 'textcode'); $this->load->model('targeting_groups'); $id_targeting_group_temp = $this->targeting_groups->copy($info['id_targeting_group']); //echo $info['id_targeting_group']; $fields['id_targeting_group_temp'] = type_to_str($id_targeting_group_temp, 'textcode'); $targeting_info = new Campaign_Targeting(); $targeting_group_countries = $this->targeting_groups->get_group_list($info['id_targeting_group'], 'countries'); foreach ($targeting_group_countries as $country) { $targeting_info->countries[] = $country['value']; } if (0 == count($targeting_info->countries)) { foreach ($this->targeting_all_list->countries as $iso => $country) { $targeting_info->countries[] = $iso; } } $targeting_group_languages = $this->targeting_groups->get_group_list($info['id_targeting_group'], 'languages'); foreach ($targeting_group_languages as $language) { $targeting_info->languages[] = $language['value']; } if (0 == count($targeting_info->languages)) { foreach ($this->targeting_all_list->languages as $iso => $language) { $targeting_info->languages[] = $iso; } } $fields['targeting'] = json_encode($targeting_info); $id_schedule = $this->campaigns->schedule($id_campaign); $schedule = new Campaign_Schedule(); $schedule->schedule_is_set = !is_null($id_schedule); if (!is_null($id_schedule)) { $schedule->schedule = $this->schedule->get($id_schedule); } $fields['schedule'] = json_encode($schedule); return $fields; }
/** * Метод загрузки данных * * @param Sppc_Dashboard_DateRange $range */ protected function loadResults(Sppc_Dashboard_DateRange $range) { // Получаем новости $this->CI->load->model('admin_news'); $need_update = time() - $this->CI->global_variables->get('orbitscripts_news_time') > 60 * 60 * 12; if ($need_update) { $xml_file = $this->CI->global_variables->get('orbitscripts_news_xml'); $this->CI->load->model('orbit_news', '', TRUE); $rez = $this->CI->orbit_news->parse_xml($xml_file); if (is_null($rez)) { $this->CI->global_variables->set('orbitscripts_news_time', time()); } } $news = $this->CI->admin_news->get_admin_news(); // Добавляем новости для вывода foreach ($news as $row) { $rowData = array('date' => type_to_str($row['date'], 'mysqldate'), 'title' => type_to_str($row['title'], 'encode'), 'description' => nl2br($row['content']), 'link' => $row['link']); $this->addRow($rowData); } }
/** * показывает форму для изменения настроек или результат изменения настроек * * @return ничего не возвращает */ public function index() { $this->load->model('ourdatabaseevo'); $this->load->library('Plugins', array('path' => array('admin', 'system_settings'), 'interface' => 'Sppc_Admin_SystemSettings_Interface')); /** * Добавляет Display 'Your Ad Here' link: * * @return ничего не возвращает */ $your_ad_here_file = APPPATH . 'views/admin/system_settings/your_ad_here.html'; if (file_exists($your_ad_here_file)) { $your_ad_here = $this->load->view('admin/system_settings/your_ad_here.html', '', TRUE); } else { $your_ad_here = ''; } $afile = APPPATH . 'views/admin/system_settings/approve_advertisers.html'; if (file_exists($afile)) { $advsignup = $this->load->view('admin/system_settings/approve_advertisers.html', '', TRUE); } else { $advsignup = ''; } $pfile = APPPATH . 'views/admin/system_settings/approve_publishers.html'; if (file_exists($pfile)) { $pubsignup = $this->load->view('admin/system_settings/approve_publishers.html', '', TRUE); } else { $pubsignup = ''; } $mfile = APPPATH . 'views/admin/system_settings/approve_members.html'; if (file_exists($mfile)) { $memsignup = $this->load->view('admin/system_settings/approve_members.html', '', TRUE); } else { $memsignup = ''; } $form = array("id" => $this->user_id, "name" => "system_settings", "view" => "admin/system_settings/form.html", 'redirect' => 'admin/system_settings/success', 'vars' => array('USERIDCODE' => type_to_str($this->user_id, 'textcode'), 'YOUR_AD_HERE' => $your_ad_here, 'PUBSIGNUP' => $pubsignup, 'ADVSIGNUP' => $advsignup, 'MEMSIGNUP' => $memsignup, 'ADDITIONAL_SETTINGS' => ''), "fields" => array("mail" => array("display_name" => "Administrator E-mail", "id_field_type" => "string", "form_field_type" => "text", "validation_rules" => "required|valid_email"), "reserve" => array("id_field_type" => "bool", "form_field_type" => "checkbox"), "campaigns" => array("id_field_type" => "bool", "form_field_type" => "checkbox"), "signup" => array("id_field_type" => "bool", "form_field_type" => "checkbox"), "pubsignup" => array("id_field_type" => "bool", "form_field_type" => "checkbox"), "memsignup" => array("id_field_type" => "bool", "form_field_type" => "checkbox"), "title" => array("display_name" => "System Title", "id_field_type" => "string", "form_field_type" => "text", "validation_rules" => "required"), "show_your_ad_here_link" => array("display_name" => "Show 'Your Ad Here' link", "id_field_type" => "bool", "form_field_type" => "checkbox"), "your_ad_here_link_text" => array("display_name" => "'Your Ad Here' link text", "id_field_type" => "string", "form_field_type" => "text", "max" => 15))); $this->plugins->run('registerFieldsForAdditionalSettings', $form); $additionalSettings = $this->plugins->run('getAdditionalSettingsHTML', null); $form['vars']['ADDITIONAL_SETTINGS'] = implode(' ', $additionalSettings); $this->load->library("form"); $this->_set_content($this->form->get_form_content("modify", $form, $this->input, $this)); $this->_display(); }
/** * Метод загрузки данных * * @param Sppc_Dashboard_DateRange $range */ protected function loadResults(Sppc_Dashboard_DateRange $range, $sortField = '', $sortDirection = '') { // Подключаем нужный объект $this->CI->load->model('entity'); /* @var $entities Entity */ $entities = $this->CI->entity; if (empty($sortField)) { $sortField = $this->getSortField(); } if (empty($sortDirection)) { $sortDirection = $this->getSortDirection(); } // Формируем колонки $this->addColumn('name', 'Advertiser'); $this->addColumn('impressions', 'Impressions', 'numeric', 'desc'); $this->addColumn('clicks', 'Clicks', 'numeric', 'desc'); $this->addColumn('ctr', '% CTR', 'numeric', 'desc'); $this->addColumn('revenue', 'Earnings', 'numeric', 'desc'); // add additional columns from plugins foreach ($this->_hooks as $hookObj) { $columns = $hookObj->addColumns($this); foreach ($columns as $column) { $this->addColumn($column['name'], $column['title'], $column['type'], $column['order']); } } // Получаем данные по фидам $rowsData = $entities->top_advertisers($sortField, $sortDirection, array('from' => $range->getUnixStartDate(), 'to' => $range->getUnixEndDate())); foreach ($rowsData as $idEntity => $data) { $code = type_to_str($idEntity, 'textcode'); $rowData = array(type_to_str($data['name'], 'encode') . " ({$data['email']})", type_to_str($data['impressions'], 'integer'), type_to_str($data['clicks'], 'integer'), type_to_str($data['ctr'], 'procent'), type_to_str($data['revenue'], 'money')); // add data for addtional columns from plugins foreach ($this->_hooks as $hookObj) { $rowData = $hookObj->addColumnsData($data, $rowData); } $this->addRow($rowData); } // Устанавливаем title $this->title = sprintf(__('Top Advertisers (%d)'), count($rowsData)); }
/** * Отображение формы изменения баланса сущности * */ public function index() { $error_message = ''; $code = $this->input->post('balance_code'); if (!$code) { $error_message = 'Advertiser is not specified!'; $data = array('MESSAGE' => __($error_message), 'REDIRECT' => $this->site_url . $this->index_page . $this->role . '/manage_advertisers'); $content = $this->parser->parse('common/errorbox.html', $data, FALSE); $this->_set_content($content); $this->_display(); return NULL; } $id_entity = type_cast($code, 'textcode'); $entity_info = $this->entity->get_name_and_mail($id_entity); $entity_info = $entity_info->name . ' (' . $entity_info->e_mail . ')'; $balance = $this->entity->ballance($id_entity); $balance = type_to_str($balance, 'money'); $this->load->model('campaigns', '', TRUE); $form = array('id' => $code, 'name' => 'balance_form', 'redirect' => "admin/change_" . $this->subject_role . "_balance/success", 'view' => "admin/change_balance/form.html", 'vars' => array('ENTITY' => $entity_info, 'CUR' => $balance, 'CANCEL_URL' => $this->cancel_url, 'PREV_TITLE' => $this->prev_title), 'fields' => array('amount' => array('display_name' => __('Amount'), 'id_field_type' => 'money', 'form_field_type' => 'text', 'validation_rules' => 'required|callback_valuetrim|float|positive'), 'balance_code' => array('id_field_type' => 'string', 'form_field_type' => 'hidden', 'default' => $code), 'balance_mode' => array('id_field_type' => 'string', 'form_field_type' => 'select', 'options' => array('add' => __('Add'), 'sub' => __('Subtract')), 'default' => 'add'))); $this->_set_content($this->form->get_form_content('modify', $form, $this->input, $this)); $this->_display(); }
/** * Метод загрузки данных * * @param Sppc_Dashboard_DateRange $range */ protected function loadResults(Sppc_Dashboard_DateRange $range, $sortField = '', $sortDirection = '') { // Подключаем нужный объект $this->CI->load->model('site'); /* @var $sites Site */ $sites = $this->CI->site; if (empty($sortField)) { $sortField = $this->getSortField(); } if (empty($sortDirection)) { $sortDirection = $this->getSortDirection(); } // Формируем колонки $this->addColumn('name', 'Site Name'); $this->addColumn('impressions', 'Impressions', 'numeric', 'desc'); $this->addColumn('clicks', 'Clicks', 'numeric', 'desc'); $this->addColumn('ctr', '% CTR', 'numeric', 'desc'); $this->addColumn('revenue', 'Earnings', 'numeric', 'desc'); // add additional columns from plugins foreach ($this->_hooks as $hookObj) { $columns = $hookObj->addColumns($this); foreach ($columns as $column) { $this->addColumn($column['name'], $column['title'], $column['type'], $column['order']); } } // Получаем данные по фидам $rowsData = $sites->top(null, $sortField, $sortDirection, array('from' => $range->getUnixStartDate(), 'to' => $range->getUnixEndDate())); foreach ($rowsData as $data) { $code = type_to_str($data['id_publisher'], 'textcode'); $rowData = array(limit_str_and_hint($data['name'], 20) . " (<a target='_blank' href='http://{$data['url']}'>{$data['url']}</a>)", type_to_str($data['impressions'], 'integer'), type_to_str($data['clicks'], 'integer'), type_to_str($data['ctr'], 'procent'), type_to_str($data['revenue'], 'money')); // add data for addtional columns from plugins foreach ($this->_hooks as $hookObj) { $rowData = $hookObj->addColumnsData($data, $rowData); } $this->addRow($rowData); } // Устанавливаем title $this->title = sprintf(__('Top Sites (%d)'), count($rowsData)); }
/** * возвращает количество рекламодателей, попадающих под указанный фильтр * * @param string $filt фильтр по статусу * @param array $range массив с двумя датами - начала и конце периода ('from', 'to') * @param string $quickSearch Параметр для поиска рекламодателя по id, fullname, email и join date * @return integer количество */ public function total($filt, $range, $quickSearch = '') { $total = array('cnt' => 0, 'balance' => 0, 'impressions' => 0, 'clicks' => 0, 'spent' => 0, 'bonus' => 0); // All pages total $sql = "\n \tSELECT \n \t\tSUM(sa.impressions) AS impressions,\n \t\tSUM(sa.clicks) AS clicks,\n \t\tSUM(sa.spent) AS spent,\n \t\tSUM(e.bonus) AS bonus\n \tFROM advertisers a\n \t\tJOIN entities e ON a.id_entity_advertiser = e.id_entity\n \t\tJOIN entity_roles er ON (er.id_entity = e.id_entity AND er.id_role = " . self::ID_ROLE . ")\n \t\tLEFT JOIN stat_advertisers sa ON (a.id_entity_advertiser = sa.id_entity_advertiser\n \t\t\tAND sa.stat_date BETWEEN '" . type_to_str($range['from'], 'databasedate') . "' AND '" . type_to_str($range['to'], 'databasedate') . "')\n \tWHERE 1 = 1 \n \t"; if ($filt != 'all') { $sql .= ' AND er.status = ' . $this->db->escape($filt); } if (!empty($quickSearch)) { $escapedQuickSearch = $this->db->escape_str($quickSearch); $sql .= " AND ((e.id_entity LIKE '%" . $escapedQuickSearch . "%')\n \t \t\t\t\tOR (e.name LIKE '%" . $escapedQuickSearch . "%')\n \t \t\t\t\tOR (e.e_mail LIKE '%" . $escapedQuickSearch . "%')\n \t \t\t\t\tOR (e.creation_date LIKE '%" . $escapedQuickSearch . "%'))\n \t \t\t "; } $query = $this->db->query($sql); if (0 < $query->num_rows()) { $row = $query->row(); $total['impressions'] = $row->impressions; $total['clicks'] = $row->clicks; $total['spent'] = $row->spent; $total['bonus'] = $row->bonus; } // All count $sql = "\n \tSELECT \n \t\tSUM(e.ballance) AS ballance,\n \t\tCOUNT(*) AS cnt\n \tFROM advertisers a\n \t\tJOIN entities e ON a.id_entity_advertiser = e.id_entity\n \t\tJOIN entity_roles er ON er.id_entity = e.id_entity AND er.id_role = " . self::ID_ROLE . "\n \tWHERE 1 = 1\n "; if ($filt != 'all') { $sql .= ' AND er.status = ' . $this->db->escape($filt); } if (!empty($quickSearch)) { $escapedQuickSearch = $this->db->escape_str($quickSearch); $sql .= " AND ((e.id_entity LIKE '%" . $escapedQuickSearch . "%')\n \t \t\t\t\tOR (e.name LIKE '%" . $escapedQuickSearch . "%')\n \t \t\t\t\tOR (e.e_mail LIKE '%" . $escapedQuickSearch . "%')\n \t \t\t\t\tOR (e.creation_date LIKE '%" . $escapedQuickSearch . "%'))\n \t \t\t "; } $query = $this->db->query($sql); if (0 < $query->num_rows()) { $row = $query->row(); $total['balance'] = $row->ballance; $total['cnt'] = $row->cnt; } return $total; }
public function select_group($site_code, $channel_code) { //Стираем данные о ID XML файла (именно здесь - чтобы убить эти данные и в куке) $this->session->unset_userdata('id_xml'); $program_type = $this->input->post("program_type"); switch ($program_type) { case 'cpm_flatrate': $campaigns_filter = 'cpm_flatrate'; break; default: $this->error_message('Wrong program type specified!'); return; } $id_site = type_cast($site_code, 'textcode'); $id_channel = type_cast($channel_code, 'textcode'); $site_info = $this->site->get_info($id_site); $channel_info = $this->channel->get_info($id_channel); if (is_null($site_info) || is_null($channel_info)) { $this->error_message('Site or channel is not found.'); return; } $this->load->model('groups'); $campaigns_tree = $this->groups->get_html_tree($this->user_id, $this->user_name, 0, $campaigns_filter); $content = $this->parser->parse('advertiser/site_directory/select_group.html', array('SITE_CODE' => $site_code, 'CHANNEL_CODE' => $channel_code, 'SITE_NAME' => type_to_str($site_info->name, 'encode'), 'SITE_URL' => $site_info->url, 'CHANNEL_NAME' => type_to_str($channel_info->name, 'encode'), 'PROGRAM_TYPE' => $program_type, 'CAMPAIGNS_TREEVIEW' => $campaigns_tree, 'CHANNEL_TYPE' => $channel_info->ad_type, 'USER_CODE' => type_to_str($this->user_id, 'textcode'), 'EMPTYTREE' => $this->groups->EmptyTree ? 'true' : 'false')); $this->_set_content($content); $this->_display(); }
/** * Скорее всего этот хак можно удалить будет. * * @access public * @param string * @param bool * @return string */ function post_old($index = '', $xss_clean = FALSE) { /** * Dirty hack для datepicker. * Суть проблемы: у каждой локали есть свой формат даты. * Этот формат никак не совпадает с форматом даты в яваскрипте. * И ко всему прочему сокращённое название месяца для разных языков разное. * Поэтому для дэйтпикера формат даты текущей локали форматируется в простой формат: mm/dd/yyyy, * и соответсвенно из дэйтпикера приходит даты в таком формате. * Вот их и нужно скнонвертировать в формат текущей локали. * * При каждом обращении к переменным post или get происходит их форматирование. * -- * А можно при первом удачном обращении отформатировать from & to правильно и записать * их в POST, а datepicker_flag - убрать * * @author Semerenko */ if (FALSE !== $this->_fetch_from_array($_POST, 'datepicker_flag', $xss_clean) && in_array($index, array('from', 'to', 'birthday'))) { $d = $this->_fetch_from_array($_POST, $index, $xss_clean); // mm.dd.yyyy $date_parts = strptime($d, '%m.%d.%Y'); $ts = mktime(0, 0, 0, $date_parts["tm_mon"] + 1, $date_parts["tm_mday"], $date_parts["tm_year"]); $res = type_to_str($ts, 'date'); return $res; } return $this->_fetch_from_array($_POST, $index, $xss_clean); }
/** * Получение таблицы сайтов по указанным критериям * */ public function sites_table() { $this->load->model('channel_program'); $filter_mode = $this->input->post('filter_mode'); $this->load->helper('periods_helper'); $this->table_builder->clear(); $this->table_builder->init_sort_vars('iframe_channels', 'channel_name', 'asc'); $this->table_builder->sorted_column(0, 'channel_name', "Channel Name", 'asc'); $this->table_builder->sorted_column(1, 'id_dimension', 'Format', 'asc'); $this->table_builder->set_cell_content(0, 2, __('Cost Model')); $this->table_builder->sorted_column(3, 'min_cpm_volume', __('Minimal CPM Package (Impressions)'), 'asc'); $this->table_builder->sorted_column(4, 'min_cpm_cost_text', __('CPM Cost (Text Ads)'), 'asc'); $this->table_builder->sorted_column(6, 'min_cpm_cost_image', __('CPM Cost (Text & Image)'), 'asc'); $this->table_builder->sorted_column(8, 'min_flat_rate_volume', __('Minimal Flat Rate Package (Days)'), 'asc'); $this->table_builder->sorted_column(9, 'min_flat_rate_cost_text', __('Flat Rate Cost (Text Ads)'), 'asc'); $this->table_builder->sorted_column(11, 'min_flat_rate_cost_image', __('Flat Rate Cost (Text & Image)'), 'asc'); $this->table_builder->sorted_column(13, 'impressions', 'Traffic Volume', 'asc'); $this->table_builder->set_cell_content(0, 14, __('Action')); $this->table_builder->cell(0, 2)->add_attribute('class', 'simpleTitle'); $this->table_builder->cell(0, 14)->add_attribute('class', 'simpleTitle'); $this->table_builder->add_col_attribute(0, 'class', ''); $this->table_builder->add_col_attribute(1, 'class', 'w80 center'); $this->table_builder->add_col_attribute(2, 'class', 'w80 center'); $this->table_builder->add_col_attribute(3, 'class', 'center'); $this->table_builder->add_col_attribute(4, 'class', 'center'); $this->table_builder->add_col_attribute(6, 'class', 'center'); $this->table_builder->add_col_attribute(8, 'class', 'center'); $this->table_builder->add_col_attribute(9, 'class', 'center'); $this->table_builder->add_col_attribute(11, 'class', 'center'); $this->table_builder->add_col_attribute(13, 'class', 'center'); $this->table_builder->add_col_attribute(14, 'class', 'center'); $this->table_builder->add_row_attribute(0, 'class', 'th f9px'); $form_data = array("name" => "iframe_channels_form", "view" => "admin/adplacing/manage_sites_channels/choose_channels/iframe_channels_table.html", 'fields' => array('filter_mode' => array('id_field_type' => 'string', 'form_field_type' => 'hidden', 'default' => $filter_mode))); switch ($filter_mode) { case 'by_category': $id_category = $this->input->post('id_category'); if ($id_category) { $form_data['fields']['id_category'] = array('id_field_type' => 'int', 'form_field_type' => 'hidden', 'default' => $id_category); $channels_array = $this->channel->get_sites_channels(array('fields' => 'id_site_channel, channels.ad_type, channels.name as channel_name,' . ' sites.url as site_url, sites.id_site,' . ' channels.id_channel, channels.id_dimension, dimensions.width,' . ' dimensions.height, SUM(impressions) as impressions', 'category_id_filter' => $id_category, 'show_deleted_channels' => false, 'order_by' => $this->table_builder->sort_field, 'order_direction' => $this->table_builder->sort_direction, 'hide_wo_programs' => true, 'date_filter' => data_range(array('mode' => 'select', 'period' => 'lastmonth')), 'status' => 'active')); } else { $channels_array = array(); } break; case 'by_price': $price = $this->input->post('price'); if ($price) { $price = type_cast($price, 'float'); } else { $price = 0; } $price_program = $this->input->post('price_program'); $ads_type = $this->input->post('ads_type'); if ($price && $price_program) { $form_data['fields']['price'] = array('id_field_type' => 'positive_float', 'form_field_type' => 'hidden', 'default' => type_to_str($price, 'float')); $form_data['fields']['price_program'] = array('id_field_type' => 'string', 'form_field_type' => 'hidden', 'default' => $price_program); $form_data['fields']['ads_type'] = array('id_field_type' => 'string', 'form_field_type' => 'hidden', 'default' => $ads_type); $channels_array = $this->channel->get_sites_channels(array('fields' => 'id_site_channel, channels.ad_type, channels.name as channel_name, ' . 'sites.url as site_url, sites.id_site, channels.id_channel, ' . 'channels.id_dimension, dimensions.width, dimensions.height, ' . 'SUM(impressions) as impressions', 'show_deleted_channels' => false, 'order_by' => $this->table_builder->sort_field, 'order_direction' => $this->table_builder->sort_direction, 'price_filter' => array('price' => $price, 'price_program' => $price_program, 'ads_type' => $ads_type), 'hide_wo_programs' => true, 'date_filter' => data_range(array('mode' => 'select', 'period' => 'lastmonth')))); } else { $channels_array = array(); } break; } //установка атрибутов таблицы $this->table_builder->add_attribute('class', 'xTable'); //or set style here if (is_null($channels_array)) { $channels_array = array(); } $data_rows_conut = sizeof($channels_array); $this->table_builder->insert_empty_cells = false; $row_counter = 1; $site_id = ''; for ($i = 0; $i < $data_rows_conut; $i++) { if (!$this->channel_program->get_default_program(array('id_site_channel' => $channels_array[$i]['id_site_channel']))) { continue; } if ($site_id != $channels_array[$i]['id_site']) { $this->table_builder->set_cell_content($row_counter, 0, array('src' => $this->site_url . 'images/pixel.gif', 'onclick' => 'top.SwitchExpander(' . $channels_array[$i]['id_site'] . ',this)', 'extra' => 'class="minus"'), 'image'); $this->table_builder->cell($row_counter, 0)->add_content(__('Site') . ': <span class="green i">„' . $channels_array[$i]['site_url'] . '“</span>'); $this->table_builder->cell($row_counter, 0)->add_attribute('colspan', 15); $this->table_builder->add_row_attribute($row_counter, 'class', 'group'); $site_id = $channels_array[$i]['id_site']; $row_counter++; } $this->table_builder->set_cell_content($row_counter, 0, type_to_str($channels_array[$i]['channel_name'], 'encode')); $allowedTypes = explode(',', $channels_array[$i]['ad_type']); $this->table_builder->set_cell_content($row_counter, 1, ''); if (in_array(Sppc_Channel::AD_TYPE_TEXT, $allowedTypes)) { $ico_path = $this->site_url . 'images/smartppc6/icons/script_code.png'; $hint_title = __('Text Ad') . ' (' . $channels_array[$i]['width'] . '×' . $channels_array[$i]['height'] . ')'; $img_prefix = 'txt_'; $this->table_builder->cell($row_counter, 1)->add_content(array('src' => $ico_path, 'extra' => 'title="' . $hint_title . '" href="' . $this->site_url . 'images/dimensions_preview/' . $img_prefix . $channels_array[$i]['id_dimension'] . '.png" class="tooltip"'), 'image'); } if (in_array(Sppc_Channel::AD_TYPE_IMAGE, $allowedTypes)) { $ico_path = $this->site_url . 'images/smartppc6/icons/image.png'; $hint_title = __('Image Ad') . ' (' . $channels_array[$i]['width'] . '×' . $channels_array[$i]['height'] . ')'; $img_prefix = 'img_'; $this->table_builder->cell($row_counter, 1)->add_content(array('src' => $ico_path, 'extra' => 'title="' . $hint_title . '" href="' . $this->site_url . 'images/dimensions_preview/' . $img_prefix . $channels_array[$i]['id_dimension'] . '.png" class="tooltip"'), 'image'); } $this->table_builder->cell($row_counter, 1)->add_content($channels_array[$i]['width'] . '×' . $channels_array[$i]['height'], '', '<br/> '); $program_type = ""; $min_volume_cpm = ""; $min_volume_flat_rate = ""; if (!is_null($channels_array[$i]['min_cpm_volume'])) { $program_type .= __('CPM'); $this->table_builder->set_cell_content($row_counter, 3, type_to_str($channels_array[$i]['min_cpm_volume'], 'integer')); if (in_array(Sppc_Channel::AD_TYPE_TEXT, $allowedTypes)) { $this->table_builder->set_cell_content($row_counter, 4, type_to_str($channels_array[$i]['min_cpm_cost_text'], 'money')); } else { $this->table_builder->set_cell_content($row_counter, 4, '—'); } if (in_array(Sppc_Channel::AD_TYPE_IMAGE, $allowedTypes) && $channels_array[$i]['min_cpm_cost_image'] > 0) { $this->table_builder->set_cell_content($row_counter, 6, type_to_str($channels_array[$i]['min_cpm_cost_image'], 'money')); } else { $this->table_builder->set_cell_content($row_counter, 6, '—'); } } else { $program_type .= '—'; $this->table_builder->set_cell_content($row_counter, 3, '—'); $this->table_builder->set_cell_content($row_counter, 4, '—'); $this->table_builder->set_cell_content($row_counter, 6, '—'); } if (!is_null($channels_array[$i]['min_flat_rate_volume'])) { $program_type .= ' / ' . __('Flat Rate'); $this->table_builder->set_cell_content($row_counter, 8, type_to_str($channels_array[$i]['min_flat_rate_volume'], 'integer')); if (in_array(Sppc_Channel::AD_TYPE_TEXT, $allowedTypes)) { $this->table_builder->set_cell_content($row_counter, 9, type_to_str($channels_array[$i]['min_flat_rate_cost_text'], 'money')); } else { $this->table_builder->set_cell_content($row_counter, 9, '—'); } if (in_array(Sppc_Channel::AD_TYPE_IMAGE, $allowedTypes) && $channels_array[$i]['min_flat_rate_cost_image'] > 0) { $this->table_builder->set_cell_content($row_counter, 11, type_to_str($channels_array[$i]['min_flat_rate_cost_image'], 'money')); } else { $this->table_builder->set_cell_content($row_counter, 11, '—'); } } else { $program_type .= ' / —'; $this->table_builder->set_cell_content($row_counter, 8, '—'); $this->table_builder->set_cell_content($row_counter, 9, '—'); $this->table_builder->set_cell_content($row_counter, 11, '—'); } $this->table_builder->set_cell_content($row_counter, 2, $program_type); $this->table_builder->set_cell_content($row_counter, 13, type_to_str($channels_array[$i]['impressions'], 'impressions')); $this->table_builder->set_cell_content($row_counter, 14, array('name' => __('Add'), 'href' => '#', 'extra' => 'value="{@Add@}" title="{@Add@}" class="guibutton floatl ico ico-plusgreen" jframe="no" onclick="return addSiteChannelToGroup(' . $channels_array[$i]['id_site_channel'] . ');"'), 'link'); $this->table_builder->add_row_attribute($row_counter, 'id', "tr{$channels_array[$i]['id_site']}"); $this->table_builder->add_row_attribute($row_counter, 'id_site_channel', $channels_array[$i]['id_site_channel']); $row_counter++; } if (0 == $data_rows_conut) { $this->table_builder->set_cell_content(1, 0, __('Records not found')); $this->table_builder->cell(1, 0)->add_attribute('colspan', 15); $this->table_builder->cell(1, 0)->add_attribute('class', 'nodata'); } // Устанавливаем возможность выбора колонок $this->table_builder->use_select_columns(); $invariable_columns = array(0, 1, 2, 14); $this->table_builder->set_invariable_columns($invariable_columns); $channels_table = $this->table_builder->get_sort_html(); $this->template = "common/parent/jq_iframe.html"; $form_content = $this->form->get_form_content('create', $form_data, $this->input, $this); $form_content = str_replace('<%CHANNELS_TABLE%>', $channels_table, $form_content); $form_content = str_replace('<%COLUMNS%>', $this->table_builder->get_columns_html(), $form_content); $this->_set_content($form_content); $this->_display(); }
/** * Отображение страницы с предпросмотром созданных объявлений * * @param string $campaign_type тип создаваемой кампании */ public function index($campaign_type) { $this->set_campaign_type($campaign_type); $this->setCurrentStep(uri_string()); $this->new_campaign->init_storage($this->id_xml); $error_message = ''; // Нужно ли переходить на следующий шаг? if (false !== $this->input->post('complete')) { // Проверяем, все ли нормально у кампании? $error_message = $this->new_campaign->check_ads(); if (empty($error_message)) { // Переходим на следующий шаг redirect($this->get_next_step_controller()); } } $action = $this->input->post('form_action'); if ($action) { switch ($action) { case 'delete': $id_ad = $this->input->post('id'); if ($id_ad) { $this->new_campaign->del_ad($id_ad, 'textcode'); } break; } $this->new_campaign->save_data(); } $ads_list = $this->new_campaign->get_ads_list(); $ads_preview = ''; /* Выбранные места */ $choosen_places = $this->new_campaign->get_places(); // Нужно получить названия и цвета $places_data = array('place' => 'sites', 'name' => 'Content Network', 'color' => '000000'); $choosen_places_view = ''; $this->load->model('dimension'); $places_errors = array(); foreach ($ads_list as $ad_id => $ad) { if ('text' == $ad->ad_type) { // Подгружаем стили дефолтной color scheme $this->db->select('cs.*, ft.name title_font_name, ft2.name text_font_name, ft3.name url_font_name', false); $this->db->from('color_schemes cs'); $this->db->join('fonts ft', 'ft.id_font = cs.title_id_font'); $this->db->join('fonts ft2', 'ft2.id_font = cs.text_id_font'); $this->db->join('fonts ft3', 'ft3.id_font = cs.url_id_font'); $query = $this->db->get(); $row = $query->row(); $ad_preview = $this->parser->parse('common/text_ad_example.html', array('TITLE' => type_to_str($ad->title, 'encode'), 'DESCRIPTION' => type_to_str($ad->description1, 'encode'), 'DESCRIPTION2' => type_to_str($ad->description2, 'encode'), 'DISPLAY_URL' => $ad->display_url, 'DESTINATION_URL' => $ad->destination_protocol . "://" . $ad->destination_url, 'BACKGROUND_COLOR' => $row->background_color, 'BORDER_COLOR' => $row->border_color, 'TITLE_COLOR' => $row->title_color, 'TITLE_FONT_NAME' => $row->title_font_name, 'TITLE_FONT_SIZE' => $row->title_font_size, 'TITLE_FONT_STYLE' => $row->title_font_style, 'TITLE_FONT_WEIGHT' => $row->title_font_weight, 'TEXT_COLOR' => $row->text_color, 'TEXT_FONT_NAME' => $row->text_font_name, 'TEXT_FONT_SIZE' => $row->text_font_size, 'TEXT_FONT_STYLE' => $row->text_font_style, 'TEXT_FONT_WEIGHT' => $row->text_font_weight, 'URL_COLOR' => $row->url_color, 'URL_FONT_NAME' => $row->url_font_name, 'URL_FONT_SIZE' => $row->url_font_size, 'URL_FONT_STYLE' => $row->url_font_style, 'URL_FONT_WEIGHT' => $row->url_font_weight), FALSE); } elseif ('image' == $ad->ad_type) { list($img_w, $img_h, $type, $attr) = getimagesize($this->config->item('path_to_campaign_creation_images') . $ad->image_id); if (13 == $type) { //Для флэша используем специальный шаблон $ad_preview = $this->parser->parse('common/image_ad_swf_example.html', array('TITLE' => type_to_str($ad->title, 'encode'), 'ID_IMAGE' => $ad->image_id, 'ID_SWF_CONTAINER' => str_replace('.', '', $ad->image_id), 'IMG_W' => $img_w, 'IMG_H' => $img_h, 'BGCOLOR' => $ad->bgcolor, 'DISPLAY_URL' => $ad->display_url, 'DESTINATION_URL' => $ad->destination_protocol . "://" . $ad->destination_url), FALSE); } else { $ad_preview = $this->parser->parse('common/image_ad_example.html', array('TITLE' => type_to_str($ad->title, 'encode'), 'ID_IMAGE' => $ad->image_id, 'DISPLAY_URL' => $ad->display_url, 'DESTINATION_URL' => $ad->destination_protocol . "://" . $ad->destination_url), FALSE); } } elseif ('richmedia' == $ad->ad_type) { // dimension of iFrame $this->load->model('dimension'); $dim = $this->dimension->get_info($ad->id_dimension); $ad_preview = $this->parser->parse('common/richmedia_ad_example.html', array('RICH_CONTENT' => $ad->rich_content, 'IFRAME_SRC' => base_url() . 'advertiser/create_campaign_step_preview_ads/previewAd/' . $ad_id, 'WIDTH' => $dim->width, 'HEIGHT' => $dim->height), FALSE); } // Warnings ====================== $warnings = array(); $messages = array(); foreach ($places_data as $place) { if (in_array($place['place'], $choosen_places)) { $choosen_places_view[] = '<span class="place_name" style="color:#' . $place['color'] . '">' . $place['name'] . '</span>'; if (!$this->dimension->checkPlaceSuitability($place['place'], array($ad))) { $messages[] = array('MESSAGE' => '<span class="place_name" style="color:#' . $place['color'] . '">' . $place['name'] . '</span> ' . __('doesn\'t support this format.')); } } } if (count($messages)) { $warnings = array(array('MESSAGES' => $messages)); } // Warning END =================== $ads_preview .= $this->parser->parse('advertiser/manage_ads/campaigns/creation/preview_ads/ad_box.html', array('AD_PREVIEW' => $ad_preview, 'AD_ID' => $ad_id, 'WARNINGS' => $warnings), FALSE); } $data = array('ERROR_MESSAGE' => '' != $error_message ? $this->parser->parse('advertiser/manage_ads/campaigns/creation/preview_ads/error.html', array('ERROR' => $error_message), FALSE) : '', 'NEXT_CONTROLLER_URL' => $this->get_next_step_controller(), 'EDIT_ADS_URL' => $this->get_previous_step_controller(), 'ADD_MORE_ADS_URL' => $this->get_previous_step_controller(), 'ADS_PREVIEW' => $ads_preview, 'CAMPAIGN_SCHEME' => $this->load->view('advertiser/manage_ads/campaigns/campaign_scheme.html', '', TRUE)); $this->_set_content($this->parser->parse('advertiser/manage_ads/campaigns/creation/preview_ads/body.html', $data, FALSE)); $this->_display(); }
/** * возвращает суммарную статистику по объявлениям выбранной группы * * @param integer $id_group уникальный код выбранной группы * @param array $range массив с двумя датами - начала и конце периода ('from', 'to') * @return array массив со статистикой группы (spent, clicks, impressions, ctr) */ public function summary($id_group, $range) { $res = $this->db->select_sum('spent')->select_sum('clicks')->select_sum('impressions')->select('COUNT(id_group) AS cnt')->from('stat_groups')->where('id_group', $id_group)->where('stat_date >=', type_to_str($range['from'], 'databasedate'))->where('stat_date <=', type_to_str($range['to'], 'databasedate'))->get(); if ($res->num_rows()) { $row = $res->row(); $summary = array('spent' => $row->spent, 'clicks' => $row->clicks, 'impressions' => $row->impressions, 'cnt' => $row->cnt); } else { $summary = array('spent' => 0, 'clicks' => 0, 'impressions' => 0, 'cnt' => 0); } $summary['ctr'] = $summary['impressions'] ? $summary['clicks'] * 100 / $summary['impressions'] : 0; $this->db->select('COUNT(DISTINCT id_ad) AS ads,' . ' COUNT(DISTINCT sc.id_site_channel) AS site_channels,' . ' SUM(gsc.status="unpaid" AND s.status="active" AND c.status="active" AND sc.status="active") AS unpaid,' . ' SUM(gsc.status="trouble" AND s.status="active" AND c.status="active" AND sc.status="active") AS trouble', FALSE); $this->db->from('groups'); $this->db->join('ads', 'groups.id_group = ads.id_group AND ads.status!="deleted"', 'LEFT'); $this->db->join('group_site_channels gsc', 'groups.id_group = gsc.id_group AND gsc.status!="deleted"', 'LEFT'); $this->db->join('site_channels sc', 'gsc.id_site_channel = sc.id_site_channel AND sc.status!="deleted"', 'LEFT'); $this->db->join('sites s', 'sc.id_site = s.id_site', 'LEFT'); $this->db->join('channels c', 'sc.id_channel = c.id_channel', 'LEFT'); $this->db->where('groups.id_group', $id_group); $res = $this->db->get(); $row = $res->row(); $summary['ads'] = $row->ads; $summary['site_channels'] = $row->site_channels; $summary['unpaid'] = $row->unpaid > 0; $summary['trouble'] = $row->trouble > 0; return $summary; }
/** * функция вызываемая по умолчанию, выводит таблицу кампаний * * @param integer $id_campaign уникальный код кампании, содержащей группы объявлений * @return ничего не возвращает */ public function index($code_campaign) { $this->id_campaign = type_cast($code_campaign, 'textcode'); $this->load->library('form'); $this->load->helper('periods'); $form = array('id' => 'groups', 'name' => 'manadsgroups_form', 'view' => 'advertiser/manage_ads/groups/table.html', 'redirect' => 'advertiser/manage_ads', 'no_errors' => 'true', 'vars' => array('DATEFILTER' => period_html('manadsgroups')), 'fields' => array('filt' => array('id_field_type' => 'string', 'form_field_type' => 'select', 'options' => array('all' => __('all'), 'active' => __('pl_active'), 'paused' => __('pl_paused'))))); data_range_fields($form, 'select', 'alltime'); $html = $this->form->get_form_content('modify', $form, $this->input, $this); $this->load->model('groups'); $this->_actions($this->input->post('manadsgroups_action')); $this->load->library('Table_Builder'); $this->table_builder->clear(); $this->table_builder->insert_empty_cells = true; $this->table_builder->init_sort_vars('manadsgroups', 'id_campaign', 'asc'); $this->load->model('pagination_post'); $this->pagination_post->set_form_name('manadsgroups'); $total_function = 'total'; $total = $this->groups->{$total_function}($this->id_campaign, $this->temporary['manadsgroups_filt'], $this->date_range); $this->pagination_post->set_total_records($total['cnt']); $this->pagination_post->read_variables('manadsgroups', 1, $this->global_variables->get('GroupsPerPage')); $select_function = 'select'; $groups = $this->groups->{$select_function}($this->id_campaign, $this->temporary['manadsgroups_page'], $this->temporary['manadsgroups_per_page'], $this->table_builder->sort_field, $this->table_builder->sort_direction, $this->temporary['manadsgroups_filt'], $this->date_range); $row = 0; //build column map $colIndex = 0; $colMap = array('chkbox' => $colIndex++, 'id' => $colIndex++, 'name' => $colIndex++, 'status' => $colIndex++, 'ads' => $colIndex++, 'siteChannels' => $colIndex++, 'spent' => $colIndex++, 'impressions' => $colIndex++, 'clicks' => $colIndex++, 'ctr' => $colIndex++, 'action' => $colIndex++); // register additional columns from plugins foreach ($this->_hooks as $hookObj) { $colMap = $hookObj->extendColumnMap($colMap); } // create columns $this->table_builder->set_cell_content($row, $colMap['chkbox'], array('name' => 'checkAll', 'extra' => 'onclick="return select_all(\'manadsgroups\', this)"'), 'checkbox'); $this->table_builder->sorted_column($colMap['id'], "id_group", "ID", "asc"); $this->table_builder->sorted_column($colMap['name'], "name", "Group Name", "asc"); $this->table_builder->sorted_column($colMap['status'], "status", "Current Status", "asc"); $this->table_builder->sorted_column($colMap['ads'], "ads", "Ads", "desc"); $col_name = "Sites/Channels"; $this->table_builder->sorted_column($colMap['siteChannels'], "site_channels", $col_name, "desc"); $this->table_builder->set_cell_content($row, $colMap['spent'], __("Spent")); $this->table_builder->set_cell_content($row, $colMap['impressions'], __("Impressions")); $this->table_builder->set_cell_content($row, $colMap['clicks'], __("Clicks")); $this->table_builder->set_cell_content($row, $colMap['ctr'], __("CTR")); $this->table_builder->set_cell_content($row, $colMap['action'], __('Action')); // create additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->createColumns($colMap, $this->table_builder); } $this->table_builder->add_row_attribute($row, 'class', 'th'); //прописывание стилей для ячеек $this->table_builder->add_col_attribute($colMap['chkbox'], 'class', '"chkbox"'); $this->table_builder->add_col_attribute($colMap['id'], 'class', '"w20"'); $this->table_builder->add_col_attribute($colMap['status'], 'class', '"w100 center"'); $this->table_builder->add_col_attribute($colMap['ads'], 'class', '"w50 right"'); $this->table_builder->add_col_attribute($colMap['siteChannels'], 'class', '"w100 right"'); $this->table_builder->add_col_attribute($colMap['spent'], 'class', '"w100 right"'); $this->table_builder->add_col_attribute($colMap['impressions'], 'class', '"w100 right"'); $this->table_builder->add_col_attribute($colMap['clicks'], 'class', '"w50 right"'); $this->table_builder->add_col_attribute($colMap['ctr'], 'class', '"w50 right"'); $this->table_builder->add_col_attribute($colMap['action'], 'class', '"nowrap center"'); // add styles for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->defineColumnStyles($colMap, $this->table_builder); } $this->table_builder->add_attribute('class', 'xTable'); $clone_icon = __('Edit'); $row++; $page_total = array('ads' => 0, 'sites_channels' => 0, 'spent' => 0, 'impressions' => 0, 'clicks' => 0); // register additional per page statistic fields foreach ($this->_hooks as $hookObj) { $page_total = $hookObj->registerPerPageStatisticFields($page_total); } foreach ($groups as $id_group => $group) { // calculate per page statistic $page_total['ads'] += $group['ads']; $page_total['sites_channels'] += $group['site_channels']; $page_total['spent'] += $group['spent']; $page_total['impressions'] += $group['impressions']; $page_total['clicks'] += $group['clicks']; // calculate per page statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $page_total = $hookObj->calculatePerPageStatistic($page_total, $group); } $code = type_to_str($id_group, 'textcode'); // checkbox $this->table_builder->set_cell_content($row, $colMap['chkbox'], array('name' => 'id_groups[]', 'value' => $code, 'extra' => "id=chk{$row} onclick=\"checktr('chk{$row}','tr{$row}')\""), 'checkbox'); // id $this->table_builder->set_cell_content($row, $colMap['id'], $id_group); // name $this->table_builder->set_cell_content($row, $colMap['name'], array('name' => limit_str_and_hint($group['name'], 30), 'href' => "#select_group", 'extra' => "jframe='no' onclick='return top.show_ads(\"{$code}\",\"\");'"), 'link'); // status $this->table_builder->set_cell_content($row, $colMap['status'], __('grp_' . $group['status'])); // ads $this->table_builder->set_cell_content($row, $colMap['ads'], array('name' => type_to_str($group['ads'], 'integer'), 'href' => "#select_ads", 'extra' => "jframe='no' onclick='return top.show_ads(\"{$code}\", \"ads\");'"), 'link'); // site/channels $this->table_builder->set_cell_content($row, $colMap['siteChannels'], array('name' => type_to_str($group['site_channels'], 'integer'), 'href' => "#select_sitechannels", 'extra' => "jframe='no' onclick='return top.show_ads(\"{$code}\", \"channels\");'"), 'link'); // spent $this->table_builder->set_cell_content($row, $colMap['spent'], type_to_str($group['spent'], 'money')); // impressions $this->table_builder->set_cell_content($row, $colMap['impressions'], type_to_str($group['impressions'], 'integer')); // clicks $this->table_builder->set_cell_content($row, $colMap['clicks'], type_to_str($group['clicks'], 'integer')); // ctr $this->table_builder->set_cell_content($row, $colMap['ctr'], type_to_str($group['ctr'], 'procent')); // action $this->table_builder->set_cell_content($row, $colMap['action'], array('name' => $clone_icon, 'href' => "#edit_group", 'extra' => "jframe='no' class='guibutton floatl ico ico-edit' value='{$clone_icon}' title='{$clone_icon}' onclick='top.editGroup(\"{$code_campaign}\",\"{$code}\");'"), 'link'); // render additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderRow($row, $colMap, $group, $this->table_builder); } // add id attribute to the table row $this->table_builder->add_row_attribute($row, 'id', "tr{$row}"); $row++; } if (0 == count($groups)) { $this->table_builder->insert_empty_cells = false; $this->table_builder->set_cell_content($row, 0, ' ' . __('Records not found')); $this->table_builder->cell($row, 0)->add_attribute('class', 'nodata'); $this->table_builder->cell($row, 0)->add_attribute('colspan', count($colMap)); } else { // render per page statistic row $this->table_builder->set_cell_content($row, $colMap['name'], __("Page total")); $this->table_builder->set_cell_content($row, $colMap['ads'], type_to_str($page_total['ads'], 'integer')); $this->table_builder->set_cell_content($row, $colMap['siteChannels'], type_to_str($page_total['sites_channels'], 'integer')); $this->table_builder->set_cell_content($row, $colMap['spent'], type_to_str($page_total['spent'], 'money')); $this->table_builder->set_cell_content($row, $colMap['impressions'], type_to_str($page_total['impressions'], 'integer')); $this->table_builder->set_cell_content($row, $colMap['clicks'], type_to_str($page_total['clicks'], 'integer')); $ctr = $page_total['impressions'] ? $page_total['clicks'] / $page_total['impressions'] * 100 : 0; $this->table_builder->set_cell_content($row, $colMap['ctr'], type_to_str($ctr, 'procent')); $this->table_builder->clear_row_attributes($row); $this->table_builder->add_row_attribute($row, 'class', 'pagetotal'); // render per page statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderPageStatisticRow($row, $colMap, $page_total, $this->table_builder); } // render summary statistic row $row++; $this->table_builder->set_cell_content($row, $colMap['name'], __("Total")); $this->table_builder->set_cell_content($row, $colMap['ads'], type_to_str($total['ads'], 'integer')); $this->table_builder->set_cell_content($row, $colMap['siteChannels'], type_to_str($total['site_channels'], 'integer')); $this->table_builder->set_cell_content($row, $colMap['spent'], type_to_str($total['spent'], 'money')); $this->table_builder->set_cell_content($row, $colMap['impressions'], type_to_str($total['impressions'], 'integer')); $this->table_builder->set_cell_content($row, $colMap['clicks'], type_to_str($total['clicks'], 'integer')); $ctr = $total['impressions'] ? $total['clicks'] / $total['impressions'] * 100 : 0; $this->table_builder->set_cell_content($row, $colMap['ctr'], type_to_str($ctr, 'procent')); $this->table_builder->clear_row_attributes($row); $this->table_builder->add_row_attribute($row, 'class', 'alltotal'); // render summary statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderSummaryRow($row, $colMap, $total, $this->table_builder); } } // Устанавливаем возможность выбора колонок $this->table_builder->use_select_columns(); $invariable_columns = array($colMap['id'], $colMap['name'], $colMap['action']); $this->table_builder->set_invariable_columns($invariable_columns); $html = str_replace('<%GROUPS%>', $this->table_builder->get_sort_html(), $html); $html = str_replace('<%PAGINATION%>', $this->pagination_post->create_form(), $html); $buttons = $this->load->view('advertiser/manage_ads/groups/buttons.html', '', TRUE); $buttons = str_replace('<%CAMPAIGN%>', $code_campaign, $buttons); $html = str_replace('<%BUTTONST%>', str_replace('<%ID%>', 'top_', $buttons), $html); $html = str_replace('<%BUTTONSB%>', str_replace('<%ID%>', 'bottom_', $buttons), $html); $html = str_replace('<%COLUMNS%>', $this->table_builder->get_columns_html(), $html); $this->_set_content($html); $this->_display(); }
/** * Метод получения текстового превью рекламного объявления * * @param int $id_ad * @return string */ function get_text_preview($id_ad) { $html = ''; $this->db->select('id_ad, name, title, description, description2, display_url, click_url, protocol')->from('ads')->join('ad_types', 'ads.id_ad_type = ad_types.id_ad_type')->where('id_ad', $id_ad)->limit(1); $query = $this->db->get(); if (0 < $query->num_rows()) { $row = $query->row(); $data = array('CODE' => type_to_str($id_ad, 'textcode'), 'NAME' => $row->name, 'ORIG_DESTINATION_URL' => type_to_str($row->click_url, "encode"), 'DESTINATION_URL' => type_to_str(limit_str($row->click_url, 45), "encode"), 'TITLE' => type_to_str($row->title, "encode"), 'DESCRIPTION' => type_to_str($row->description, "encode"), 'DESCRIPTION2' => type_to_str($row->description2, "encode"), 'DISPLAY_URL' => type_to_str($row->display_url, "encode"), 'PROTOCOL' => $row->protocol, 'SHOW_DESCRIPTION' => 'text' == $row->name ? array(array()) : array()); $html = $this->parser->parse('common/ad_example.html', $data, TRUE); } return $html; }
/** * ограничение строки по максимальной длине и добавление аттрибута title для всплывающей подсказки * '<span title="full string length">limited stri...</span>' * * @param string $str значение поля * @param int $limit максимальная длина строки * @return string результат ограничения строки */ function limit_str_and_hint($str, $limit = 30) { //return '<span title="'.type_to_str($str,'encode').'">'.limit_str($str,$limit).'</span>'; // return '<span title="'.type_to_str($str,'encode').'" class="truncate" max_len="'.$limit.'">'.type_to_str($str,'encode').'</span>'; $cutstr = limit_str($str, $limit); return '<span title="' . type_to_str($str, 'encode') . '">' . type_to_str($cutstr, 'encode') . '</span>'; }
/** * работа с формой и вывод на экран результатов работы, * для получения/сохранения данных для полей формы * вызывает либо методы модели данных * - load($id), create($fields), save($id, $fields), * либо, если модель не задана, методы вызывавшего класа * - _load($id), _create($fields), _save($id, $fields), * * @param string $mode режим работы с формой * "create" - создание новой записи данных * "modify" - изменение существующей записи данных * "save" - проверка и сохранение записи данных * "filter" - форма фильтрации, изменения объектов нет * @param array $form описание формы и ее полей * $form = array( * "name" => "formname", имя формы в HTML коде * "id" => "id_record", переданный код записи данных, "" - новая запись * "model" => "account", модель для работы с данными формы, при отсутствии - используются методы _load и _save * "view" => "form_test", отображение формы * "vars" => array ("tag" => "value"), (опционально) массив с переменными для отображения * "redirect" => "controller", если задан, то при успехе вызывается контроллер, если не задан - success_view * "success_view" => "form_test_success", отображение при успешном изменении данных (если не задан redirect) * "no_errors" => "true", (опционально) не выводить текст ошибки под неправильными полями * "action" => 'http://site.com/page.php' (опционально) перебивает сгенерированный action на заданный * "fields" => array( описание полей формы * "field_name" => array( имя поля * "id_field_type" => "string", тип данных поля (string, int, money, procent, date, time, date_time, float, bool) * "form_field_type" => "textarea", тип HTML поля (text, password, hidden, file, textarea, checkbox, radio, select) * "validation_rules" => "required", (опционально) правила проверки поля (required, matches, min_length, max_length, exact_length, alpha, alpha_numeric, alpha_dash, numeric, integer, valid_email, valid_ip, valid_base64) * "options" => array( (опционально) либо модель списка, либо массив со значениями элементов списка * "value" => "text", (только для массива) список значений и строк * ... * ), * "params" => array( (только для модели, опционально) список параметров для извлечения списка моделью * "name" => "value", (для параметров) список имен параметров и значений * ... * ), * "default" => "default", (опционально) значение поля по умолчанию, * если NULL данные при чтении формы не обновляются * "max" => 32 (опционально для text) максимальная длина вводимой строки * ), * ... * ), * "kill" => array( список удаляемых блоков в HTML коде * "id_div", ... параметр id блока div, который необходимо удалить * ) * ); * @param array $input массив с входными параметрами контроллера * @param object $caller объект контроллера, вызвавшего данную модель * @return ничего не возвращвет */ public function show_form($mode, &$form, $input, $caller) { $id = array_key_exists("id", $form) ? $form["id"] : ""; if ($input->post("form_mode")) { $old_mode = $mode; $mode = $input->post("form_mode"); } $active_form = ''; if ($input->post('active_form')) { $active_form = $input->post('active_form'); } $CI =& get_instance(); $CI->load->library("Form_Setter"); $error = ""; $field_errors = array(); $fields = array(); $rules = array(); if ("save" == $mode && $active_form == $form['name']) { foreach ($form["fields"] as $fname => $field) { //$fields[$fname] = isset($fields[$fname]) ? $fields[$fname].', ' : ''; if (array_key_exists('id_field_type', $form["fields"][$fname])) { $fields[$fname] = type_cast($input->post($fname), $form["fields"][$fname]["id_field_type"]); } else { $fields[$fname] = $input->post($fname); } $form["fields"][$fname]["default"] = $input->post($fname); /** * Всё те же dirty hacks для datepickera * @author Semerenko */ /* if(in_array($fname,array('from','to'))){ $form['fields'][$fname]['default'] = date('m.d.Y', type_cast($form["fields"][$fname]["default"],'date')); }*/ if (array_key_exists("validation_rules", $field)) { $rules_arr = explode('|', $field["validation_rules"]); foreach ($rules_arr as &$rules_arr_val) { switch ($rules_arr_val) { case "date": $rules_arr_val = "callback_check_date"; break; case "datetime": $rules_arr_val = "callback_check_datetime"; break; case "hostname": $rules_arr_val = "callback_check_hostname"; break; case "url": $rules_arr_val = "callback_check_url"; break; case "float": $rules_arr_val = "callback_check_float"; break; case "positive": $rules_arr_val = "callback_check_positive"; break; case "non_negative": $rules_arr_val = "callback_check_non_negative"; break; case "int": case "integer": $rules_arr_val = "callback_check_integer"; break; case "ip": $rules_arr_val = "callback_check_ip"; break; case "ip_part": $rules_arr_val = "callback_check_ip_part"; break; case "ip_re": $rules_arr_val = "callback_check_ip_re"; break; default: if (0 === strpos($rules_arr_val, 'min_val') || 0 === strpos($rules_arr_val, 'max_val') || 0 === strpos($rules_arr_val, 'interval') || 0 === strpos($rules_arr_val, 'float') || 0 === strpos($rules_arr_val, 'full_url')) { $rules_arr_val = "callback_check_" . $rules_arr_val; } } $rules_arr_val = str_replace('md5', 'callback_check_password', $rules_arr_val); } $rules[$fname] = implode('|', $rules_arr); } } $CI->load->library('validation'); $CI->validation->set_rules($rules); $int_validator = count($rules) == 0 || $CI->validation->run(); $ext_validator = TRUE; if (method_exists($caller, '_validator')) { $ext_validator = $caller->_validator($fields, $int_validator); } if ($ext_validator && $int_validator) { $error = ''; if ("save" == $mode) { if (array_key_exists("model", $form)) { $CI->load->model($form["model"]); if ("" == $id) { $error = $CI->{$form}["model"]->create($fields); } else { $error = $CI->{$form}["model"]->save($id, $fields); } } else { if ("" == $id) { $error = $caller->_create($fields); } else { $error = $caller->_save($id, $fields); } } } if ("" == $error) { if (array_key_exists("redirect", $form)) { redirect($form["redirect"]); } else { $CI->load->view($form["success_view"]); return; } } } else { foreach ($form["fields"] as $fname => $field) { if (isset($CI->validation->{$fname . "_error"})) { if ($CI->validation->{$fname . "_error"} != "") { $field_errors[$fname] = $CI->validation->{$fname . "_error"}; } } } $error = "You must fill all required fields!"; //$CI->validation->error_string; // call form validation error callback: if (method_exists($caller, '_validationFailed')) { $caller->_validationFailed($fields, $field_errors); } } } if ("modify" == $mode || 'save' == $mode && $active_form != $form['name'] && $old_mode == "modify") { if (array_key_exists("model", $form)) { $CI->load->model($form["model"]); $fields = $CI->{$form}["model"]->load($id); } else { $fields = $caller->_load($id); } foreach ($form["fields"] as $fname => $field) { if (array_key_exists($fname, $fields)) { if (array_key_exists("default", $form["fields"][$fname]) && is_null($form["fields"][$fname]["default"])) { $form["fields"][$fname]["default"] = ""; } else { $form["fields"][$fname]["default"] = type_to_str($fields[$fname], $form["fields"][$fname]["id_field_type"]); /** * Для дэйтпикера dirty hack * Если это поля to & from, то их не нужно форматировать * @author Semerenko */ /* if(in_array($fname,array('to','from')) && $form["fields"][$fname]["id_field_type"] == 'date'){ // ничего не делать. А всё форматирование пусть будет в else. }else{ $form["fields"][$fname]["default"] = type_to_str($fields[$fname], $form["fields"][$fname]["id_field_type"]); } */ } } } } if (array_key_exists('vars', $form)) { $CI->form_setter->set_html($CI->parser->parse($form["view"], $form['vars'], TRUE)); } else { $CI->form_setter->set_html($CI->load->view($form["view"], '', TRUE)); } $CI->form_setter->use_form($form["name"]); if (isset($form['action'])) { $CI->form_setter->set_action($form['action']); } else { $CI->form_setter->set_action($CI->config->site_url($CI->uri->uri_string())); } foreach ($form["fields"] as $fname => $field) { switch ($field["form_field_type"]) { case "text": case "textarea": case "password": case "file": case "hidden": $text = ""; if (array_key_exists("default", $field)) { $text = $field["default"]; } $max = isset($field['max']) ? $field['max'] : NULL; $CI->form_setter->set_text($fname, $text, $max); break; case "checkbox": case "radio": if (array_key_exists("default", $field)) { $value = $field["default"]; if ("" != $value) { $CI->form_setter->set_state($fname, $value, TRUE); } } break; case "select": if (is_array($field["options"])) { $options = $field["options"]; } else { $options_model = $field["options"]; $CI->load->model($options_model, 'form_temp_model', TRUE); $params = array(); if (array_key_exists("params", $field)) { $params = $field["params"]; } $options = $CI->form_temp_model->get_list($params); $CI->load->unload_model('form_temp_model'); } $default = array_key_exists("default", $field) ? $field["default"] : NULL; $CI->form_setter->set_options($fname, $options, $default); break; } } if ("" != $id) { $CI->form_setter->add_hidden("id", $id); } if ($mode != "filter") { $CI->form_setter->add_hidden("form_mode", "save"); $CI->form_setter->add_hidden("active_form", $form['name']); } $CI->form_setter->set_error(__($error)); foreach ($field_errors as $fname => $ferror) { $matches = NULL; preg_match_all('/{@([\\S]*?)@}/', $ferror, $matches); foreach ($matches[1] as $sfname) { if (array_key_exists($sfname, $form["fields"])) { if (array_key_exists("display_name", $form["fields"][$sfname])) { $ferror = str_replace("{@{$sfname}@}", "'" . __($form["fields"][$sfname]["display_name"]) . "'", $ferror); } if (array_key_exists('no_errors', $form)) { $ferror = ''; } } } $CI->form_setter->set_field_error($fname, $ferror); } if (array_key_exists("kill", $form)) { $CI->form_setter->kill_blocks($form["kill"]); } $CI->output->set_output($CI->form_setter->get_html()); }
/** * создание и вывод HTML-кода для управления рекламодателями * * @return ничего не возвращает */ public function index() { $this->_set_title(implode(self::TITLE_SEP, array(__('Admin'), __('Manage Advertisers')))); $this->_set_help_index("manage_advertisers"); $this->load->library("form"); $this->load->helper('periods'); $form = array('name' => 'manageadvertisers_form', 'view' => 'admin/manage_advertisers/template.html', 'no_errors' => 'true', 'vars' => array('DATEFILTER' => period_html('manageadvertisers')), 'fields' => array('filt' => array('id_field_type' => 'string', 'form_field_type' => 'select', 'options' => array('all' => __('all'), 'active' => __('pl_active'), 'blocked' => __('pl_blocked'), 'deleted' => __('pl_deleted'), 'activation' => __('pl_unapproved'))), 'quicksearch' => array('id_field_type' => 'string', 'form_field_type' => 'text'))); $this->load->library("Plugins", array('path' => array('admin', 'manage_advertisers_global'), 'interface' => 'Sppc_Admin_ManageAdvertisers_GlobalHandlerInterface')); $form['vars']['PLUGIN_JS_FUNCTIONS'] = implode($this->plugins->run('get_js_functions_html', $this)); data_range_fields($form, 'select', 'today'); $html = $this->form->get_form_content('modify', $form, $this->input, $this); $this->load->model('advertisers'); $this->_actions($this->input->post('manageadvertisers_action')); $this->load->library('Table_Builder'); $this->table_builder->clear(); $this->table_builder->insert_empty_cells = true; $this->table_builder->init_sort_vars('manageadvertisers', 'id', 'asc'); $this->load->model('pagination_post'); $this->pagination_post->set_form_name('manageadvertisers'); // All pages total $total = $this->advertisers->total($this->temporary['manageadvertisers_filt'], $this->range, $this->temporary['manageadvertisers_quicksearch']); $this->pagination_post->set_total_records($total['cnt']); $this->pagination_post->read_variables('manageadvertisers', 1, $this->global_variables->get('AdvertisersPerPage')); $list = $this->advertisers->get($this->temporary['manageadvertisers_page'], $this->temporary['manageadvertisers_per_page'], $this->table_builder->sort_field, $this->table_builder->sort_direction, $this->temporary['manageadvertisers_filt'], $this->range, $this->temporary['manageadvertisers_quicksearch']); $col_index = 0; $col_alias = array('checkAll' => $col_index++); $col_alias['id'] = $col_index++; $col_alias['name'] = $col_index++; $col_alias['e_mail'] = $col_index++; $col_alias['creation_date'] = $col_index++; $col_alias['status'] = $col_index++; $col_alias['ballance'] = $col_index++; $col_alias['impressions'] = $col_index++; $col_alias['clicks'] = $col_index++; $col_alias['ctr'] = $col_index++; $col_alias['spent'] = $col_index++; $col_alias['action'] = $col_index++; $this->load->library("Plugins", array('path' => array('admin', 'manage_advertisers'), 'interface' => 'Sppc_Admin_ManageAdvertisers_Interface'), 'coupons_plugin'); $this->coupons_plugin->run('getAdditionalColumns', $col_alias); // register additional columns from plugins foreach ($this->_hooks as $hookObj) { $col_alias = $hookObj->extendColumnMap($col_alias); } $this->table_builder->set_cell_content(0, $col_alias['checkAll'], array('name' => 'checkAll', 'extra' => 'onclick="return select_all(\'manageadvertisers\', this)"'), 'checkbox'); $this->table_builder->sorted_column($col_alias['id'], "id", "ID", "asc"); $this->table_builder->sorted_column($col_alias['name'], "name", "Full Name", "asc"); $this->table_builder->sorted_column($col_alias['e_mail'], "e_mail", "E-Mail", "asc"); $this->table_builder->sorted_column($col_alias['creation_date'], "creation_date", "Join Date", "desc"); $this->table_builder->sorted_column($col_alias['status'], "status", "Status", "asc"); $this->table_builder->sorted_column($col_alias['ballance'], "ballance", "Ballance", "desc"); $this->table_builder->sorted_column($col_alias['impressions'], "impressions", "Impressions", "desc"); $this->table_builder->sorted_column($col_alias['clicks'], "clicks", "Clicks", "desc"); $this->table_builder->sorted_column($col_alias['ctr'], "ctr", "CTR", "desc"); $this->table_builder->sorted_column($col_alias['spent'], "spent", "Spent", "desc"); $this->table_builder->set_cell_content(0, $col_alias['action'], __("Action")); $this->table_builder->add_row_attribute(0, 'class', 'th'); $this->coupons_plugin->run('getAdditionalFields', $this->table_builder); // create additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->createColumns($col_alias, $this->table_builder); } //прописывание стилей для ячеек $this->table_builder->add_col_attribute($col_alias['checkAll'], 'class', '"chkbox"'); $this->table_builder->add_col_attribute($col_alias['id'], 'class', '"w20 chkbox"'); $this->table_builder->add_col_attribute($col_alias['creation_date'], 'class', '"w100 center"'); $this->table_builder->add_col_attribute($col_alias['status'], 'class', '"w100 center"'); $this->table_builder->add_col_attribute($col_alias['ballance'], 'class', '"right"'); $this->table_builder->add_col_attribute($col_alias['impressions'], 'class', '"right w100"'); $this->table_builder->add_col_attribute($col_alias['clicks'], 'class', '"w50 right"'); $this->table_builder->add_col_attribute($col_alias['ctr'], 'class', '"w50 right"'); $this->table_builder->add_col_attribute($col_alias['spent'], 'class', '"w50 right"'); $this->table_builder->add_col_attribute($col_alias['action'], 'class', '"center nowrap"'); // add styles for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->defineColumnStyles($col_alias, $this->table_builder); } $this->table_builder->add_attribute('class', 'xTable'); $this->coupons_plugin->run('setAdditionalStyle', $this->table_builder); // Page Total $page_total = array('balance' => 0, 'impressions' => 0, 'clicks' => 0, 'spent' => 0, 'bonus' => 0); // register additional per page statistic fields foreach ($this->_hooks as $hookObj) { $page_total = $hookObj->registerPerPageStatisticFields($page_total); } $row = 1; foreach ($list as $id_entity => $entity) { $code = type_to_str($id_entity, 'textcode'); // Calc total values $page_total['balance'] += $entity['ballance']; $page_total['impressions'] += $entity['impressions']; $page_total['clicks'] += $entity['clicks']; $page_total['spent'] += $entity['spent']; $page_total['bonus'] += $entity['bonus']; // calculate per page statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $page_total = $hookObj->calculatePerPageStatistic($page_total, $entity); } // checkbox $this->table_builder->set_cell_content($row, $col_alias['checkAll'], array('name' => 'id_entity[]', 'value' => $code, 'extra' => "id=chk{$row} onclick=\"checktr('chk{$row}','tr{$row}')\""), 'checkbox'); // email $this->table_builder->set_cell_content($row, $col_alias['e_mail'], "{$entity['email']}"); if ('deleted' != $entity['status']) { // actions $this->table_builder->set_cell_content($row, $col_alias['action'], array('name' => __('Edit'), 'href' => "#edit", 'extra' => "value=\"" . __('Edit') . "\" title=\"" . __('Edit') . "\" class='guibutton floatl mr3 ico ico-edit' onclick='edit(\"{$code}\");'"), 'link'); $this->table_builder->cell($row, $col_alias['action'])->add_content(array('name' => __('Change Balance'), 'href' => "#balance", 'extra' => "value=\"" . __('Change Balance') . "\" title=\"" . __('Change Balance') . "\" class='guibutton floatl ico ico-money' onclick='balance(\"{$code}\");'"), 'link', ' '); } switch ($entity['status']) { case 'deleted': $this->table_builder->add_row_attribute($row, 'class', "deleted_row"); break; case 'blocked': $this->table_builder->add_row_attribute($row, 'class', "blocked_row"); break; } // id $this->table_builder->set_cell_content($row, $col_alias['id'], $id_entity); // name $this->table_builder->set_cell_content($row, $col_alias['name'], type_to_str($entity['name'], 'encode')); // registration date $this->table_builder->set_cell_content($row, $col_alias['creation_date'], type_to_str($entity['join_date'], 'date')); // status $this->table_builder->set_cell_content($row, $col_alias['status'], __('adv_' . $entity['status'])); // ballance $this->table_builder->set_cell_content($row, $col_alias['ballance'], type_to_str($entity['ballance'], 'money')); // impressions $this->table_builder->set_cell_content($row, $col_alias['impressions'], type_to_str($entity['impressions'], 'integer')); // clicks $this->table_builder->set_cell_content($row, $col_alias['clicks'], type_to_str($entity['clicks'], 'integer')); // ctr $this->table_builder->set_cell_content($row, $col_alias['ctr'], type_to_str($entity['ctr'], 'float') . ' %'); // spent $this->table_builder->set_cell_content($row, $col_alias['spent'], type_to_str($entity['spent'], 'money')); // render addtional columns from simple plugins $this->coupons_plugin->run('getAdditionalCellsContent', array('table' => &$this->table_builder, 'row' => $row, 'content' => type_to_str($entity['bonus'], 'money'))); // render additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderRow($row, $col_alias, $entity, $this->table_builder); } $this->table_builder->add_row_attribute($row, 'id', "tr{$row}"); $row++; } if (0 == count($list)) { $this->table_builder->insert_empty_cells = false; $this->table_builder->set_cell_content(1, 0, ' ' . __('Records not found')); $this->table_builder->cell(1, 0)->add_attribute('colspan', count($col_alias)); $this->table_builder->cell(1, 0)->add_attribute('class', 'nodata'); $this->table_builder->remove_col_attribute_value(0, 'class', 'chkbox'); $this->table_builder->cell(0, 0)->add_attribute('class', 'chkbox'); } else { // Display page total $this->table_builder->set_cell_content($row, $col_alias['name'], __("Page total")); $this->table_builder->set_cell_content($row, $col_alias['ballance'], type_to_str($page_total['balance'], 'money')); $this->table_builder->set_cell_content($row, $col_alias['impressions'], type_to_str($page_total['impressions'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['clicks'], type_to_str($page_total['clicks'], 'integer')); $ctr = $page_total['impressions'] ? $page_total['clicks'] / $page_total['impressions'] * 100 : 0; $this->table_builder->set_cell_content($row, $col_alias['ctr'], type_to_str($ctr, 'float') . ' %'); $this->table_builder->set_cell_content($row, $col_alias['spent'], type_to_str($page_total['spent'], 'money')); $this->table_builder->clear_row_attributes($row); $this->table_builder->add_row_attribute($row, 'class', 'pagetotal'); // render additional columns from simple plugins $this->coupons_plugin->run('getAdditionalCellsContent', array('table' => &$this->table_builder, 'row' => $row, 'content' => type_to_str($page_total['bonus'], 'money'))); // render per page statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderPageStatisticRow($row, $col_alias, $page_total, $this->table_builder); } $row++; // Display all pages total $this->table_builder->set_cell_content($row, $col_alias['name'], __("Total")); $this->table_builder->set_cell_content($row, $col_alias['ballance'], type_to_str($total['balance'], 'money')); $this->table_builder->set_cell_content($row, $col_alias['impressions'], type_to_str($total['impressions'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['clicks'], type_to_str($total['clicks'], 'integer')); $ctr = $total['impressions'] ? $total['clicks'] / $total['impressions'] * 100 : 0; $this->table_builder->set_cell_content($row, $col_alias['ctr'], type_to_str($ctr, 'float') . ' %'); $this->table_builder->set_cell_content($row, $col_alias['spent'], type_to_str($total['spent'], 'money')); $this->table_builder->clear_row_attributes($row); $this->table_builder->add_row_attribute($row, 'class', 'alltotal'); // render additional columns from simple plugins $this->coupons_plugin->run('getAdditionalCellsContent', array('table' => &$this->table_builder, 'row' => $row, 'content' => type_to_str($total['bonus'], 'money'))); // render summary statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderSummaryRow($row, $col_alias, $total, $this->table_builder); } } // Устанавливаем возможность выбора колонок $this->table_builder->use_select_columns(); $invariable_columns = array($col_alias['id'], $col_alias['name'], $col_alias['e_mail'], $col_alias['action']); $this->table_builder->set_invariable_columns($invariable_columns); $html = str_replace('<%ADVERTISERS%>', $this->table_builder->get_sort_html(), $html); $html = str_replace('<%PAGINATION%>', $this->pagination_post->create_form(), $html); $buttons = $this->load->view('admin/manage_advertisers/buttons.html', '', TRUE); $html = str_replace('<%BUTTONST%>', str_replace('<%ID%>', 'top_', $buttons), $html); $html = str_replace('<%BUTTONSB%>', str_replace('<%ID%>', 'bottom_', $buttons), $html); $html = str_replace('<%COLUMNS%>', $this->table_builder->get_columns_html(), $html); $this->_set_content($html); $this->_display(); }
/** * возвращает javascript-код для определения текста периода по выбору options * * @return string javascript-код */ function get_all_periods() { $all = array('today', 'yesterday', 'lastweek', 'lastbusinessweek', 'thismonth', 'lastmonth', 'alltime'); $fields['mode'] = 'select'; $code = ''; foreach ($all as $per) { $fields['period'] = $per; $range = data_range($fields); $from = type_to_str($range['from'], 'date'); $to = type_to_str($range['to'], 'date'); $code .= "case '{$per}': return '{$from}-{$to}';\n"; } $code .= "case 'start': return '" . type_to_str(0, 'date') . "';\n"; $code .= "case 'end': return '" . type_to_str(mktime(), 'date') . "';\n"; return $code; }
/** * подготавливает данные статистики для заданного периода времени * * @return ничего не возвращает */ protected function _stat($range) { //load hooks $hooks = array(); $pluginsConfig = Zend_Registry::getInstance()->get('pluginsConfig'); if (isset($pluginsConfig->advertiser->dashboard_blocks->summary_performance)) { foreach ($pluginsConfig->advertiser->dashboard_blocks->summary_performance as $hookClass) { $hookObj = new $hookClass(); if ($hookObj instanceof Sppc_Advertiser_Dashboard_SummaryPerformanceInterace) { $hooks[] = $hookObj; } } } $this->range = $range; $stat = $this->entity->get_stat($this->user_id, $range['from'], $range['to']); $ctr = $stat['impressions'] ? $stat['clicks'] * 100 / $stat['impressions'] : 0; $this->dashboard['TOTALSPENT'] = type_to_str($stat['spent'], 'money'); $this->dashboard['TOTALIMPRESSIONS'] = type_to_str($stat['impressions'], 'integer'); $this->dashboard['TOTALCLICKS'] = type_to_str($stat['clicks'], 'integer'); $this->dashboard['CTR'] = type_to_str($ctr, 'float') . " %"; // add additional performance fields from plugins foreach ($hooks as $hookObj) { $this->dashboard['ADDITIONAL_PERFORMANCE_FIELDS'] = $hookObj->addSummaryPerformanceFields($stat, $this->dashboard['ADDITIONAL_PERFORMANCE_FIELDS']); } }
/** * Отправляет ответ (HTML таблицу) на запрос списка сайтов выбранного канала * Канал указывается в GET-параметре id_channel */ public function get_sites($id_channel, $date_from = null, $date_to = null) { // Add plugins to hook $this->add_plugins('channel_sites'); $message = ''; if (is_null($date_from) || is_null($date_to)) { $fields = period_load('manage_sites_channels', 'select', 'alltime'); $this->date_range = data_range($fields); } else { $this->date_range = array('from' => $date_from, 'to' => $date_to); } $action = $this->input->post('manage_action'); if ($action) { $id_channel = $this->input->post('id_channel'); switch ($action) { case 'pause': $this->pause_channel_sites(); break; case 'resume': $this->resume_channel_sites(); break; case 'delete': $message = $this->delete_channel_sites(); break; } } $this->pagination_post->clear(); $this->pagination_post->set_form_name('manage_sites_channels_site_' . $id_channel); $total_params = array('channel_id_filter' => $id_channel, 'date_filter' => $this->date_range, 'revenue_field' => $this->revenue_field, 'id_entity' => $this->user_id); $total = $this->site->get_count($total_params); $this->pagination_post->set_total_records($total['count']); $this->pagination_post->read_variables('manage_sites_channels_site', 1, 10, FALSE, 'manage_sites_channels_site_' . $id_channel); //настройка параметров разбиения на страницы $pagination = $this->pagination_post->create_form(); $col_index = 0; $col_alias = array('chkboxes' => $col_index++, 'id' => $col_index++, 'url' => $col_index++, 'name' => $col_index++, 'status' => $col_index++, 'impressions' => $col_index++, 'alternative_impressions' => $col_index++, 'clicks' => $col_index++, 'ctr' => $col_index++, 'revenue' => $col_index++, 'action' => $col_index++); // add addtional columns to column map from plugins foreach ($this->_hooks as $hookObj) { $col_alias = $hookObj->extendColumnMap($col_alias); } $this->table_builder->clear(); $this->table_builder->init_sort_vars('manage_sites_channels_site', 'id', 'desc', FALSE, 'manage_sites_channels_site_' . $id_channel); $this->table_builder->sorted_column($col_alias['id'], 'id', 'ID', 'asc'); $this->table_builder->sorted_column($col_alias['name'], 'name', 'Title', 'asc'); $this->table_builder->sorted_column($col_alias['url'], 'url', 'Site URL', 'asc'); $this->table_builder->sorted_column($col_alias['status'], 'status', 'Status', 'asc'); $this->table_builder->sorted_column($col_alias['impressions'], 'impressions', 'Impressions', 'desc'); $this->table_builder->sorted_column($col_alias['alternative_impressions'], 'alternative_impressions', 'Alternative Impressions', 'desc'); $this->table_builder->sorted_column($col_alias['clicks'], 'clicks', 'Clicks', 'desc'); $this->table_builder->sorted_column($col_alias['ctr'], 'ctr', 'CTR', 'desc'); $this->table_builder->sorted_column($col_alias['revenue'], 'revenue', 'Revenue', 'desc'); //$this->table_builder->sorted_column(9,'creation_date','Creation Date','desc'); //добавление ячеек-заголовка $this->table_builder->set_cell_content(0, $col_alias['chkboxes'], array('name' => 'checkAll', 'extra' => 'onclick="return select_all(\'manage_sites_channels_site\', this)"'), 'checkbox'); $this->table_builder->set_cell_content(0, $col_alias['action'], __('Action')); // create additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->createColumns($col_alias, $this->table_builder); } $this->table_builder->cell(0, $col_alias['chkboxes'])->add_attribute('class', 'simpleTitle'); $this->table_builder->cell(0, $col_alias['action'])->add_attribute('class', 'simpleTitle'); //прописывание стилей для ячеек $this->table_builder->add_col_attribute($col_alias['chkboxes'], 'class', '"chkbox"'); $this->table_builder->add_col_attribute($col_alias['id'], 'class', 'w20'); //$this->table_builder->add_col_attribute(3, 'class', 'w150'); //$this->table_builder->add_col_attribute(3, 'class', '"w80 center"'); $this->table_builder->add_col_attribute($col_alias['status'], 'class', 'w80 center'); $this->table_builder->add_col_attribute($col_alias['impressions'], 'class', 'w80 right'); $this->table_builder->add_col_attribute($col_alias['alternative_impressions'], 'class', 'w80 right'); $this->table_builder->add_col_attribute($col_alias['clicks'], 'class', 'w50 right'); $this->table_builder->add_col_attribute($col_alias['ctr'], 'class', 'w50 right'); //$this->table_builder->add_col_attribute(8, 'class', '"w80 right"'); $this->table_builder->add_col_attribute($col_alias['revenue'], 'class', 'w100 center'); $this->table_builder->add_col_attribute($col_alias['action'], 'class', 'nowrap center'); // add styles for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->defineColumnStyles($col_alias, $this->table_builder); } $this->table_builder->add_row_attribute(0, 'class', 'th'); //установка атрибутов таблицы $this->table_builder->add_attribute('class', 'xTable'); //or set style here $params = array('fields' => 'sites.id_site as id, ' . 'sites.url, site_channels.status, sites.name, SUM(impressions) as impressions, ' . 'SUM(alternative_impressions) as alternative_impressions, SUM(clicks) as clicks, ' . '(SUM(clicks)/SUM(impressions)*100) as ctr, UNIX_TIMESTAMP(sites.creation_date) as ' . 'creation_date, SUM(' . $this->revenue_field . ') as revenue, ' . 'e.id_entity AS pub_entity', 'order_by' => $this->table_builder->sort_field, 'order_direction' => $this->table_builder->sort_direction, 'channel_id_filter' => $id_channel, 'date_filter' => $this->date_range, 'id_entity' => $this->user_id, 'offset' => ($this->pagination_post->get_page() - 1) * $this->pagination_post->get_per_page(), 'limit' => $this->pagination_post->get_per_page()); // Add addtional fields to $params['fields'] foreach ($this->_hooks as $hookObj) { if (method_exists($hookObj, 'extendColumnQueryFields')) { $params = $hookObj->extendColumnQueryFields($params, 'stat_sites_channels'); } } $sites_array = $this->site->get_list($params); //echo $this->db->last_query(); if (is_null($sites_array)) { $sites_array = array(); } //$this->table_builder->add_from_array ($sites_array); $data_rows_conut = sizeof($sites_array); //модификация контента отдельных столбцов (ссылки, чекбоксы) $code_channel = type_to_str($id_channel, 'textcode'); $page_total = array('revenue' => 0, 'impressions' => 0, 'alternative_impressions' => 0, 'clicks' => 0); // register additional per page statistic fields foreach ($this->_hooks as $hookObj) { $page_total = $hookObj->registerPerPageStatisticFields($page_total); } $pub_entity = NULL; for ($i = 0; $i < $data_rows_conut; $i++) { $pub_entity = $sites_array[$i]['pub_entity']; $page_total['impressions'] += $sites_array[$i]['impressions']; $page_total['alternative_impressions'] += $sites_array[$i]['alternative_impressions']; $page_total['clicks'] += $sites_array[$i]['clicks']; $page_total['revenue'] += $sites_array[$i]['revenue']; // calculate per page statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $page_total = $hookObj->calculatePerPageStatistic($page_total, $sites_array[$i]); } $code_site = type_to_str($sites_array[$i]['id'], 'textcode'); if ('deleted' == $sites_array[$i]['status']) { $this->table_builder->set_cell_content($i + 1, $col_alias['chkboxes'], ''); $this->table_builder->set_cell_content($i + 1, $col_alias['action'], ''); $this->table_builder->add_row_attribute($i + 1, 'class', 'deleted_row'); } else { if ($sites_array[$i]['pub_entity'] == $this->user_id) { $this->table_builder->set_cell_content($i + 1, $col_alias['chkboxes'], array('name' => 'id_site[]', 'value' => $sites_array[$i]['id'], 'extra' => 'id=chk' . $i . ' onclick="checktr(\'chk' . $i . '\',\'tr' . ($i + 1) . '\')"'), 'checkbox'); $this->table_builder->set_cell_content($i + 1, $col_alias['action'], array('name' => __('Edit'), 'href' => $this->site_url . $this->index_page . $this->role . '/edit_site/index/' . $sites_array[$i]['id'], 'extra' => 'jframe="no" class="guibutton floatl ico ico-edit" value="{@Edit@}" title="{@Edit@}" onclick="top.location=\'' . $this->site_url . $this->index_page . $this->role . '/edit_site/index/' . $sites_array[$i]['id'] . '\'" target="_top"'), 'link'); $this->table_builder->cell($i + 1, $col_alias['action'])->add_content(array('name' => __('Get code'), 'href' => '#get_code', 'extra' => 'jframe="no" class="guibutton floatl ico ico-puzzle2" value="{@Get code@}" title="{@Get code@}" onclick="top.get_channel_code(\'' . $sites_array[$i]['id'] . '\',\'' . $id_channel . '\')"'), 'link', ' '); $this->table_builder->cell($i + 1, $col_alias['action'])->add_content(array('name' => __('Layout'), 'href' => $this->site_url . $this->index_page . $this->role . '/edit_site_channel_layout/index/' . $sites_array[$i]['id'], 'extra' => 'jframe="no" class="guibutton floatl ico ico-site-layout" value="{@Layout@}" title="{@Layout@}" onclick="top.location=\'' . $this->site_url . $this->index_page . $this->role . '/edit_site_channel_layout/index/' . $sites_array[$i]['id'] . '\'" target="_top"'), 'link', ''); } else { $this->table_builder->set_cell_content($i + 1, $col_alias['chkboxes'], ''); $this->table_builder->set_cell_content($i + 1, $col_alias['action'], ''); } $this->table_builder->cell($i + 1, $col_alias['action'])->add_content(array('name' => __('View Ads'), 'href' => '#view_ads', 'extra' => 'jframe="no" class="guibutton floatl ico ico-viewads" value="' . __("View Ads") . '" title="' . __("View Ads") . '" onclick="top.view_ads(\'' . $code_site . '\',\'' . $code_channel . '\')"'), 'link', ' '); $this->table_builder->add_row_attribute($i + 1, 'id', 'tr' . ($i + 1)); if ('paused' == $sites_array[$i]['status']) { $this->table_builder->add_row_attribute($i + 1, 'class', 'blocked_row'); } } $this->table_builder->set_cell_content($i + 1, $col_alias['id'], $sites_array[$i]['id']); $this->table_builder->set_cell_content($i + 1, $col_alias['name'], limit_str_and_hint($sites_array[$i]['name'], 30)); $this->table_builder->set_cell_content($i + 1, $col_alias['url'], array('name' => $sites_array[$i]['url'], 'href' => 'http://' . $sites_array[$i]['url'], 'extra' => 'target="_blank"'), 'link'); $this->table_builder->set_cell_content($i + 1, $col_alias['status'], __('site_' . $sites_array[$i]['status'])); $this->table_builder->set_cell_content($i + 1, $col_alias['impressions'], type_to_str($sites_array[$i]['impressions'], 'integer')); $this->table_builder->set_cell_content($i + 1, $col_alias['alternative_impressions'], type_to_str($sites_array[$i]['alternative_impressions'], 'integer')); $this->table_builder->set_cell_content($i + 1, $col_alias['clicks'], type_to_str($sites_array[$i]['clicks'], 'integer')); $this->table_builder->set_cell_content($i + 1, $col_alias['ctr'], type_to_str($sites_array[$i]['ctr'], 'float') . ' %'); $this->table_builder->set_cell_content($i + 1, $col_alias['revenue'], type_to_str($sites_array[$i]['revenue'], 'money')); //$this->table_builder->set_cell_content ( $i + 1, 9, type_to_str($sites_array [$i]['creation_date'], 'date')); // render additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderRow($i + 1, $col_alias, $sites_array[$i], $this->table_builder); } } //end модификация контента отдельных столбцов (ссылки, чекбоксы) if (0 == $data_rows_conut) { $this->table_builder->insert_empty_cells = false; $this->table_builder->set_cell_content(1, 0, __('Records not found')); $this->table_builder->cell(1, 0)->add_attribute('colspan', count($col_alias)); $this->table_builder->cell(1, 0)->add_attribute('class', 'nodata'); $this->table_builder->remove_col_attribute_value(0, 'class', 'chkbox'); $this->table_builder->cell(0, 0)->add_attribute('class', 'chkbox'); } else { $row = $data_rows_conut + 1; $this->table_builder->set_cell_content($row, $col_alias['name'], __("Page total")); //$this->table_builder->cell($row, 2)->add_attribute('colspan', 2); $this->table_builder->set_cell_content($row, $col_alias['impressions'], type_to_str($page_total['impressions'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['alternative_impressions'], type_to_str($page_total['alternative_impressions'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['clicks'], type_to_str($page_total['clicks'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['revenue'], type_to_str($page_total['revenue'], 'money')); $ctr = $page_total['impressions'] ? $page_total['clicks'] / $page_total['impressions'] * 100 : 0; $this->table_builder->set_cell_content($row, $col_alias['ctr'], type_to_str($ctr, 'procent')); $this->table_builder->clear_row_attributes($row); $this->table_builder->add_row_attribute($row, 'class', 'pagetotal'); // render per page statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderPageStatisticRow($row, $col_alias, $page_total, $this->table_builder); } $row++; $this->table_builder->set_cell_content($row, $col_alias['name'], __("Total")); //$this->table_builder->cell($row, 2)->add_attribute('colspan', 2); $this->table_builder->set_cell_content($row, $col_alias['impressions'], type_to_str($total['impressions'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['alternative_impressions'], type_to_str($total['alternative_impressions'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['clicks'], type_to_str($total['clicks'], 'integer')); $this->table_builder->set_cell_content($row, $col_alias['revenue'], type_to_str($total['revenue'], 'money')); $ctr = $total['impressions'] ? $total['clicks'] / $total['impressions'] * 100 : 0; $this->table_builder->set_cell_content($row, $col_alias['ctr'], type_to_str($ctr, 'procent')); $this->table_builder->clear_row_attributes($row); $this->table_builder->add_row_attribute($row, 'class', 'alltotal'); // render summary statistic for additional columns from plugins foreach ($this->_hooks as $hookObj) { $hookObj->renderSummaryRow($row, $col_alias, $total, $this->table_builder); } } // Устанавливаем возможность выбора колонок $this->table_builder->use_select_columns(); $invariable_columns = array($col_alias['chkboxes'], $col_alias['id'], $col_alias['url'], $col_alias['action']); $this->table_builder->set_invariable_columns($invariable_columns); //$this->table_builder->add_attribute ( 'class', 'xTable' ); //or set style here $table = $this->table_builder->get_sort_html(); $content = $this->parser->parse($this->views_paths['iframe_sites_list'], array('MESSAGE' => json_encode(array('message' => __($message))), 'SITES_TABLE' => $table, 'COLUMNS' => $this->table_builder->get_columns_html(), 'PAGINATION' => $pagination, 'ID_CHANNEL' => $id_channel, 'JFRAME_ACTION' => '<%SITEURL%><%INDEXPAGE%>' . $this->role . '/manage_sites_channels/get_sites/' . $id_channel . '/' . $date_from . '/' . $date_to . '/all'), TRUE); if ($pub_entity != $this->user_id) { $content = preg_replace("/\\<a name=\"chan_buttons_begin\"\\>\\<\\/a\\>[\\s\\S]*?\\<a name=\"chan_buttons_end\"\\>\\<\\/a\\>/", '', $content); } //$this->template = "common/parent/iframe.html"; $this->template = "common/parent/jq_iframe.html"; $this->_set_content($content); $this->_display(); }