public function statisticsAction()
{
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
if ($option == 'data') {
$doc_type = isset($request['doc_type']) && $request['doc_type'] != '' ? $request['doc_type'] : null;
$transaction_type = isset($request['transaction_type']) && $request['transaction_type'] != '' ? $request['transaction_type'] : null;
} else {
$doc_type = isset($request['doc_type']) && $request['doc_type'] != '' ? json_encode(explode(',', $request['doc_type'])) : null;
$transaction_type = isset($request['transaction_type']) && $request['transaction_type'] != '' ? json_encode(explode(',', $request['transaction_type'])) : null;
}
$warehouse_type = isset($request['warehouse_type']) && $request['warehouse_type'] != 'null' ? $request['warehouse_type'] : null;
$warehouse = isset($request['warehouse']) && $request['warehouse'] != 'null' ? $request['warehouse'] : null;
$key = isset($request['key']) ? $request['key'] : '';
$date_from = isset($request['date_from']) ? $request['date_from'] : date('Y-m-01');
$date_to = isset($request['date_to']) ? $request['date_to'] : date('Y-m-t');
$page = isset($request['page']) ? $request['page'] : 1;
$limit = isset($request['limit']) ? $request['limit'] : 0;
$stock = new Erp_Model_Stock_Stock();
// 查询条件
$condition = array('warehouse_type' => $warehouse_type, 'warehouse' => $warehouse, 'doc_type' => $doc_type, 'transaction_type' => $transaction_type, 'key' => $key, 'date_from' => $date_from, 'date_to' => $date_to, 'page' => $page, 'limit' => $limit, 'type' => $option);
$data = $stock->getStatisticsData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '库存交易统计');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getorderAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$condition = array('key' => isset($request['key']) ? $request['key'] : '', 'state' => isset($request['state']) && is_numeric($request['state']) ? $request['state'] : null, 'status' => isset($request['status']) && is_numeric($request['status']) ? $request['status'] : null, 'date_from' => isset($request['date_from']) ? $request['date_from'] : null, 'date_to' => isset($request['date_to']) ? $request['date_to'] : null, 'type' => isset($request['type']) && $request['type'] != 'null' ? $request['type'] : null, 'sales' => isset($request['sales']) && $request['sales'] != 'null' ? $request['sales'] : null, 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'option' => $option);
$order = new Erp_Model_Sale_Order();
$data = $order->getOrderStatistics($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '销售订单统计');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getdataAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : null;
$condition = array('key' => isset($request['key']) ? $request['key'] : '', 'type' => isset($request['type']) ? $request['type'] : '', 'date_from' => isset($request['date_from']) ? $request['date_from'] : date('Y-m-01'), 'date_to' => isset($request['date_to']) ? $request['date_to'] : date('Y-m-t'), 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'option' => $option);
$operate = new Application_Model_Log_Mail();
$data = $operate->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data);
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function searchAction()
{
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$stock = new Erp_Model_Stock_Stock();
// 查询条件
$condition = array('key' => isset($request['key']) ? $request['key'] : '', 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
$data = $stock->getSearchData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '库存数据');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getwarehouseAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'list';
$condition = array('key' => isset($request['key']) && $request['key'] != '' ? $request['key'] : null, 'type_id' => isset($request['type_id']) && $request['type_id'] != 'null' ? $request['type_id'] : null, 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
$warehouse = new Erp_Model_Warehouse_Warehouse();
$data = $warehouse->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '仓库列表');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getreturnAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$receive = new Erp_Model_Stock_Receive();
// 查询条件
$condition = array('key' => isset($request['key']) ? $request['key'] : '', 'date_from' => isset($request['date_from']) ? $request['date_from'] : null, 'date_to' => isset($request['date_to']) ? $request['date_to'] : null, 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
$data = $receive->getData($condition, null, '采购退货');
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '采购退货');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getreqAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$condition = array('key' => isset($request['key']) ? $request['key'] : '', 'state' => isset($request['state']) && is_numeric($request['state']) ? $request['state'] : null, 'applier' => isset($request['applier']) ? $request['applier'] : null, 'date_from' => isset($request['date_from']) ? $request['date_from'] : null, 'date_to' => isset($request['date_to']) ? $request['date_to'] : null, 'complete' => isset($request['complete']) && $request['complete'] != 'null' ? $request['complete'] : 1, 'type' => isset($request['type']) && $request['type'] != 'null' ? $request['type'] : null, 'dept' => isset($request['dept']) && $request['dept'] != 'null' ? $request['dept'] : null, 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'option' => $option);
$reqItems = new Erp_Model_Purchse_Req();
$data = $reqItems->getReqStatistics($condition);
//echo '<pre>';print_r($data);exit;
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '采购申请统计');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getpricelistAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'list';
$condition = array('key' => isset($request['key']) && $request['key'] != '' ? $request['key'] : null, 'partner_type' => isset($request['partner_type']) && $request['partner_type'] != 'null' ? $request['partner_type'] : null, 'supplier_id' => isset($request['supplier_id']) && $request['supplier_id'] != 'null' ? $request['supplier_id'] : null, 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
//echo '<pre>';print_r($condition);exit;
if ($condition['partner_type'] != null) {
$pricelist = new Erp_Model_Warehouse_Pricelist();
$data = $pricelist->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '价格清单');
} else {
echo Zend_Json::encode($data);
}
}
exit;
}
public function exportcsvAction()
{
$user = new Application_Model_User();
$data = $user->getUserList(array('csv' => true));
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data);
}
public function getnewsAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'list';
$news = new Hra_Model_News();
if ($option == 'list') {
echo Zend_Json::encode($news->getList());
} else {
// 查询条件
$condition = array('key' => isset($request['key']) ? $request['key'] : '', 'date_from' => isset($request['date_from']) ? $request['date_from'] : '', 'date_to' => isset($request['date_to']) ? $request['date_to'] : '', 'type_id' => isset($request['type_id']) ? $request['type_id'] : '', 'type' => $option);
$data = $news->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data);
} else {
echo Zend_Json::encode($data);
}
}
exit;
}
public function getmeetingAction()
{
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$condition = array('key' => isset($request['key']) && $request['key'] != '' ? $request['key'] : null, 'state' => isset($request['state']) ? $request['state'] : null, 'date_from' => isset($request['date_from']) ? $request['date_from'] : date('Y-m-01'), 'date_to' => isset($request['date_to']) ? $request['date_to'] : date('Y-m-t'), 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
$meeting = new Res_Model_Meeting();
$data = $meeting->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '会议预定');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getreqitemslistAction()
{
$request = $this->getRequest()->getParams();
$key = isset($request['key']) && $request['key'] != '' ? $request['key'] : null;
$option = isset($request['option']) && $request['option'] != '' ? $request['option'] : 'data';
$req = new Erp_Model_Purchse_Req();
$data = $req->getReqItemsList($key, $option);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '采购申请列表');
} else {
echo Zend_Json::encode($data);
}
exit;
}
public function getovertimeAction()
{
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'list';
$overtime = new Hra_Model_Attendance_Overtime();
$condition = array('key' => isset($request['key']) ? $request['key'] : null, 'state' => isset($request['state']) ? $request['state'] : null, 'date_from' => isset($request['date_from']) ? $request['date_from'] : date('Y-m-01'), 'date_to' => isset($request['date_to']) ? $request['date_to'] : date('Y-m-t'), 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
$data = $overtime->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '加班记录');
} else {
echo Zend_Json::encode($data);
}
exit;
}
/**
* 获取业务伙伴信息列表
*/
public function getpartnerAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$export = isset($request['export']) ? $request['export'] : 0;
$option = isset($request['option']) ? $request['option'] : 'data';
$type = isset($request['type']) ? $request['type'] : 0;
$partner = new Erp_Model_Partner();
if ($option == 'list') {
echo Zend_Json::encode($partner->getList($type));
} else {
// 查询条件
$condition = array('type' => isset($request['type']) ? $request['type'] : 0, 'key' => isset($request['key']) ? $request['key'] : '', 'group' => isset($request['group_id']) ? $request['group_id'] : '', 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'export' => $export);
$data = $partner->getData($condition);
if ($export) {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '业务伙伴');
} else {
echo Zend_Json::encode($data);
}
}
exit;
}
/**
* 获取员工列表
*/
public function getemployeeAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'list';
$badgenumber = isset($request['badgenumber']) ? $request['badgenumber'] : 0;
$employee = new Hra_Model_Employee();
if ($option == 'list') {
echo Zend_Json::encode($employee->getList($badgenumber));
} else {
// 查询条件
$condition = array('active' => isset($request['active']) ? $request['active'] : 1, 'leader' => isset($request['leader']) ? $request['leader'] : 0, 'key' => isset($request['key']) && $request['key'] != 'undefined' ? $request['key'] : '', 'entry_date_from' => isset($request['entry_date_from']) ? $request['entry_date_from'] : '', 'entry_date_to' => isset($request['entry_date_to']) ? $request['entry_date_to'] : '', 'dept_id' => isset($request['dept_id']) ? $request['dept_id'] : '', 'employment_type' => isset($request['employment_type']) ? $request['employment_type'] : '', 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'type' => $option);
$data = $employee->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '员工数据');
} else {
echo Zend_Json::encode($data);
}
}
exit;
}
public function getcatalogAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$catalog = new Product_Model_Catalog();
// 查询条件
$condition = array('active' => isset($request['active']) ? $request['active'] : 1, 'key' => isset($request['key']) ? $request['key'] : '', 'date_from' => isset($request['date_from']) ? $request['date_from'] : null, 'date_to' => isset($request['date_to']) ? $request['date_to'] : null, 'display_deleted' => isset($request['display_deleted']) ? $request['display_deleted'] == 'true' ? 1 : 0 : 0, 'type_id' => isset($request['type_id']) && $request['type_id'] != 'null' ? $request['type_id'] : '', 'series_id' => isset($request['series_id']) && $request['series_id'] != 'null' ? $request['series_id'] : '', 'have_code' => isset($request['have_code']) && $request['have_code'] != 'null' ? $request['have_code'] : '', 'stage_id' => isset($request['stage_id']) && $request['stage_id'] != 'null' && $request['stage_id'] != 'undefined' ? $request['stage_id'] : '', 'developmode_id' => isset($request['developmode_id']) && $request['developmode_id'] && $request['developmode_id'] != 'undefined' ? $request['developmode_id'] : '', 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0, 'create_user' => isset($request['create_user']) && $request['create_user'] != '' && $request['create_user'] != 'undefined' ? $request['create_user'] : null, 'auditor_id' => isset($request['auditor_id']) && $request['auditor_id'] != '' && $request['auditor_id'] != 'undefined' ? $request['auditor_id'] : null, 'evt_date' => isset($request['evt_date']) && $request['evt_date'] != 'null' ? substr($request['evt_date'], 0, 10) : null, 'dvt_date' => isset($request['dvt_date']) && $request['dvt_date'] != 'null' ? substr($request['dvt_date'], 0, 10) : null, 'qa1_date' => isset($request['qa1_date']) && $request['qa1_date'] != 'null' ? substr($request['qa1_date'], 0, 10) : null, 'qa2_date' => isset($request['qa2_date']) && $request['qa2_date'] != 'null' ? substr($request['qa2_date'], 0, 10) : null, 'mass_production_date' => isset($request['mass_production_date']) && $request['mass_production_date'] != 'null' ? substr($request['mass_production_date'], 0, 10) : null, 'type' => $option);
$data = $catalog->getData($condition);
if ($option == 'csv') {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$h = new Application_Model_Helpers();
$h->exportCsv($data, '产品中心');
} else {
echo Zend_Json::encode($data);
}
exit;
}
