/**
* 导出
*/
public function view_export()
{
$where = '';
$idStr = $_GET['idArr'];
if (!empty($idStr)) {
$where .= ' and pp.id in (' . $idStr . ')';
}
$field = " pp.id,pp.companyName,pp.companyType,pp.contactPerson,pp.expiration,pp.status,pp.is_delete,\n\t\t\t\tpp.addTime,pp.modifyTime,pp.addUserId,pp.modifyUserId ";
$result = AgreementModel::getData($where, $field);
if (empty($result)) {
die("无数据");
}
$companyTypeList = array('1' => '企业法人', '2' => '个体经营');
$statusList = array('1' => '正常', '2' => '限制');
require_once WEB_PATH . "lib/PHPExcel.php";
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '公司名称');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', '公司类型');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '联系人');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '协议到期时间');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '状态');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '是否删除');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', '添加时间');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '添加人');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '修改时间');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', '修改人');
$a = 2;
$userModel = UserModel::getInstance();
foreach ($result as $key => $val) {
$companyType = $companyTypeList[$val['companyType']];
$status = $statusList[$val['status']];
$is_delete = $val['is_delete'] == 1 ? '是' : '否';
$where = "where a.global_user_id='{$val['addUserId']}'";
$userinfo = $userModel->getGlobalUserLists('a.global_user_name', $where, '', 'limit 1');
$addUser = $userinfo[0]['global_user_name'];
$modifyTime = '';
$modifyUser = '';
if ($val['modifyTime']) {
$modifyTime = date('Y-m-d H:i', strtotime($val['modifyTime']));
$where = "where a.global_user_id='{$val['modifyUserId']}'";
$userinfo = $userModel->getGlobalUserLists('a.global_user_name', $where, '', 'limit 1');
$modifyUser = $userinfo[0]['global_user_name'];
}
$objPHPExcel->setActiveSheetIndex(0)->getCell('A' . $a)->setValueExplicit($val['companyName'], PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('B' . $a)->setValueExplicit($companyType, PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('C' . $a)->setValueExplicit($val['contactPerson'], PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('D' . $a)->setValueExplicit(date('Y-m-d', strtotime($val['expiration'])), PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('E' . $a)->setValueExplicit($status, PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('F' . $a)->setValueExplicit($is_delete, PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('G' . $a)->setValueExplicit(date('Y-m-d H:i', strtotime($val['addTime'])), PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('H' . $a)->setValueExplicit($addUser, PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('I' . $a)->setValueExplicit($modifyTime, PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->getCell('J' . $a)->setValueExplicit($modifyUser, PHPExcel_Cell_DataType::TYPE_STRING);
$a++;
}
$objPHPExcel->getActiveSheet(0)->getStyle('A1:R500')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('I')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('J')->setWidth(20);
$title = "AgreementInfo" . date('Y-m-d');
$titlename = "AgreementInfo" . date('Y-m-d') . ".xls";
$objPHPExcel->getActiveSheet()->setTitle($title);
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename={$titlename}");
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
/**
* AgreementModel::getList()
* 获取列表
* @param string $where
* @param string $limit
* @return array
*/
public static function getList($where = null, $limit = null)
{
try {
self::initDB();
$where = is_null($where) ? self::getWhere() : $where;
$limit = is_null($limit) ? self::getLimit() : $limit;
$sqlStr = "select * from ph_agreement where {$where} ";
//file_put_contents(WEB_PATH.'log/sql.txt', var_export($_GET,true)."\r\n\r\n", FILE_APPEND);//test
//file_put_contents(WEB_PATH.'log/sql.txt', $sqlStr."\r\n\r\n", FILE_APPEND);//test
//echo $sqlStr;exit;
$sql = self::$dbConn->execute($sqlStr);
$totalNum = self::$dbConn->num_rows($sql);
$sql = $sqlStr . "{$limit}";
$sql = self::$dbConn->execute($sql);
$listData = self::$dbConn->getResultArray($sql);
$data = array("totalNum" => $totalNum, "listData" => $listData);
return $data;
} catch (Exception $e) {
self::$errCode = 10000;
self::$errMsg = $e->getMessage();
return false;
}
}
/**
* check
*/
public function checkCompanyExist()
{
$companyName = $_POST['companyName'];
$row = AgreementModel::getByCompanyName($companyName);
if (!empty($row)) {
$arr = array('code' => 1, 'msg' => '公司名称已存在');
} else {
$arr = array('code' => 0, 'msg' => '公司名称不存在');
}
return json_encode($arr);
}
