$fnBody = "if({$aStr} == {$bStr}) {\n" . $fnBody; $fnBody .= "}\n"; $fnBody .= "return ({$aStr} < {$bStr}) ? {$t} : {$f};\n"; } } if ($fnBody) { $sortFn = create_function('$a,$b', $fnBody); usort($ary, $sortFn); } } } //To create grid exporting instant. $gridHandler = new GridServerHandler(); $type = getParameter('exportType'); //to get the data from data base. // $data1 = getTestData(); //echo "come here"; if ($gridHandler->sortInfo) { //echo "sortinfo:true<br>"; $sortOrder = $gridHandler->sortInfo[0]["sortOrder"]; //echo var_dump($gridHandler->sortInfo[0]); if ($sortOrder != "defaultsort") { $comp_field = $gridHandler->sortInfo[0]["columnId"]; //echo "sortOrder:". $comp_field; //echo $comp_field . " " . $sortOrder . "\n"; //usort($data1, "mycompare");
public function get_datalist() { //die('deeeewww'); $model = $this->model; //dump($model);die; if (empty($model)) { die("model为空!"); } if ($_REQUEST["print"] == "1") { //echo '会执行么?';exit; $fieldsStr = $model->getPrintFieldString(); $enablePage = false; } else { $enablePage = $model->getModelInfo("enablePage"); if ($enablePage !== false) { $enablePage = true; } $fieldsStr = $model->getListFieldString(); //print_r($fieldsStr);exit; } require_once DXINFO_PATH . "Vendor/GridServerHandler.php"; $gridHandler = new \GridServerHandler(); if ($enablePage) { $start = intval($gridHandler->pageInfo["startRowNum"]) - 1; $pageSize = intval($gridHandler->pageInfo["pageSize"]); $pageSize = $pageSize == 0 ? 20 : $pageSize; } if ($start < 0) { $start = 0; } $where = array_merge($this->defaultWhere, $this->_search()); //dump($where);exit; //print_r($this->defaultWhere);exit; //print_r($this->_search());exit; //使用Model连贯操作时,每一个连贯操作,都会往Model对象中赋值,如果嵌套使用Model的连贯操作,会覆盖掉原来已经存在的值,导致bug。 if (isset($_REQUEST['export']) && !empty($_REQUEST['export'])) { $data_list = $model->where($where)->field($fieldsStr)->order($model->getModelInfo("order"))->select(); } else { if ($enablePage) { $data_list = $model->where($where)->field($fieldsStr)->limit($start . "," . $pageSize)->order($model->getModelInfo("order"))->select(); //echo $model->getLastSql();exit; //正常 // print_r($data_list);exit; } else { $data_list = $model->where($where)->field($fieldsStr)->order($model->getModelInfo("order"))->select(); } } //echo $model->getLastSql();exit; \Think\Log::write($model->getLastSql()); //无数据时data_list = null,此时返回的数据,grid不会更新rows,这导致,再删除最后一条数据时,grid无法删除前端的最后一样。 if (empty($data_list)) { $data_list = array(); } else { $data_change = $model->getModelInfo("data_change"); //var_dump($data_change);exit;是空哦 if (is_array($data_change)) { foreach ($data_change as $key => $val) { DxFunction::$val($data_list, $key); } } } //计算总计: if ($model->getModelInfo("showTotal") && sizeof($data_list) > 0) { $total = array(); foreach ($data_list as $data) { foreach ($data as $index => $vvv) { $total[$index] += floatval($vvv); } } //var_dump($total);exit; foreach ($this->model->getListFields() as $fieldName => $field) { if (array_key_exists("total", $field) && array_key_exists($fieldName, $total)) { $total[$fieldName] = $field["total"]; } } $data_list[] = $total; } //print_r($total);exit; //print_r($data_list);exit; if ($_REQUEST["print"] == "1") { $this->ajaxReturn(array("data" => $data_list, "fields" => $model->getPrintFields())); } else { if (isset($_REQUEST['export']) && !empty($_REQUEST['export'])) { $this->export($data_list, trim($_REQUEST['export'])); } else { $data_count = $enablePage ? $model->where($where)->count() : sizeof($data_list); $gridHandler->setData($data_list); $gridHandler->setTotalRowNum($data_count); $gridHandler->printLoadResponseText(); } } }
<?php //This is sigma grid exporting handler require_once 'GridServerHandler.php'; //This is a php file for data feeding require_once 'testDAO.php'; //To create grid exporting instant. $gridHandler = new GridServerHandler(); $type = getParameter('exportType'); if ($type == 'pdf') { // to use html2pdf to export pdf // param1 : Orientation. 'P' for Portrait , 'L' for Landscape // param2 : Paper size. Could be A3, A4, A5, LETTER, LEGAL // param3 : Relative picture path to this php file $gridHandler->exportPDF('P', 'A4', '../'); } else { //to get the data from data base. // $data1 = getTestDataForMore(); if ($type == 'xml') { //exporting to xml $gridHandler->exportXML($data1); } else { if ($type == 'xls') { //exporting to xls $gridHandler->exportXLS($data1); } else { if ($type == 'csv') { //exporting to csv $gridHandler->exportCSV($data1); } else { $data1 = getTestData();
require_once '../../fB_PluginAPI.php'; define('fvNeighbors_version', file_get_contents('fvNeighbors.ver')); define('fvNeighbors_date', '24 October 2010'); define('fvNeighbors_URL', '/plugins/fvNeighbors/index.php'); define('fvNeighbors_Path', getcwd() . '\\'); // file definitions define('fvNeighbors_Main', 'fvNeighbors_main.sqlite'); /******************fvNeighbors by RadicalLinux****************************/ require_once 'includes/GridServerHandler.php'; require_once 'includes/JSON.php'; require_once 'includes/ExcelExport.php'; include 'includes/fvNeighbors.class.php'; $_SESSION['userId'] = isset($_POST['userId']) ? $_POST['userId'] : $_SESSION['userId']; $fsM = new fvNeighbors('formload'); $gridHandler = new GridServerHandler(); $gtype = getParameter('exportType'); if (isset($_POST['save'])) { $json = new Services_JSON(); $newgtjson = str_replace("\\", "", $_POST['_gt_json']); $value = json_decode($newgtjson, true); foreach ($value['deletedRecords'] as $dr) { $fsM->fnDeleteNeigh($dr['fbid']); } echo "{success : true,exception:''}"; return; } if ($gtype != '') { @($tmpNeigh = $fsM->fnGetNeighbors()); foreach ($tmpNeigh as $nbor) { $lastseen = date("m/d/y, g:i a", $nbor['neighbors_lastseen']);