示例#1
0
                $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");
示例#2
0
 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();
         }
     }
 }
示例#3
0
<?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();
示例#4
0
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']);