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 actionchangepwd()
{
$rbac =& FLEA::getSingleton('FLEA_Rbac');
$SE = $rbac->getUser();
$username = isset($SE['USERNAME']) ? $SE['USERNAME'] : '';
$this->_smarty->display('changepwd.htm');
}
/**
* 登录
*/
function actionLogin()
{
do {
/**
* 验证用户名和密码是否正确
*/
$modelSysUsers =& FLEA::getSingleton('Model_SysUsers');
$user = $modelSysUsers->findByUsername($_POST['username']);
if (!$user) {
$msg = _T('ui_l_invalid_username');
break;
}
if (!$modelSysUsers->checkPassword($_POST['password'], $user['password'])) {
$msg = _T('ui_l_invalid_password');
break;
}
/**
* 登录成功，通过 RBAC 保存用户信息和角色
*/
$data = array();
$data['ADMIN'] = $user['username'];
$rbac =& FLEA::getSingleton('FLEA_Rbac');
/* @var $rbac FLEA_Rbac */
$rbac->setUser($data, array('SYSTERM_ADMIN'));
//重定向
redirect(url('ZobAdmin'));
} while (false);
//登录发生错误，再次显示登录界面
$ui =& FLEA::initWebControls();
include APP_DIR . '/ZobLoginIndex.php';
}
/**
* 构造函数
*
* @return Controller_ZobHome
*/
function Controller_ZobHome()
{
parent::Controller_ZobBase();
$this->_modelMembers =& FLEA::getSingleton('Model_Members');
$this->_modelPosts =& FLEA::getSingleton('Model_Posts');
$this->_modelProjects =& FLEA::getSingleton('Model_Projects');
}
public function socketconn($ip, $port)
{
$_G = FLEA::getSingleton("Util_Msg");
$this->socket = @fsockopen($ip, $port, $errNo, $errstr, 30);
if (!$this->socket) {
$_G->customshow("建立Socket连接失败", "socket", "Index", 3, 0);
exit;
}
}
/**
* 构造函数
*
* @return Controller_Default
*/
function Controller_Default()
{
/**
* FLEA::getSingleton() 会自动载入指定类的定义文件，并且返回该类的唯一一个实例
*/
$this->_metas =& FLEA::getAppInf('metas');
$this->_modelNews =& FLEA::getSingleton('Model_News');
$this->_modelMessage =& FLEA::getSingleton('Model_Message');
$this->_modelGoods =& FLEA::getSingleton('Model_Goods');
}
/**
* 追加日志记录
*
* @param string $msg
* @param string $level
*/
function log_message($msg, $level = 'log', $title = '')
{
static $instance = null;
if (is_null($instance)) {
$instance = array();
$obj =& FLEA::getSingleton('FLEA_Log');
$instance = array('obj' => &$obj);
}
return $instance['obj']->appendLog($msg, $level, $title);
}
/**
* 构造函数
*/
function Controller_Admin()
{
/**
* FLEA::getSingleton() 会自动载入指定类的定义文件，并且返回该类的唯一一个实例
*/
$this->_modelNews =& FLEA::getSingleton('Model_News');
$this->_modelMessage =& FLEA::getSingleton('Model_Message');
$this->_modelGoods =& FLEA::getSingleton('Model_Goods');
$this->_modelCategory =& FLEA::getSingleton('Model_Category');
}
function actionlookup()
{
$this->_model =& FLEA::getSingleton('model_depart');
$departs = $this->_model->findAll();
//通用生成树函数
//@param:$arrs 树结构数组
//@param:$keyparam 显示的字段 例如：array('code','name') ，节点将显示“ 编码-名称” 形式
//@param:$$outparam 双击节点带回数值的字段
function maketree($arrs, $keyparam, $outparam)
{
if (isset($arrs) && is_array($arrs)) {
foreach ($arrs as $arr) {
echo '<li>';
echo '<a ';
if (isset($outparam) && is_array($outparam)) {
echo 'ondblclick=\'javascript:$.bringBack({';
for ($i = 0; $i < count($outparam); $i++) {
if ($i > 0) {
echo ',';
}
echo $outparam[$i] . ':"' . $arr[$outparam[$i]] . '"';
}
echo '})\' title="双击选中" ';
}
echo '>';
if (isset($keyparam) && is_array($keyparam)) {
for ($i = 0; $i < count($keyparam); $i++) {
if ($i > 0) {
echo '-';
}
echo $arr[$keyparam[$i]];
}
}
echo '</a>';
if (isset($arr['child'])) {
echo '<ul>';
maketree($arr['child'], $keyparam, $outparam);
echo '</ul>';
}
echo '</li>';
}
}
}
if (isset($departs)) {
//生成部门树结构
$tree = new class_tree($departs);
$departs = $tree->leaf(0);
//设置参数
$this->_smarty->assign('arrs', $departs);
$this->_smarty->assign('keyparam', array('code', 'name'));
$this->_smarty->assign('outparam', array('id', 'code', 'name'));
$this->_smarty->display('departlookup.htm');
}
}
/**
* 构造函数
*
* @return Controller_Default
*/
function Controller_Feedback()
{
/**
* FLEA::getSingleton() 会自动载入指定类的定义文件，并且返回该类的唯一一个实例
*/
$this->_modelMessage =& FLEA::getSingleton('Model_Message');
$this->_metas =& FLEA::getAppInf('metas');
$this->_metas['description'] = "辽宁万维医药经销渠道客户回馈";
$this->_metas['keywords'] = "辽宁万维医药,辽宁,吉林省,黑龙江省,医药客户回馈";
$this->_metas['title'] = $this->_metas['title'] . "客户回馈";
}
/**
* 构造函数
*
* @return Controller_Default
*/
function Controller_Products()
{
/**
* FLEA::getSingleton() 会自动载入指定类的定义文件，并且返回该类的唯一一个实例
*/
$this->_modelGoods =& FLEA::getSingleton('Model_Goods');
$this->_metas =& FLEA::getAppInf('metas');
$this->_metas['description'] = "辽宁万维医药经销渠道产品世界";
$this->_metas['keywords'] = "辽宁万维医药,辽宁,吉林省,黑龙江省,医药产品,思清,柴芩清宁胶囊";
$this->_metas['title'] = $this->_metas['title'] . "产品世界";
}
/**
* 构造函数
*
* @return Controller_Default
*/
function Controller_News()
{
/**
* FLEA::getSingleton() 会自动载入指定类的定义文件，并且返回该类的唯一一个实例
*/
$this->_modelNews =& FLEA::getSingleton('Model_News');
$this->_metas =& FLEA::getAppInf('metas');
$this->_metas['description'] = "辽宁万维医药有限公司新闻中心";
$this->_metas['keywords'] = "辽宁万维医药,辽宁,吉林省,黑龙江省,医药新闻";
$this->_metas['title'] = $this->_metas['title'] . "新闻中心";
}
function Controller_Prem()
{
$this->_M =& FLEA::getSingleton('Model_Prem');
$this->_V =& $this->_getView();
// 初始化消息对象
FLEA::loadClass("Util_Msg");
$this->_G = new Util_Msg();
// 写入CSS,IMG,JS目录
$this->_V->assign(FLEA::getAppInf("vdir"));
// 初始化导航
FLEA::loadClass("Util_Nav");
$this->_N = new Util_Nav();
}
function checkLogin()
{
if (!isset($this->_smarty)) {
$this->initView();
}
$rbac =& FLEA::getSingleton('FLEA_Rbac');
$user = $rbac->getUser();
if (!$user) {
redirect(url('login', 'index'));
} else {
$this->_smarty->assign('SE', $user);
}
}
function actionindex()
{
//设置标题
$this->_title = '管理首页';
$rbac =& FLEA::getSingleton('FLEA_Rbac');
$user = $rbac->getUser();
//模板赋值
$this->_model =& FLEA::getSingleton('model_user');
$_user = $this->_model->find($user['UID']);
if (isset($_user)) {
$this->_smarty->assign('RepAct', explode(',', $_user['RepAct']));
$this->_smarty->assign('title', $this->_title);
$this->_smarty->display('main.htm');
}
}
/**
* 获取指定用户，及其权限信息
*
* @param array $conditions
*/
function getUserWithPermissions($conditions)
{
$tableUsers =& FLEA::getSingleton($this->_tableClass['users']);
/* @var $tableUsers FLEA_Acl_Table_Users */
$user = $tableUsers->find($conditions);
if (empty($user)) {
return false;
}
// 取得用户所在用户组的层次数据
$tableUserGroups =& FLEA::getSingleton($this->_tableClass['userGroups']);
/* @var $tableUserGroups FLEA_Acl_Table_UserGroups */
$rowset = $tableUserGroups->getPath($user['group']);
// 找出用户组的单一路径
FLEA::loadHelper('array');
$ret = array_to_tree($rowset, 'user_group_id', 'parent_id', 'subgroups', true);
$tree =& $ret['tree'];
$refs =& $ret['refs'];
$groupid = $user['user_group_id'];
$path = array();
while (isset($refs[$groupid])) {
array_unshift($path, $refs[$groupid]);
$groupid = $refs[$groupid]['parent_id'];
}
// 整理角色信息
$userRoles = array();
foreach ($path as $group) {
$roles = $group['roles'];
foreach ($roles as $role) {
$roleid = $role['role_id'];
if ($role['_join_is_include']) {
$userRoles[$roleid] = array('role_id' => $roleid, 'name' => $role['name']);
} else {
unset($userRoles[$roleid]);
}
}
}
foreach ((array) $user['roles'] as $role) {
$roleid = $role['role_id'];
if ($role['_join_is_include']) {
$userRoles[$roleid] = array('role_id' => $roleid, 'name' => $role['name']);
} else {
unset($userRoles[$roleid]);
}
}
// 整理权限信息
$user['roles'] = $userRoles;
return $user;
}
function run()
{
if (count($this->_argv) < 2) {
$this->help();
}
$type = strtolower($this->_argv[1]);
if (!isset($this->_generatorList[$type])) {
$this->help();
} else {
$class = $this->_generatorList[$type]['class'];
$generator =& FLEA::getSingleton($class);
/* @var $generator Generator_Abstract */
$argv = $this->_argv;
array_shift($argv);
array_shift($argv);
$generator->generate($argv);
}
}
function actionchangepwd()
{
$rbac =& FLEA::getSingleton('FLEA_Rbac');
$SE = $rbac->getUser();
if (!$SE) {
$this->writeAjax('300', '你无权执行此操作!', '', '', '');
}
//检查信息是否为空
if (!isset($_POST['oldPassword']) || !isset($_POST['newPassword'])) {
$this->writeAjax('300', '提交信息不完整!', '', '', '');
} else {
$sysuser =& FLEA::getSingleton('model_sysuser');
if ($sysuser->changePassword($SE['USERNAME'], $_POST['oldPassword'], $_POST['newPassword'])) {
$this->writeAjax('200', '修改成功!', 'navNewsLi', 'closeCurrent', '');
} else {
$this->writeAjax('300', '旧密码输入错误!', '', '', '');
}
}
}
/**
* 执行生成器
*
* @param array $opts
*/
function generate($opts)
{
$name = array_shift($opts);
$modelClass = 'Model_' . ucfirst($name);
if ($filename = $this->_existsClassFile($modelClass)) {
echo "Class '{$modelClass}' declare file '{$filename}' exists.\n";
return -1;
}
$tableName = reset($opts);
if (empty($tableName)) {
return -1;
}
if (isset($opts[1])) {
$tableClass = $opts[1];
} else {
$tableClass = 'Table_' . ucfirst($this->_camelName($tableName));
}
/**
* 首先判断需要的表数据入口对象是否存在
*/
if (!$this->_existsClassFile($tableClass)) {
/**
* 创建需要的表数据入口对象
*/
$generatorTable =& FLEA::getSingleton('Generator_Table');
/* @var $generatorTable Generator_Table */
$generatorTable->make($tableName, array($tableClass));
}
FLEA::loadClass('FLEA_Db_TableDataGateway');
$table =& FLEA::getSingleton($tableClass);
$content = $this->_getCode($modelClass, $tableClass, $table);
if ($content !== -1 && !empty($content)) {
return $this->_createClassFile($modelClass, $content);
} else {
return -1;
}
}
/**
* 构造函数
*
* @return Controller_ZobMember
*/
function Controller_ZobMember()
{
parent::Controller_ZobBase();
$this->_modelMembers =& FLEA::getSingleton('Model_Members');
}
public function actionrestoredefault()
{
//发送指令
$message = '<br>';
FLEA::loadClass('Util_socketclient');
$dev_bak = FLEA::getSingleton('Model_devinitialinfo');
$dev = $dev_bak->findAll();
//如果备份表里为空,将退出;
if (!$dev) {
$this->_G->customshow('您当前没有备份的默认值,请先备份', "edit", "Index", 3, 0);
exit;
}
foreach ($dev as $devinfo) {
$socket = new Util_socketclient();
$socket->socketconn($devinfo['ipaddr'], $devinfo['ipport']);
foreach ($devinfo['chninfo'] as $chninfo) {
$sendcommand = $socket->messagetype($chninfo['chn'], $chninfo['apid'], $chninfo['agcstat'], $chninfo['gain'], $chninfo['mutestat'], $chninfo['passstat']);
switch ($socket->sendmessage($sendcommand)) {
case $socket->returntrue:
$this->log->writelog($devinfo['devname'], $sendcommand, $socket->returntrue);
$message .= "设备{$devinfo['devname']}通道号:{$devinfo['chn']}指令发送: [<font color=red><b>{$sendcommand}</b></font>]成功";
$type = '1';
case $socket->returnfalse:
$this->log->writelog($devinfo['devname'], $sendcommand, $socket->returnfalse);
$message .= "<font color=red>设备{$devinfo['devname']}通道号:{$devinfo['chn']}指令发送: [<b>{$sendcommand}</b>]失败</b>";
$type = '0';
}
}
unset($socket);
}
$message .= "<br>备份恢复完成";
$this->_G->customshow($message, 'edit', 'Index', 3, $type);
}
/**
* 构造函数
*
* @return Model_Posts
*/
function Model_Posts()
{
$this->_tbPosts =& FLEA::getSingleton('Table_Posts');
}
/* @var $tableUserGroups FLEA_Acl_Table_UserGroups */
$group = array('name' => '开发组', 'roles' => array($roles['Developer']));
$tableUserGroups->create($group);
$parent = $tableUserGroups->find(array('name' => '开发组'));
$group = array('name' => 'QeePHP Team', 'parent_id' => $parent['user_group_id'], 'roles' => array($roles['Developer']));
$tableUserGroups->create($group);
$group = array('name' => 'PHPChina Team', 'parent_id' => $parent['user_group_id'], 'roles' => array($roles['Developer']));
$tableUserGroups->create($group);
$group = array('name' => '测试组', 'parent_id' => $parent['user_group_id'], 'roles' => array($roles['Tester'], array_merge($roles['Developer'], array('#JOIN#' => array('is_include' => 0)))));
$tableUserGroups->create($group);
$groups = $tableUserGroups->findAll();
$groups = array_to_hashmap($groups, 'name');
/**
* 创建用户，并分配到各个组
*/
$tableUsers =& FLEA::getSingleton('FLEA_Acl_Table_Users');
/* @var $tableUsers FLEA_Acl_Table_Users */
$users = array(array('username' => 'liaoyulei', 'password' => '123456', 'email' => '*****@*****.**', 'user_group_id' => $groups['QeePHP Team']['user_group_id']), array('username' => 'liwei', 'password' => '123456', 'email' => '*****@*****.**', 'user_group_id' => $groups['QeePHP Team']['user_group_id']), array('username' => 'liye', 'password' => '123456', 'email' => '*****@*****.**', 'user_group_id' => $groups['QeePHP Team']['user_group_id']), array('username' => 'dali', 'password' => '123456', 'email' => '*****@*****.**', 'user_group_id' => $groups['QeePHP Team']['user_group_id']));
$tableUsers->createRowset($users);
/**
* 为用户指派单独的角色
*/
$user = $tableUsers->find(array('username' => 'liaoyulei'));
$user['roles'][] = $roles['ProjectManager'];
$tableUsers->update($user);
$user = $tableUsers->find(array('username' => 'liye'));
$user['roles'][] = $roles['Tester'];
$tableUsers->update($user);
$user = $tableUsers->find(array('username' => 'dali'));
$user['roles'][] = $roles['Tester'];
$tableUsers->update($user);
function actionimgCode()
{
/* FLEA_Helper_ImgCode */
$imgcode =& FLEA::getSingleton('FLEA_Helper_ImgCode');
$imgcode->image();
}
/**
* 构造函数
*
* @return Model_SysUsers
*/
function Model_SysUsers()
{
$this->_tbSysUsers =& FLEA::getSingleton('Table_SysUsers');
}
/**
* 构造 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();
}
}
/**
* 返回视图对象
*
* @return object
*/
function &_getView()
{
$viewClass = FLEA::getAppInf('view');
if ($viewClass != 'PHP') {
return FLEA::getSingleton($viewClass);
} else {
$view = false;
return $view;
}
}
function actionflddelete()
{
$rbac =& FLEA::getSingleton('FLEA_Rbac');
$SE = $rbac->getUser();
if (!$SE) {
$this->writeAjax('300', '你无权执行此操作!', '', '', '');
}
$using = new class_using();
$request = $using->safeUsing('get', 'ID:int');
if (!isset($request['ID'])) {
$this->writeAjax('300', '信息不完整', '', '', '');
} else {
$ID = (int) $request['ID'];
$this->_model =& FLEA::getSingleton('model_grid');
if ($this->_model->removeByPkv($ID)) {
$this->writeAjax('200', '删除成功!', '', '', '');
} else {
$this->writeAjax('300', '删除失败!', '', '', '');
}
}
}
/**
* 构造函数
*
* @param array $request
*
* @return FLEA_Dispatcher_Auth
*/
function FLEA_Dispatcher_Auth(&$request)
{
parent::FLEA_Dispatcher_Simple($request);
$this->_auth =& FLEA::getSingleton(FLEA::getAppInf('dispatcherAuthProvider'));
}
function __construct()
{
$this->chninitialinfo = FLEA::getSingleton('Model_chninitialinfo');
}
