function export($from, $to)
{
$productId = $this->common->getCurrentProduct()->id;
$productName = $this->common->getCurrentProduct()->name;
$data = $this->device->getDeviceTypeDetail($productId);
$this->load->library('export');
$export = new Export();
//设定文件名
$export->setFileName($productName . '_' . $from . '_' . $to . '.csv');
//输出列名第一种方法
$fields = array();
foreach ($data->list_fields() as $field) {
array_push($fields, $field);
}
$export->setTitle($fields);
//输出列名第二种方法
// $excel_title = array (iconv("UTF-8", "GBK", "设备型号"),iconv("UTF-8", "GBK", "总数"),iconv("UTF-8", "GBK", "用户比例") );
// $export->setTitle ($excel_title );
//输出内容
foreach ($data->result() as $row) {
$export->addRow($row);
}
$export->export();
die;
}
function export($from, $to)
{
$this->load->library('export');
$productId = $this->common->getCurrentProduct()->id;
$productName = $this->common->getCurrentProduct()->name;
$data = $this->os->getTotalUserPercentByOS($productId);
$export = new Export();
//设定文件名
$export->setFileName($productName . '.csv');
// //输出列名第一种方法
$fields = array();
foreach ($data->list_fields() as $field) {
array_push($fields, $field);
}
$export->setTitle($fields);
//输出列名第二种方法
// $excel_title = array (iconv("UTF-8", "GBK", "操作系统版本"),iconv("UTF-8", "GBK", "用户比例") );
// $export->setTitle ($excel_title );
//输出内容
foreach ($data->result() as $row) {
$export->addRow($row);
}
$export->export();
die;
}
function export()
{
$this->load->library('export');
$fromTime = $this->common->getFromTime();
$toTime = $this->common->getToTime();
$productId = $this->common->getCurrentProduct();
$productId = $productId->id;
$productName = $this->common->getCurrentProduct()->name;
$data = $this->orientationmodel->getTotalUsersPercentByResolution($fromTime, $toTime, $productId);
$export = new Export();
$titlename = getExportReportTitle($productName, lang('v_rpt_re_details'), $fromTime, $toTime);
$title = iconv("UTF-8", "GBK", $titlename);
$export->setFileName($title);
$fields = array();
foreach ($data->list_fields() as $field) {
array_push($fields, $field);
}
$export->setTitle($fields);
foreach ($data->result() as $row) {
$export->addRow($row);
}
$export->export();
die;
}
function exportCSV($label)
{
$fromTime = $this->common->getFromTime();
$toTime = $this->common->getToTime();
$products = $this->common->getCompareProducts();
if (empty($products)) {
$this->common->requireProduct();
return;
}
$this->load->library('export');
$export = new Export();
if ($label == "country") {
$titlename = getExportReportTitle("Compare", lang("v_rpt_re_top10Nations"), $fromTime, $toTime);
} else {
$titlename = getExportReportTitle("Compare", lang("v_rpt_re_top10Provinces"), $fromTime, $toTime);
}
$titlename = iconv("UTF-8", "GBK", $titlename);
$export->setFileName($titlename);
$j = 0;
$mk = 0;
$title[$j++] = iconv("UTF-8", "GBK", lang('t_activeUsers'));
$space[$mk++] = ' ';
for ($i = 0; $i < count($products); $i++) {
$title[$j++] = iconv("UTF-8", "GBK", $products[$i]->name);
$title[$j++] = '';
$space[$mk++] = ' ';
$space[$mk++] = ' ';
}
$export->setTitle($title);
$k = 0;
$maxlength = 0;
$maxlength2 = 0;
$j = 0;
$nextlabel[$j++] = lang('t_newUsers');
for ($m = 0; $m < count($products); $m++) {
if ($label == "country") {
$activedata = $this->region->getactivebycountry($fromTime, $toTime, $products[$m]->id);
$newdata = $this->region->getnewbycountry($fromTime, $toTime, $products[$m]->id);
} else {
$country = $this->default_country;
$activedata = $this->region->getactivebypro($fromTime, $toTime, $products[$m]->id, $country);
$newdata = $this->region->getnewbypro($fromTime, $toTime, $products[$m]->id, $country);
}
$detailData[$m] = $this->change2StandardPrecent($activedata, $label);
$detailNewData[$m] = $this->change2StandardPrecent($newdata, $label);
if (count($detailData[$m]) > $maxlength) {
$maxlength = count($detailData[$m]);
}
if (count($detailNewData[$m]) > $maxlength2) {
$maxlength2 = count($detailNewData[$m]);
}
$nextlabel[$j++] = $products[$m]->name;
$nextlabel[$j++] = ' ';
}
$this->getExportRowData($export, $maxlength, $detailData, $products, $label);
$export->addRow($space);
$export->addRow($nextlabel);
$this->getExportRowData($export, $maxlength2, $detailNewData, $products, $label);
$export->export();
die;
}
/**
* ExportComparedata funciton
* Export the compares error data
*
* @return query result
*/
function exportComparedata()
{
$fromTime = $this->common->getFromTime();
$toTime = $this->common->getToTime();
$products = $this->common->getCompareProducts();
if (empty($products)) {
$this->common->requireProduct();
return;
}
$this->load->library('export');
$export = new Export();
$titlename = getExportReportTitle("Compare", lang("m_rpt_errors"), $fromTime, $toTime);
$titlename = iconv("UTF-8", "GBK", $titlename);
$export->setFileName($titlename);
$j = 0;
$mk = 0;
$maxlength = 0;
$title[$j++] = iconv("UTF-8", "GBK", '');
$space[$mk++] = lang('g_date');
for ($i = 0; $i < count($products); $i++) {
$detailData[$i] = $this->errormodel->getCompareErrorData($products[$i]->id, $fromTime, $toTime);
$maxlength = count($detailData[$i]['content']);
$title[$j++] = iconv("UTF-8", "GBK", $products[$i]->name);
$title[$j++] = iconv("UTF-8", "GBK", '');
$space[$mk++] = lang('v_rpt_err_errorNums');
$space[$mk++] = lang('v_rpt_err_errorNumsInSessions');
}
$export->setTitle($title);
$export->addRow($space);
$k = 0;
$j = 0;
for ($m = 0; $m < $maxlength; $m++) {
$detailcontent = array();
for ($j = 0; $j < count($products); $j++) {
$obj = $detailData[$j]['content'];
if ($j == 0) {
array_push($detailcontent, $obj[$m]['date']);
}
array_push($detailcontent, $obj[$m]['count']);
array_push($detailcontent, $obj[$m]['percentage']);
}
$export->addRow($detailcontent);
}
$export->export();
die;
}
/**
* Export
*
* @return void
*/
function export()
{
$this->load->library('export');
$productId = $this->common->getCurrentProduct();
$this->common->requireProduct();
$productId = $productId->id;
$productName = $this->common->getCurrentProduct()->name;
$fromTime = $this->common->getFromTime();
$toTime = $this->common->getToTime();
$data = $this->os->getTotalUserPercentByOS($productId, $fromTime, $toTime);
if ($data != null && $data->num_rows() > 0) {
$export = new Export();
// set file name
$titlename = getExportReportTitle($productName, lang('v_rpt_os_version'), $fromTime, $toTime);
$title = iconv("UTF-8", "GBK", $titlename);
$export->setFileName($title);
// set title name
$excel_title = array(iconv("UTF-8", "GBK", lang("v_rpt_os_version")), iconv("UTF-8", "GBK", lang("t_sessions")), iconv("UTF-8", "GBK", lang("t_sessionsP")), iconv("UTF-8", "GBK", lang("t_newUsers")), iconv("UTF-8", "GBK", lang("t_newUsersP")));
$export->setTitle($excel_title);
////
$Total = $this->os->getOsSessionNewuserTotal($productId, $fromTime, $toTime);
if ($Total) {
$sessions = $Total->first_row()->sessions;
$newusers = $Total->first_row()->newusers;
} else {
$sessions = 0;
$newusers = 0;
}
foreach ($data->result() as $row) {
if (!$row->deviceos_name) {
$row->deviceos_name = 'unknown';
}
$rowadd['deviceos_name'] = $row->deviceos_name;
$rowadd['sessions'] = $row->sessions;
$rowadd['sessions_p'] = $sessions > 0 ? round(100 * $row->sessions / $sessions, 1) . '%' : '0%';
$rowadd['newusers'] = $row->newusers;
$rowadd['newusers_p'] = $newusers > 0 ? round(100 * $row->newusers / $newusers, 1) . '%' : '0%';
$export->addRow($rowadd);
}
$export->export();
die;
} else {
$this->load->view("usage/nodataview");
}
}
function exportComparePhaseusetime($timePhase, $fromDate = '', $toDate = '')
{
$time = $this->changeDate($timePhase, $fromDate, $toDate);
$fromTime = $time['fromTime'];
$toTime = $time['toTime'];
$products = $this->common->getCompareProducts();
if (empty($products)) {
$this->common->requireProduct();
return;
}
$this->load->library('export');
$export = new Export();
$titlename = getExportReportTitle("Compare", lang("v_rpt_pb_timeTrendOfUsers_detail"), $fromTime, $toTime);
$titlename = iconv("UTF-8", "GBK", $titlename);
$export->setFileName($titlename);
$j = 0;
$mk = 0;
$maxlength = 0;
$title[$j++] = iconv("UTF-8", "GBK", '');
$space[$mk++] = lang('t_date_part');
for ($i = 0; $i < count($products); $i++) {
$detailData[$i] = $this->product->getStarterUserCountByTime($fromTime, $toTime, $products[$i]->id)->result_array();
$maxlength = count($detailData[$i]);
$title[$j++] = iconv("UTF-8", "GBK", $products[$i]->name);
$title[$j++] = iconv("UTF-8", "GBK", '');
$space[$mk++] = lang('t_activeUsers');
$space[$mk++] = lang('t_newUsers');
}
$export->setTitle($title);
$export->addRow($space);
$k = 0;
$j = 0;
for ($m = 0; $m < $maxlength; $m++) {
$detailcontent = array();
for ($j = 0; $j < count($products); $j++) {
$obj = $detailData[$j];
if ($j == 0) {
array_push($detailcontent, $obj[$m]['hour'] . ":00");
}
array_push($detailcontent, $obj[$m]['startusers']);
array_push($detailcontent, $obj[$m]['newusers']);
}
$export->addRow($detailcontent);
}
$export->export();
die;
}
function export($from, $to, $data)
{
$productId = $this->getCurrentProduct()->id;
$productName = $this->getCurrentProduct()->name;
$export = new Export();
// 设定文件名
$export->setFileName($productName . '_' . $from . '_' . $to . '.xls');
// 输出列名
$fields = array();
foreach ($data->list_fields() as $field) {
array_push($fields, $field);
}
$export->setTitle($fields);
// 输出内容
foreach ($data->result() as $row) {
$export->addRow($row);
}
$export->export();
die;
}
function export()
{
$this->load->library('export');
$productId = $this->common->getCurrentProduct();
$this->common->requireProduct();
$productId = $productId->id;
$productName = $this->common->getCurrentProduct()->name;
$fromTime = $this->common->getFromTime();
$toTime = $this->common->getToTime();
$data = $this->network->getALlNetWorkData($productId, $fromTime, $toTime);
$export = new Export();
// set file name
$titlename = getExportReportTitle($productName, lang('v_rpt_nw_details'), $fromTime, $toTime);
$title = iconv("UTF-8", "GBK", $titlename);
$export->setFileName($title);
$fields = array();
foreach ($data->list_fields() as $field) {
array_push($fields, $field);
}
$export->setTitle($fields);
foreach ($data->result() as $row) {
$export->addRow($row);
}
$export->export();
die;
}
