PHP FLEA::getDBO方法代码示例

 function actionDeliveryDetailList()
 {
     //过滤语句
     $using = new class_using();
     $request = $using->safeUsing('request', 'controller:string,action:string');
     $this->_model =& FLEA::getSingleton('model_rep');
     //出货表
     $rep = $this->_model->find(array('ID' => $request['kcreport'], 'ID' => $request['actionDeliveryDetailList']));
     if ($rep) {
         $this->_model =& FLEA::getSingleton('model_grid');
         //表字段
         $grid = $this->_model->findAll(array('RepID' => $rep['ID']));
         //设置查询语句
         $dbo =& FLEA::getDBO();
         $this->sql = $rep['select FCustomerCode,FCustomerName,FDate,FSODate from v_delivery'];
         //查询条件-按日期查询
         ///此处可修改>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
         $cond = new class_conditions();
         $formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
         $todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
         $FCustomer = isset($request['FCustomer']) ? trim($this->u2gbk($request['FCustomer'])) : null;
         $cond->between($formdate, $todate, 'FDate', 'D', 2);
         $cond->equal($FCustomer, 'FCustomerCode', 'S', ' and ');
         ///此处可修改<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
         //排序
         $order = new class_order($request);
         //获取当前页
         $page['cid'] = isset($request['pageNum']) && intval($request['pageNum']) > 0 ? intval($request['pageNum']) : 1;
         $page['size'] = isset($request['numPerPage']) && intval($request['numPerPage']) > 0 ? intval($request['numPerPage']) : 20;
         echo $this->sql;
         //获取SQL查询的全部记录
         $alldata = $dbo->getAll($this->sql . $cond->getWhere() . $order->getOrder());
         //获取SQL查询的记录总数
         $page['count'] = count($alldata);
         //$allFProfit =$this->_count($alldata,'FProfit');
         //$allFSaleAmount =$this->_count($alldata,'FSaleAmount');
         //记录偏移量
         $page['offset'] = ($page['cid'] - 1) * $page['size'] > $page['count'] ? $page['count'] : ($page['cid'] - 1) * $page['size'];
         $data = array_slice($alldata, $page['offset'], $page['size'], true);
         //处理查询结果
         if (isset($data)) {
             ///此处可修改>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
             $this->_smarty->assign('formdate', $formdate);
             $this->_smarty->assign('todate', $todate);
             $this->_smarty->assign('FCustomer', $FCustomer);
             ///此处可修改<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
             $this->_smarty->assign('orderField', $order->getField());
             $this->_smarty->assign('orderDirection', $order->getDirection());
             $this->_smarty->assign('page', $page);
             $this->_smarty->assign('data', $data);
             $this->_smarty->assign('grid', $grid);
             $this->_smarty->assign('alldata', $alldata);
             $this->_smarty->assign('allFProfit', $allFProfit);
             $this->_smarty->assign('allFSaleAmount', $allFSaleAmount);
             $this->_smarty->display('kc.DeliveryDetailList.htm');
         }
     } else {
         $this->_smarty->display('norepinfo.htm');
     }
 }

 function actionDeliveryDetail()
 {
     //过滤语句
     $using = new class_using();
     $request = $using->safeUsing('get', 'controller:string,action:string');
     //设置查询语句
     $dbo =& FLEA::getDBO();
     $this->sql = 'select FCustomerCode,FCustomerName,FDate,FAmount,FAllAmount from v_delivery';
     //查询条件-按日期查询
     $cond = new class_conditions();
     $formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
     $todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
     $FCustomer = isset($request['FCustomer']) ? trim(rawurldecode($request['FCustomer'])) : null;
     $cond->equal($FCustomer, 'FCustomerCode', 'S', ' and ');
     $cond->between($formdate, $todate, 'fdate', 'D', 2);
     //排序
     $order = new class_order($request);
     //获取SQL查询的全部记录
     $alldata = $dbo->getAll($this->sql . $cond->getWhere() . $order->getOrder());
     $xls = new class_excel();
     $xls->addArray($this->gethead($alldata));
     $xls->addArray($this->getdata($alldata));
     $xls->addArray($this->getfoot($alldata));
     $xls->generateXML("DeliveryDetail");
 }

 /**
  * 生成代码
  *
  * @param string $tableName
  * @param string $tableClass
  *
  * @return string
  */
 function _getCode($tableName, $tableClass)
 {
     /**
      * 首先判断指定的数据表是否存在
      */
     $dbo =& FLEA::getDBO();
     $tables = $dbo->metaTables();
     if (!in_array($tableName, $tables)) {
         echo "Database table '{$tableName}' not exists.\n";
         return -1;
     }
     $meta = $dbo->metaColumns($tableName);
     $primaryKey = '';
     foreach ($meta as $field) {
         if ($field['primaryKey']) {
             $primaryKey = $field['name'];
             break;
         }
     }
     $viewdata = array('tableName' => $tableName, 'tableClass' => $tableClass, 'primaryKey' => $primaryKey);
     return $this->_parseTemplate('table', $viewdata);
 }

<?php

require 'FLEA.php';
$dbDSN = array('driver' => 'mysqlt', 'host' => 'localhost', 'login' => 'root', 'password' => '', 'database' => 'test');
FLEA::setAppInf('dbDSN', $dbDSN);
FLEA::setAppInf('internalCacheDir', 'D:/temp');
$dbo =& FLEA::getDBO();
$dbo->startTrans();
/**
 * 建立全部需要的权限
 */
$tablePermissions =& FLEA::getSingleton('FLEA_Acl_Table_Permissions');
/* @var $tablePermissions FLEA_Acl_Table_Permissions */
$permissions = array(array('name' => '/Project/Create'), array('name' => '/Project/View'), array('name' => '/Project/Edit'), array('name' => '/Project/Delete'), array('name' => '/Bug/Create'), array('name' => '/Bug/View'), array('name' => '/Bug/Edit'), array('name' => '/Bug/AddComment'), array('name' => '/Bug/SetFixed'), array('name' => '/Bug/SetClosed'), array('name' => '/Bug/Delete'));
$tablePermissions->createRowset($permissions);
$permissions = $tablePermissions->findAll();
FLEA::loadHelper('array');
$permissions = array_to_hashmap($permissions, 'name');
/**
 * 建立角色，并将权限绑定到角色上
 */
$tableRoles =& FLEA::getSingleton('FLEA_Acl_Table_Roles');
/* @var $tableRoles FLEA_Acl_Table_Roles */
$role = array('name' => 'ProjectManager', 'permissions' => array($permissions['/Project/Create'], $permissions['/Project/View'], $permissions['/Project/Edit'], $permissions['/Project/Delete'], $permissions['/Bug/Delete']));
$tableRoles->create($role);
$role = array('name' => 'Developer', 'permissions' => array($permissions['/Project/View'], $permissions['/Bug/View'], $permissions['/Bug/AddComment'], $permissions['/Bug/SetFixed'], $permissions['/Bug/Delete']));
$tableRoles->create($role);
$role = array('name' => 'Tester', 'permissions' => array($permissions['/Project/Create'], $permissions['/Bug/Create'], $permissions['/Bug/Edit'], $permissions['/Bug/View'], $permissions['/Bug/AddComment'], $permissions['/Bug/SetClosed']));
$tableRoles->create($role);
/**
 * 读取所有角色信息，并以角色名为索引

 /**
  * 构造 FLEA_Db_TableDataGateway 实例
  *
  * $params 参数允许有下列选项：
  *   - schema: 指定数据表的 schema
  *   - tableName: 指定数据表的名称；
  *   - primaryKey: 指定主键字段名
  *   - autoValidating: 指示是否使用自动验证；
  *   - verifierProvider: 指定要使用的数据验证服务对象。
  *     如果未指定。则使用应用程序设置 helper.verifier 指定的验证服务提供对象；
  *   - skipConnect: 指示初始化表数据入口对象时是否不连接到数据库；
  *   - dbDSN: 指定连接数据库要使用的 DSN，如果未指定则使用默认的 DSN 设置；
  *   - dbo: 指定要使用的数据库访问对象;
  *   - skipCreateLinks: 指示初始化表数据入口时，是否不建立关联关系
  *
  * @param array $params
  *
  * @return FLEA_Db_TableDataGateway
  */
 function FLEA_Db_TableDataGateway($params = null)
 {
     if (!empty($params['schema'])) {
         $this->schema = $params['schema'];
     }
     if (!empty($params['tableName'])) {
         $this->tableName = $params['tableName'];
     }
     if (!empty($params['primaryKey'])) {
         $this->primaryKey = $params['primaryKey'];
     }
     // 初始化验证服务对象
     if (isset($params['autoValidating'])) {
         $this->autoValidating = $params['autoValidating'];
     }
     if ($this->autoValidating) {
         if (!empty($params['verifierProvider'])) {
             $provider = $params['verifierProvider'];
         } else {
             $provider = FLEA::getAppInf('helper.verifier');
         }
         if (!empty($provider)) {
             $this->verifier =& FLEA::getSingleton($provider);
         }
     }
     // 当 skipInit 为 true 时，不初始化表数据入口对象
     if (isset($params['skipConnect']) && $params['skipConnect'] != false) {
         return;
     }
     // 初始化数据访问对象
     if (!isset($params['dbo'])) {
         if (isset($params['dbDSN'])) {
             $dbo =& FLEA::getDBO($params['dbDSN']);
         } else {
             $dbo =& FLEA::getDBO();
         }
     } else {
         $dbo =& $params['dbo'];
     }
     $this->setDBO($dbo);
     // 当 skipCreateLinks 不为 true 时，建立关联
     if (!isset($params['skipCreateLinks']) || $params['skipCreateLinks'] == false) {
         $this->relink();
     }
 }

 public function actionallmondy()
 {
     if ($_POST['sub']) {
         //发送指令
         FLEA::loadClass('Util_socketclient');
         if ($_POST['dev']) {
             try {
                 $db = FLEA::getDBO();
                 $db->startTrans();
                 foreach ($_POST['dev'] as $equipment) {
                     $socket = new Util_socketclient();
                     $devinfo = $this->_M->find($equipment);
                     if (!$devinfo) {
                         continue;
                     }
                     $this->log->ip = $devinfo['ipaddr'];
                     $socket_command = array('passstat' => "SP9{$_POST[passstat]}Z", 'mutestat' => "SM9{$_POST[mutestat]}Z", 'gain' => "SG9" . $socket->setupgain($_POST['gain']) . "Z");
                     $socket->socketconn($devinfo['ipaddr'], $devinfo['ipport']);
                     foreach ($socket_command as $field => $command) {
                         switch ($socket->sendmessage($command)) {
                             case $socket->returntrue:
                                 $updatearr = array($field => $_POST[$field]);
                                 $this->M_chninfo->updateByConditions("dev_no={$equipment}", $updatearr);
                                 $this->log->writelog($devinfo['devname'], $command, $socket->returntrue);
                                 break;
                             case $socket->returnfalse:
                                 $this->log->writelog($devinfo['devname'], $command, $socket->returnfalse);
                                 break;
                         }
                         sleep(1);
                     }
                     fclose($socket->socket);
                 }
                 $db->completeTrans();
                 $this->_G->customshow('发送指令成功', "edit", "Index", 3, 1);
             } catch (Exception $e) {
                 $db->completeTrans(FALSE);
                 $this->_G->customshow('发送指令失败', "edit", "Index", 3, 0);
             }
         } else {
             $message = "&nbsp;<font color=red><b>您没有选择设备！</b></font>&nbsp;";
         }
     } else {
         $dev = $this->_M->findAll();
         $this->_V->assign('dev', $dev);
         $this->_V->assign('gainArray', $this->socketClient->gainArray);
         $this->_V->display('edit_allmondy.htm');
     }
 }

 function actionFEmpIDName()
 {
     $dbo =& FLEA::getDBO();
     $data = $dbo->getAll('select distinct FEmpIDName from v_salesdetail where FEmpIDName <>"" and FEmpIDName is not null');
     $this->_smarty->assign('data', $data);
     $this->_smarty->display('FEmpIDName.htm');
 }

 /**
  * 返回当前页对应的记录集
  *
  * @param string $fields
  * @param boolean $queryLinks
  *
  * @return array
  */
 function &findAll($fields = '*', $queryLinks = true)
 {
     if ($this->count == -1) {
         $this->count = 20;
     }
     $offset = ($this->currentPage - $this->_basePageIndex) * $this->pageSize;
     if (is_object($this->source)) {
         $limit = array($this->pageSize, $offset);
         $rowset = $this->source->findAll($this->_conditions, $this->_sortby, $limit, $fields, $queryLinks);
     } else {
         if (is_null($this->dbo)) {
             $this->dbo =& FLEA::getDBO(false);
         }
         $rs = $this->dbo->selectLimit($this->source, $this->pageSize, $offset);
         $rowset = $this->dbo->getAll($rs);
     }
     return $rowset;
 }

/**
 * 返回数据库访问对象实例（已经过时，用 FLEA::getDBO() 代替）
 *
 * @param array $dsn
 *
 * @return SDBO
 * @deprecated
 */
function &get_dbo($dsn)
{
    return FLEA::getDBO($dsn);
}

 /**
  * 打开 session
  *
  * @param string $savePath
  * @param string $sessionName
  *
  * @return boolean
  */
 function sessionOpen($savePath, $sessionName)
 {
     $dsnName = FLEA::getAppInf('sessionDbDSN');
     $dsn = FLEA::getAppInf($dsnName);
     $this->dbo =& FLEA::getDBO($dsn);
     if (!$this->dbo) {
         return false;
     }
     if (!empty($this->dbo->dsn['prefix'])) {
         $this->tableName = $this->dbo->dsn['prefix'] . $this->tableName;
     }
     $this->tableName = $this->dbo->qtable($this->tableName);
     $this->fieldId = $this->dbo->qfield($this->fieldId);
     $this->fieldData = $this->dbo->qfield($this->fieldData);
     $this->fieldActivity = $this->dbo->qfield($this->fieldActivity);
     $this->sessionGc(FLEA::getAppInf('sessionDbLifeTime'));
     return true;
 }

 /**
  * 恢复设备默认设置
  *
  */
 public function actionResumeDefault()
 {
     $devinfo = $this->M_devinfo->find($_GET['serial']);
     $socket = FLEA::getSingleton('Util_socketclient');
     $socket->socketconn($devinfo['ipaddr'], $devinfo['ipport']);
     $this->log->ip = $devinfo['ipaddr'];
     switch ($socket->sendmessage('SINITZ')) {
         case $socket->returntrue:
             $this->log->writelog($devinfo['devname'], 'SINITZ', $socket->returntrue);
             $serial = (int) $_GET['serial'];
             try {
                 $db = FLEA::getDBO();
                 $db->startTrans();
                 sleep(1);
                 for ($i = 1; $i < 9; $i++) {
                     $return_socketinfo = $socket->sendmessage("SI{$i}Z");
                     if (strlen($return_socketinfo) == 13) {
                         $chninfo = $socket->analysisinfo($return_socketinfo);
                         if ($chninfo === FALSE) {
                             exit($this->_G->customshow('获取设备信息出现乱码,请重试', $_GET['socket_C'], 'index', 3, 0));
                         }
                         //如果有乱码将直接退出
                         #检测APID是否有相同
                         $this->M_chninfo->updateByConditions("dev_no='{$serial}' and chn='{$chninfo['chn']}'", $chninfo);
                         $chninfo['prgname'] = " ";
                         $chninfo['chnshort'] = " ";
                         $this->M_chninfo->updateByConditions("dev_no='{$serial}' and chn='{$chninfo['chn']}'", $chninfo);
                         sleep(1);
                     }
                 }
                 fclose($socket->socket);
                 $db->completeTrans();
                 $this->_G->customshow("该设备已恢复成默认值", 'socket', 'index', 3, 1);
             } catch (Exception $e) {
                 $db->completeTrans(FALSE);
                 $this->_G->customshow("恢复设备默认值失败,请重试", 'socket', 'index', 3, 0);
             }
             break;
         case $socket->returnfalse:
             $this->log->writelog($devinfo['devname'], 'SINITZ', $socket->returnfalse);
             $this->_G->customshow("恢复出错,请重新恢复", 'socket', 'index', 0);
             break;
     }
 }

 function actionReceivable()
 {
     //过滤语句
     $using = new class_using();
     $request = $using->safeUsing('post', 'controller:string,action:string');
     //设置查询语句
     $dbo =& FLEA::getDBO();
     $this->sql = 'select * from v_pay';
     //查询条件-按日期查询
     $cond = new class_conditions();
     $formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
     $todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
     //$cond->between($formdate,$todate,'fdate','D',2);
     //$cond->equal($FCustomercode,'FCustomercode','S',' and ');
     //排序
     $order = new class_order($request);
     //获取当前页
     $page['cid'] = isset($request['pageNum']) && intval($request['pageNum']) > 0 ? intval($request['pageNum']) : 1;
     $page['size'] = isset($request['numPerPage']) && intval($request['numPerPage']) > 0 ? intval($request['numPerPage']) : 20;
     //获取SQL查询的全部记录
     $alldata = $dbo->getAll($this->sql . $cond->getWhere() . $order->getOrder());
     //获取SQL查询的记录总数
     $page['count'] = count($alldata);
     //记录偏移量
     $page['offset'] = ($page['cid'] - 1) * $page['size'] > $page['count'] ? $page['count'] : ($page['cid'] - 1) * $page['size'];
     $data = array_slice($alldata, $page['offset'], $page['size'], true);
     //处理查询结果
     if (isset($data)) {
         $this->_smarty->assign('formdate', $formdate);
         $this->_smarty->assign('todate', $todate);
         $this->_smarty->assign('orderField', $order->getField());
         $this->_smarty->assign('orderDirection', $order->getDirection());
         $this->_smarty->assign('page', $page);
         $this->_smarty->assign('data', $data);
         $this->_smarty->assign('alldata', $alldata);
         $this->_smarty->display('repsale.Receivable.htm');
     }
 }

 function actionuserImport()
 {
     $rbac =& FLEA::getSingleton('FLEA_Rbac');
     $SE = $rbac->getUser();
     if (!$SE) {
         $this->writeAjax('300', '你无权执行此操作!', '', '', '');
     }
     $using = new class_using();
     $request = $using->safeUsing('post', 'UserID:string');
     $dbo =& FLEA::getDBO();
     $data = $dbo->getAll('select t_user.FName AS Username,password=1,IsSuperUser=0,t_user.FName as DisplayName from t_user where t_user.FName not in(select srep_user.Username as FName from srep_user) and  t_user.FUserID > 16000 and  t_user.FName<>' . "''");
     $this->_model =& FLEA::getSingleton('model_user');
     $this->_model->saveRowset($data);
     if (isset($data)) {
         $this->_smarty->assign('users', $data);
         $this->_smarty->display('userimport.htm');
     }
 }

 function actionDeliveryDetail()
 {
     //过滤语句
     $using = new class_using();
     $request = $using->safeUsing('get', 'controller:string,action:string');
     //设置查询语句
     $dbo =& FLEA::getDBO();
     $this->sql = 'select FCustomerType,sum(FSaleAmountIncludeTax) as FSaleAmountIncludeTax ,sum(FSaleAmount) as FSaleAmount,sum(FAmount) as FAmount,sum(FProfit) as FProfit,case when sum(FSaleAmount) = 0 then 0 else sum(FProfit)/sum(FSaleAmount) end FProfitRate from v_salesdetail';
     //查询条件-按日期查询
     $cond = new class_conditions();
     $formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
     $todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
     $FCustomerType = isset($request['FCustomerType']) ? trim(rawurldecode($request['FCustomerType'])) : null;
     $cond->between($formdate, $todate, 'fdate', 'D', 2);
     $cond->equal($FCustomerType, 'FCustomerType', 'S', ' and ');
     //排序
     $order = new class_order($request);
     //获取SQL查询的全部记录
     $alldata = $dbo->getAll($this->sql . $cond->getWhere() . ' group by FCustomerType ' . $order->getOrder());
     $xls = new class_excel();
     $xls->addArray($this->gethead($alldata));
     $xls->addArray($this->getdata($alldata));
     $xls->addArray($this->getfoot($alldata));
     $xls->generateXML("DeliveryDetail");
 }

 function actionrepsaleCombine()
 {
     //过滤语句
     $using = new class_using();
     $request = $using->safeUsing('post', 'controller:string,action:string');
     //设置查询语句
     $dbo =& FLEA::getDBO();
     //查询条件-按日期查询
     $cond = new class_conditions();
     $formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
     $todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
     $FA = isset($request['FA']) && !empty($request['FA']) ? trim($this->u2gbk($request['FA'])) : '';
     $FB = isset($request['FB']) && !empty($request['FB']) ? trim($this->u2gbk($request['FB'])) : '';
     $FB = $FA == $FB ? '' : $FB;
     $_FA = $FA == '' ? '' : $FA . ',';
     $_FB = $FB == '' ? '' : $FB . ',';
     $cond->between($formdate, $todate, 'fdate', 'D', 2);
     $this->sql = 'select ' . $_FA . $_FB . 'sum(FSaleAmountIncludeTax) as FSaleAmountIncludeTax ,sum(FSaleAmount) as FSaleAmount,sum(FAmount) as FAmount,sum(FProfit) as FProfit,case when sum(FSaleAmount) = 0 then 0 else sum(FProfit)/sum(FSaleAmount) end FProfitRate from v_salesdetail';
     //排序
     $order = new class_order($request);
     //获取当前页
     $page['cid'] = isset($request['pageNum']) && intval($request['pageNum']) > 0 ? intval($request['pageNum']) : 1;
     $page['size'] = isset($request['numPerPage']) && intval($request['numPerPage']) > 0 ? intval($request['numPerPage']) : 20;
     if (trim($_FA . $_FB, ',') == '') {
         $alldata = $dbo->getAll($this->sql . $cond->getWhere() . $order->getOrder());
     } else {
         $alldata = $dbo->getAll($this->sql . $cond->getWhere() . ' group by ' . trim($_FA . $_FB, ',') . $order->getOrder());
     }
     //获取SQL查询的记录总数
     $page['count'] = count($alldata);
     $allFProfit = $this->_count($alldata, 'FProfit');
     $allFSaleAmount = $this->_count($alldata, 'FSaleAmount');
     //记录偏移量
     $page['offset'] = ($page['cid'] - 1) * $page['size'] > $page['count'] ? $page['count'] : ($page['cid'] - 1) * $page['size'];
     $data = array_slice($alldata, $page['offset'], $page['size'], true);
     //处理查询结果
     if (isset($data)) {
         $this->_smarty->assign('formdate', $formdate);
         $this->_smarty->assign('todate', $todate);
         $this->_smarty->assign('FA', $FA);
         $this->_smarty->assign('FB', $FB);
         $this->_smarty->assign('orderField', $order->getField());
         $this->_smarty->assign('orderDirection', $order->getDirection());
         $this->_smarty->assign('page', $page);
         $this->_smarty->assign('data', $data);
         $this->_smarty->assign('alldata', $alldata);
         $this->_smarty->assign('allFProfit', $allFProfit);
         $this->_smarty->assign('allFSaleAmount', $allFSaleAmount);
         $this->_smarty->display('repsale.Combine.htm');
     }
 }