\u524d\u8a00\uff1a
\n\u6700\u8fd1\u5f00\u53d1\u4e00\u6b3ecrm\uff0c\u4f7f\u7528PhalApi\u6846\u67b6\u63d0\u4f9b\u6570\u636e\u63a5\u53e3\uff0c\u8981\u7528\u516c\u5171\u63a5\u53e3\u6765\u5b9e\u73b0\u5404\u4e2a\u6a21\u5757\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa\u529f\u80fd\u3002\u5982\u679c\u662f\u5355\u72ec\u7684\u5bfc\u5165\u5bfc\u51fa\uff08\u4e00\u4e2a\u6a21\u5757\u4e00\u4e2a\u5bfc\u5165\u5bfc\u51fa\u63a5\u53e3\uff09\u63a8\u8350\u5927\u5bb6\u4f7f\u7528 phpoffice\/phpspreadsheet \u3002<\/p>\n
\u6211\u8fd9\u91cc\u4f7f\u7528\u7684\u662f PHPExcel\uff0cPhalApi\u5b98\u7f51\u4e0a\u5173\u4e8ePHPExcel\u6269\u5c55\uff0c\u662f\u57fa\u4e8ePhalApi1.x \u7248\u672c\uff0c\u8fd9\u91cc\u4f7f\u7528\u7684\u662f 2.x \u7248\u672c\uff0c\u6240\u4ee5\u8fd9\u91cc\u4f7f\u7528\u7684\u8ddf\u5b98\u7f51\u7684\u7565\u6709\u4e0d\u540c\u3002\u539f\u56e0\u4e00\uff1a\u4f7f\u7528\u4e00\u4e2a\u63a5\u53e3\u5904\u7406\u591a\u4e2a\u6a21\u5757\u7684\u5bfc\u5165\u6216\u8005\u5bfc\u51fa\uff1b\u539f\u56e0\u4e8c\uff1a\u5728\u5bfc\u51fa\u6a21\u578b\u7684\u65f6\u5019\u8981\u505a\u4e0b\u62c9\u9009\u62e9\u6846\uff08\u5728phpoffice\/phpspreadsheet \u6587\u6863\u4e2d\u6ca1\u6709\u627e\u5230\u76f8\u5173\u5bfc\u51fa\u5e26\u4e0b\u62c9\u7684\u5185\u5bb9\uff0c\u5982\u679c\u6709\u4e86\u89e3\u7684\u5c0f\u4f19\u4f34\u53ef\u4ee5\u7ed9\u6211\u7559\u8a00\u54df\uff09\u3002crm\u540e\u53f0\u5404\u4e2a\u6a21\u5757\u90fd\u6709\u5404\u81ea\u5bf9\u5e94\u7684\u6a21\u578b\u5b57\u6bb5\uff0c\u53ef\u4ee5\u81ea\u884c\u8bbe\u7f6e\u5b57\u6bb5\u7684\u7c7b\u578b[\u6587\u672c\u3001\u5355\u9009\u3001\u591a\u9009\u3001\u4e0b\u62c9\u3001\u65e5\u671f\u3002\u3002\u3002]\u4ee5\u53ca\u5b57\u6bb5\u503c\u3002<\/p>\n
\u4f8b\uff1a\u5ba2\u6237\u6a21\u5757\u7684\u201c\u5ba2\u6237\u610f\u5411\u201d\u548c\u201c\u5ba2\u6237\u7ea7\u522b\u201d\u5b57\u6bb5\uff1a<\/p>\n
<\/p>\n
\u9996\u5148\uff0c\u9700\u8981\u5ba2\u6237\u5728\u5bfc\u5165\u6570\u636e\u4e4b\u524d\uff0c\u4e0b\u8f7d\u5bfc\u5165\u6a21\u578b\u8868\uff0c\u6709\u7075\u6d3b\u5b57\u6bb5\u7684\u60c5\u51b5\u4e0b\uff0c\u9700\u8981\u5728\u5bfc\u51fa\u6a21\u578b\u8868\u7684\u65f6\u5019\uff0c\u5bf9\u7075\u6d3b\u5b57\u6bb5\u8fdb\u884c\u5904\u7406\uff0c\u5c06\u5355\u5143\u683c\u5f0f\u8bbe\u7f6e\u4e3a\u4e0b\u62c9\u9009\u62e9\u6846\uff0c\u4ece\u5b57\u6bb5\u8bbe\u7f6e\u7684\u503c\u4e2d\u9009\u62e9\uff0c\u4f7f\u7528\u6237\u53ea\u80fd\u4ece\u9009\u9879\u4e2d\u9009\u62e9\uff0c\u4ece\u6839\u672c\u4e0a\u4fdd\u8bc1\u5ba2\u6237\u4e0a\u4f20\u6570\u636e\u7684\u6709\u6548\u6027\u3002<\/p>\n
\u4e00\uff1a\u51c6\u5907\u5de5\u4f5c
\n\uff081\uff09\u4e0b\u8f7dPHPExcel\u6587\u4ef6\u5e76\u89e3\u538b\uff0c\u653e\u5728phalapi\/vendor \u6587\u4ef6\u5939\u4e0b \u3002<\/p>\n
\u4e0b\u8f7d\u5730\u5740\uff1ahttps:\/\/download.csdn.net\/download\/qq_32845825\/11949643<\/p>\n
\uff082\uff09\u5728\u6587\u4ef6\u5934\u90e8\u5f15\u5165PHPExcel<\/p>\n
require dirname(dirname(dirname(__DIR__))).'\/vendor\/phpexcel\/PHPExcel.php';\r\nrequire dirname(dirname(dirname(__DIR__))).'\/vendor\/phpexcel\/PHPExcel\/Writer\/Excel5.php';\r\nrequire dirname(dirname(dirname(__DIR__))).'\/vendor\/phpexcel\/PHPExcel\/Writer\/Excel2007.php';\r\nrequire dirname(dirname(dirname(__DIR__))).'\/vendor\/phpexcel\/PHPExcel\/IOFactory.php';\r\nrequire dirname(dirname(dirname(__DIR__))).'\/vendor\/phpexcel\/PHPExcel\/Cell.php';\r\nuse PHPExcel as NOP;\r\nuse PHPExcel_IOFactory;\r\nuse PHPExcel_Writer_Excel2007;\r\nuse PHPExcel_Writer_Excel5;\r\nuse PHPExcel_Cell;<\/pre>\n\u4e8c:\u4e0b\u8f7d\u6570\u636e\u5bfc\u5165\u6a21\u677f<\/h2>\n
\/\/ 17 \u5bfc\u51faExcel\u6a21\u677f\r\npublic function PostExportModelExcel($tablename) {\r\n \/\/ \u8bfb\u53d6\u6570\u636e\u8868\u7684\u5b57\u6bb5\r\n $table_field = $this->config->get('common.TABLE_FIELD');\r\n $field_list = $table_field[$tablename];\r\n \/\/ \u8bfb\u53d6\u6a21\u578b\u7684\u6a21\u578bID\r\n $model_id = $field_list['model_id'];\r\n \r\n \/\/ \u67e5\u8be2\u7075\u6d3b\u5b57\u6bb5\u4ee5\u53ca\u503c\r\n $model_field_arr = $this->di->model_field->select(\"field,name,type,is_require,setting\")->where(array(\"modelid\"=>$model_id,\"master_field\"=>1))->order(\"id DESC\")->limit(15)->fetchRows();\r\n \r\n \/\/ \u5c06\u6a21\u578b\u5b57\u6bb5\u589e\u52a0\u5230\u5b57\u6bb5\u5217\u8868\u4e2d\r\n if (!empty($model_field_arr)) {\r\n foreach ($model_field_arr as $key => $value) {\r\n $field_list['filed'][$value['field']]['name'] = $value['name'];\r\n $field_list['filed'][$value['field']]['type'] = $value['type'];\r\n $field_list['filed'][$value['field']]['is_require'] = $value['is_require'];\r\n $field_list['filed'][$value['field']]['setting'] = $value['setting'];\r\n }\r\n }\r\n $customer_field_list = $field_list['filed'];\r\n \r\n \/\/\u5f15\u5165phpexecl\u670d\u52a1\u542f\u52a8\u6587\u4ef6\r\n $objPHPExcel =new NOP();\r\n $objWriter = new \\PHPExcel_Writer_Excel5($objPHPExcel);\r\n $objWriter = new \\PHPExcel_Writer_Excel2007($objPHPExcel);\r\n $excelModel = new Excel();\r\n \/\/\u8bbe\u7f6e\u5c5e\u6027\r\n $objProps = $objPHPExcel->getProperties();\r\n $objProps->setCreator(\"WJZ\");\r\n $objProps->setLastModifiedBy(\"WJZ\");\r\n $objProps->setTitle(\"WJZ\");\r\n $objProps->setSubject(\"WJZ data\");\r\n $objProps->setDescription(\"WJZ data\");\r\n $objProps->setKeywords(\"WJZ data\");\r\n $objProps->setCategory(\"WJZ\");\r\n $objPHPExcel->setActiveSheetIndex(0);\r\n $objActSheet = $objPHPExcel->getActiveSheet();\r\n $objActSheet->setTitle($field_list['model_name'].'\u5bfc\u5165\u6a21\u677f'.date('Y-m-d',time()));\r\n \r\n \/\/\u586b\u5145\u8fb9\u6846\r\n $styleArray = [\r\n 'borders'=>[\r\n 'outline'=>[\r\n 'style'=>\\PHPExcel_Style_Border::BORDER_THICK, \/\/\u8bbe\u7f6e\u8fb9\u6846\r\n 'color' => ['argb' => '#F0F8FF'], \/\/\u8bbe\u7f6e\u989c\u8272\r\n ],\r\n ],\r\n ];\r\n \r\n $k = 0;\r\n $k = 0;\r\n foreach ($customer_field_list as $field) {\r\n $objActSheet->getColumnDimension($excelModel->stringFromColumnIndex($k))->setWidth(20); \/\/\u8bbe\u7f6e\u5355\u5143\u683c\u5bbd\u5ea6\r\n \/\/ \u5982\u679c\u6570\u636e\u683c\u5f0f\u4e3a\u4e0b\u62c9\u3001\u591a\u9009\u3001\u5355\u9009\uff0c\u5bf9\u5b57\u6bb5\u503c\u8fdb\u884c\u5904\u7406\r\n if ($field['type'] == 'select' || $field['type'] == 'checkbox' || $field['type'] == 'radio') {\r\n if (!empty($field['setting']) && !is_array($field['setting'])) {\r\n $setting = json_decode($field['setting'],true) ? : [];\r\n } else {\r\n $setting = $field['setting'];\r\n }\r\n $select_value = implode(',',$setting);\r\n }\r\n \/\/ \u5982\u679c\u6570\u636e\u683c\u5f0f\u4e3asql\uff0c\u5373\u8be5\u5b57\u6bb5\u9700\u8981\u4ece\u5176\u4ed6\u8868\u6570\u636e\u4e2d\u83b7\u53d6\u503c\r\n if ($field['type'] == 'sql') {\r\n $table_name = $field['from_table'];\r\n $sql = \"SELECT id,CONCAT_WS('_',id,title) as title FROM \".$this->prefix.$table_name.\" WHERE status = 1 LIMIT 50 \";\r\n $setting_arr = $this->di->$table_name->queryAll($sql);\r\n $setting = array_column($setting_arr, \"title\");\r\n $select_value = implode(',',$setting);\r\n }\r\n \r\n \/\/ \u5982\u679c\u5b57\u6bb5\u6709\u503c\uff0c\u5c06\u8be5\u5b57\u6bb5\u6240\u5728\u5217\u8bbe\u7f6e\u4e3a\u4e0b\u62c9\u9009\u62e9\u6846\r\n if ($select_value) {\r\n for ($c=3; $c<=70; $c++) {\r\n \/\/\u6570\u636e\u6709\u6548\u6027 start\r\n $objValidation = $objActSheet->getCell($excelModel->stringFromColumnIndex($k).$c)->getDataValidation(); \/\/\u8fd9\u4e00\u53e5\u4e3a\u8981\u8bbe\u7f6e\u6570\u636e\u6709\u6548\u6027\u7684\u5355\u5143\u683c\r\n $objValidation -> setType(\\PHPExcel_Cell_DataValidation::TYPE_LIST)\r\n -> setErrorStyle(\\PHPExcel_Cell_DataValidation::STYLE_INFORMATION)\r\n -> setAllowBlank(false)\r\n -> setShowInputMessage(true)\r\n -> setShowErrorMessage(true)\r\n -> setShowDropDown(true)\r\n -> setErrorTitle('\u8f93\u5165\u7684\u503c\u6709\u8bef')\r\n -> setError('\u60a8\u8f93\u5165\u7684\u503c\u4e0d\u5728\u4e0b\u62c9\u6846\u5217\u8868\u5185.')\r\n -> setPromptTitle('--\u8bf7\u9009\u62e9--')\r\n -> setFormula1('\"'.$select_value.'\"');\r\n \/\/\u6570\u636e\u6709\u6548\u6027 end\r\n }\r\n }\r\n \r\n \/\/\u68c0\u67e5\u8be5\u5b57\u6bb5\u82e5\u5fc5\u586b\uff0c\u52a0\u4e0a\"*\"\r\n $field['name'] = \\App\\sign_required($field['is_require'], $field['name']);\r\n $objActSheet->getStyle($excelModel->stringFromColumnIndex($k).'2')->applyFromArray($styleArray);\/\/\u586b\u5145\u6837\u5f0f\r\n $objActSheet->setCellValue($excelModel->stringFromColumnIndex($k).'2', $field['name']);\r\n \r\n $k++;\r\n }\r\n $max_customer_column = $excelModel->stringFromColumnIndex($k-1);\r\n $mark_customer = $excelModel->stringFromColumnIndex($k);\r\n \r\n $objActSheet->mergeCells('A1:'.$max_customer_column.'1');\r\n $objActSheet->getStyle('A1:'.$mark_customer.'1')->getAlignment()->setHorizontal(\\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); \/\/\u6c34\u5e73\u5c45\u4e2d\r\n $objActSheet->getStyle('A1:'.$mark_customer.'1')->getAlignment()->setVertical(\\PHPExcel_Style_Alignment::VERTICAL_CENTER); \/\/\u5782\u76f4\u5c45\u4e2d\r\n $objActSheet->getRowDimension(1)->setRowHeight(28); \/\/\u8bbe\u7f6e\u884c\u9ad8\r\n $objActSheet->getStyle('A1')->getFont()->getColor()->setARGB('FFFF0000');\r\n $objActSheet->getStyle('A1')->getAlignment()->setWrapText(true);\r\n \/\/\u7ed9\u5355\u5143\u683c\u586b\u5145\u80cc\u666f\u8272\r\n $objActSheet->getStyle('A1:'.$max_customer_column.'1')->getFill()->setFillType(\\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('#ff9900');\r\n $content = $field_list['model_name'].'\u4fe1\u606f\uff08*\u4ee3\u8868\u5fc5\u586b\u9879\uff09';\r\n $objActSheet->setCellValue('A1', $content);\r\n $objActSheet->getStyle('A1:'.$max_customer_column.'1')->getBorders()->getAllBorders()->setBorderStyle(\\PHPExcel_Style_Border::BORDER_THIN);\r\n $objActSheet->getStyle('A1')->getBorders()->getRight()->getColor()->setARGB('#000000');\r\n $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');\r\n ob_end_clean();\r\n header(\"Content-Type: application\/vnd.ms-excel;\");\r\n header(\"Content-Disposition:attachment;filename=\".$field_list['model_name'].\"\u4fe1\u606f\u5bfc\u5165\u6a21\u677f\".date('Y-m-d',time()).\".xls\");\r\n header(\"Pragma:no-cache\");\r\n header(\"Expires:0\");\r\n $objWriter->save('php:\/\/output');\r\n return $rs = array('code'=>1,'msg'=>'000000','data'=>array(),'info'=>array());\r\n}<\/pre>\n\u4e09\uff1a\u5bfc\u5165\u6570\u636e<\/h2>\n
\/\/ 18 Excel\u6587\u4ef6\u5bfc\u5165\r\npublic function PostImportExcel($type,$file,$uid) {\r\n \/\/ \u67e5\u770b\u6587\u4ef6\u683c\u5f0f\u662f\u5426\u6b63\u786e\r\n if ($file['error'] == 4) {\r\n return array('code'=>0,'msg'=>'000080','data'=>array(),'info'=>array());\r\n }\r\n $ext = \\APP\\getExtension($file['name']);\/\/\u83b7\u53d6\u6587\u4ef6\u540e\u7f00\r\n $excel_type = array('xls','csv','xlsx');\r\n if (!in_array($ext,$excel_type)){\r\n return array('code'=>0,'msg'=>'000081','data'=>array(),'info'=>array());\r\n }\r\n \r\n \/\/ \u4e0a\u4f20\u6587\u4ef6\r\n $upload_arr = $this->UploadFile($file,4);\r\n if ($upload_arr['data']['file_path'] == \"\") {\r\n return array('code'=>0,'msg'=>'000082','data'=>array(),'info'=>array());\r\n }\r\n $savePath = dirname(dirname(dirname(__DIR__))).$upload_arr['data']['file_path'];\r\n $admin_common = new AdminCommon();\r\n $customer_common = new CustomerCommon();\r\n \r\n \/\/ \u6570\u636e\u5904\u7406\r\n $table_field = $this->config->get('common.TABLE_FIELD');\r\n $field_arr = $table_field[$type];\r\n $field_list = $field_arr['filed'];\/\/\u5b57\u6bb5\u5217\u8868\r\n $model_id = $field_arr['model_id'];\/\/\u6a21\u578bID\r\n \r\n \r\n \/\/ \u67e5\u8be2\u7075\u6d3b\u5b57\u6bb5\u4ee5\u53ca\u503c\r\n $model_field_arr = $this->di->model_field->select(\"field,name,type,is_require,setting\")->where(array(\"modelid\"=>$model_id,\"master_field\"=>1))->order(\"id DESC\")->limit(15)->fetchRows();\r\n $model_field_name_arr = array();\r\n if (!empty($model_field_arr)) {\r\n foreach ($model_field_arr as $key => $value) {\r\n $model_field_name_arr[] = $value['name'];\r\n $field_list[$value['field']]['name'] = $value['name'];\r\n $field_list[$value['field']]['type'] = $value['type'];\r\n $field_list[$value['field']]['is_require'] = $value['is_require'];\r\n $field_list[$value['field']]['setting'] = $value['setting'];\r\n }\r\n }\r\n \r\n $fieldArr = [];\r\n $requireField = []; \/\/\u5fc5\u586b\u5b57\u6bb5\r\n foreach ($field_list as $key => $value) {\r\n $fieldArr[$value['name']]['name'] = $key;\r\n $fieldArr[$value['name']]['type'] = $value['type'];\r\n if ($value['is_require'] == 1) $requireField[] = $key;\r\n if (isset($value['setting'])) {\r\n $fieldArr[$value['name']]['setting'] = $value['setting'];\r\n }\r\n }\r\n \r\n $field_num = count($fieldArr);\/\/\u5b57\u6bb5\u4e2a\u6570\r\n \r\n \/\/\u9ed8\u8ba4\u6570\u636e\r\n $defaultData = array(); \r\n $user_info = $this->di->user->select(\"username,structure_id\")->where(array(\"id\"=>$uid))->fetchOne();\r\n $defaultData['publisher'] = $user_info['username'];\r\n $defaultData['addtime'] = time();\r\n $defaultData['updatetime'] = time();\r\n $defaultData['status'] = 1;\r\n $defaultData['sort'] = 0;\r\n \r\n \/\/ \u9a8c\u91cd\u5b57\u6bb5\r\n switch ($type) {\r\n case 'customer':\r\n $uniqueField = 'cname';\r\n break;\r\n default:\r\n $uniqueField = 'title';\r\n break;\r\n }\r\n \r\n $objPHPExcel =new NOP();\r\n if ($ext =='xlsx') {\r\n $objWriter = new \\PHPExcel_Writer_Excel2007($objPHPExcel);\r\n $objRender = \\PHPExcel_IOFactory::createReader('Excel2007');\r\n \/\/ $objRender->setReadDataOnly(true);\r\n $ExcelObj = $objRender->load($savePath);\r\n } elseif ($ext =='xls') {\r\n $objWriter = new \\PHPExcel_Writer_Excel2005($objPHPExcel);\r\n $objRender = \\PHPExcel_IOFactory::createReader('Excel2005');\r\n \/\/ $objRender->setReadDataOnly(true);\r\n $ExcelObj = $objRender->load($savePath);\r\n } elseif ($ext=='csv') {\r\n $objWriter = new \\PHPExcel_Reader_CSV($objPHPExcel);\r\n \/\/\u9ed8\u8ba4\u8f93\u5165\u5b57\u7b26\u96c6\r\n $objWriter->setInputEncoding('UTF-8');\r\n \/\/\u9ed8\u8ba4\u7684\u5206\u9694\u7b26\r\n $objWriter->setDelimiter(',');\r\n \/\/\u8f7d\u5165\u6587\u4ef6\r\n $ExcelObj = $objWriter->load($savePath);\r\n }\r\n \r\n $currentSheet = $ExcelObj->getSheet(0);\r\n \/\/\u67e5\u770b\u6709\u51e0\u4e2asheet\r\n $sheetContent = $ExcelObj->getSheet(0)->toArray();\r\n \/\/\u8bfb\u53d6\u8868\u5934\r\n $excelHeader = $sheetContent[1];\r\n \r\n unset($sheetContent[0]);\r\n unset($sheetContent[1]);\r\n \r\n $keys = 2;\r\n $errorMessage = [];\r\n \r\n foreach ($sheetContent as $kk => $val) {\r\n $data = '';\r\n $k = 0;\r\n $resNameIds = '';\r\n $keys++;\r\n $name = ''; \/\/\u5ba2\u6237\u3001\u7ebf\u7d22\u3001\u8054\u7cfb\u4eba\u7b49\u540d\u79f0\r\n $data = $defaultData; \/\/\u5bfc\u5165\u6570\u636e\r\n $resWhere = ''; \/\/\u9a8c\u91cd\u6761\u4ef6\r\n $resInfo = false; \/\/Excel\u5217\u662f\u5426\u6709\u6570\u636e\r\n $resultInfo = true;\r\n foreach ($excelHeader as $aa => $header) {\r\n if (empty($header)) break;\r\n $fieldName = trim(str_replace('*','',$header));\/\/\u53bb\u6389\u8868\u5934\u7684*\r\n \r\n $info = '';\r\n $info = $val[$k];\r\n if ($info) $resInfo = true;\r\n \/\/ \u5224\u65ad\u5fc5\u586b\u9879\u662f\u5426\u586b\u5199\r\n if ( in_array($fieldArr[$fieldName]['name'],$requireField) && !$info ) {\r\n $errorMessage[] = '\u7b2c'.$keys.'\u884c\u5bfc\u5165\u9519\u8bef,\u5931\u8d25\u539f\u56e0\uff1a'.$fieldName.'\u5fc5\u586b';\r\n $resultInfo = false;\r\n break; \r\n }\r\n \/\/ \u9a8c\u91cd\r\n if (strstr($fieldName,\"\u540d\u79f0\") !== false ) {\r\n $info_id = $this->di->$type->where(array($uniqueField=>$val[$k]))->fetchOne(\"id\");\r\n if ($info_id) {\r\n $errorMessage[] = '\u7b2c'.$keys.'\u884c\u5bfc\u5165\u9519\u8bef,\u5931\u8d25\u539f\u56e0\uff1a'.$field_arr['model_name'].'\u540d\u79f0\u5df2\u5b58\u5728\uff01';\r\n $resultInfo = false;\r\n break;\r\n }\r\n }\r\n \r\n \/\/ \u6574\u7406\u6570\u636e\r\n if (empty($fieldArr[$fieldName]['name'])) continue;\r\n if ($aa <= $field_num) {\r\n $resList = [];\r\n $resList = $this->sheetData($k, $fieldArr, $fieldName, $info, $model_field_name_arr, $type);\r\n $resData[] = $resList['data'];\r\n $k = $resList['k'];\r\n }\r\n }\r\n \r\n if ($resultInfo) {\r\n $result = $this->changeArr($resData); \/\/\u4e8c\u7ef4\u6570\u7ec4\u8f6c\u4e00\u7ef4\u6570\u7ec4\r\n $data = $result ? array_merge($data,$result) : [];\r\n $resDataId = $this->di->$type->insert($data);\r\n $resDataId = $this->di->$type->insert_id();\r\n \r\n if (!$resDataId) {\r\n $errorMessage[] = '\u7b2c'.$keys.'\u884c\u5bfc\u5165\u9519\u8bef,\u5931\u8d25\u539f\u56e0\uff1a\u6570\u636e\u9519\u8bef';\r\n break;\r\n }\r\n }\r\n \r\n }\r\n return $rs = array('code'=>1,'msg'=>'000000','data'=>$errorMessage,'info'=>$errorMessage);\r\n}\r\n \r\n\/**\r\n * excel\u6570\u636e\u5904\u7406\r\n * @author W J Z\r\n * @DateTime 2019-11-01T16:31:44+0800\r\n * @param integer $k [\u884c\u53f7]\r\n * @param [array] $fieldArr [\u5b57\u6bb5\u5217\u8868]\r\n * @param [type] $fieldName [\u5f53\u524d\u5b57\u6bb5\u540d\u79f0]\r\n * @param [type] $info [\u5f53\u524d\u6570\u636e]\r\n * @param [type] $model_field_name_arr [\u7075\u6d3b\u5b57\u6bb5\u5217\u8868]\r\n * @param [type] $type [\u7c7b\u578b(\u533a\u5206\u8868)]\r\n * @return [array] $res [\u5904\u7406\u597d\u7684\u6570\u636e\u7c7b\u578b]\r\n *\/\r\npublic function sheetData($k = 0, $fieldArr, $fieldName, $info, $model_field_name_arr,$type) {\r\n if ($info) {\r\n if ($fieldArr[$fieldName]['type'] == 'address') {\r\n $address = array();\r\n for ($i=0; $i<3; $i++) {\r\n $address[] = $val[$k];\r\n $k++;\r\n }\r\n $data[$fieldArr[$fieldName]['name']] = implode(chr(10), $address);\r\n } elseif ($fieldArr[$fieldName]['type'] == 'sql') {\r\n \/\/ \u5982\u679c\u5b57\u6bb5\u7c7b\u578b\u4e3asql \u5b58\u50a8\u5173\u8054ID\r\n $info_arr = explode('_',$info);\r\n $data[$fieldArr[$fieldName]['name']] = $info_arr[0];\r\n $k++;\r\n } elseif ($fieldArr[$fieldName]['type'] == 'date') {\r\n \/\/ \u5982\u679c\u5b57\u6bb5\u7c7b\u578b\u4e3adate \r\n $data[$fieldArr[$fieldName]['name']] = $info ? date('Y-m-d',strtotime($info)) : '';\r\n $k++;\r\n } elseif ($fieldArr[$fieldName]['type'] == 'datetime') {\r\n \/\/ \u5982\u679c\u5b57\u6bb5\u7c7b\u578b\u4e3adatetime\r\n $data[$fieldArr[$fieldName]['name']] = $info ? strtotime($info) : 0;\r\n $k++;\r\n } elseif (!in_array($fieldName,$model_field_name_arr) && $fieldArr[$fieldName]['type'] == 'radio' ) {\r\n \/\/ \u975e\u81ea\u5b9a\u4e49\u5b57\u6bb5&&\u9009\u62e9\u6846\u7c7b\u578b\r\n $setting = $fieldArr[$fieldName]['setting'];\r\n foreach ($setting as $sk => $sv) {\r\n if ($info == $sv) {\r\n $setting_value = $sk;\r\n break;\r\n }\r\n }\r\n $data[$fieldArr[$fieldName]['name']] = $setting_value ? $setting_value : 0;\r\n $k++;\r\n } elseif (in_array($fieldName,$model_field_name_arr) && ($fieldArr[$fieldName]['type'] == 'radio' || $fieldArr[$fieldName]['type'] == 'select') ) {\r\n \/\/ \u81ea\u5b9a\u4e49\u5b57\u6bb5&&[\u5355\u9009||\u4e0b\u62c9]\r\n $data[$fieldArr[$fieldName]['name']] = strval($info);\r\n $k++;\r\n } elseif (in_array($fieldName,$model_field_name_arr) && $fieldArr[$fieldName]['type'] == 'checkbox') {\r\n \/\/ \u81ea\u5b9a\u4e49\u5b57\u6bb5&&\u591a\u9009\r\n $info_arr = explode(',',$info);\r\n $data[$fieldArr[$fieldName]['name']] = json_encode($info_arr,JSON_UNESCAPED_UNICODE);\r\n $k++;\r\n }else {\r\n \/\/ \u6587\u672c\u7c7b[\u8fd9\u91cc\u6ce8\u610f\uff0c\u8981\u4f7f\u7528strval\u51fd\u6570\u5bf9\u6570\u636e\u8fdb\u884c\u5904\u7406\uff0c\u5426\u5219\uff0c\u9047\u5230\u624b\u673a\u53f7\u3001\u91d1\u94b1\u8fd9\u79cd\u7c7b\u578b\u7684\uff0c\u5b58\u50a8\u5230\u6570\u636e\u5e93\u4f1a\u672b\u5c3e\u591a\u51fa\u5f88\u591a0] \r\n $data[$fieldArr[$fieldName]['name']] = strval($info) ? : '';\r\n $k++;\r\n } \r\n } else {\r\n \/\/ \u5982\u679c\u6570\u636e\u4e3a\u7a7a\uff0c\u5bf9\u7279\u5b9a\u7684\u4e00\u4e9b\u6570\u636e\u8fdb\u884c\u5904\u7406\r\n if ($fieldArr[$fieldName]['type'] == 'price' || $fieldArr[$fieldName]['type'] == 'datetime') {\r\n $data[$fieldArr[$fieldName]['name']] = 0;\r\n } else {\r\n $data[$fieldArr[$fieldName]['name']] = '';\r\n }\r\n $k++;\r\n }\r\n $res['data'] = $data;\r\n $res['k'] = $k;\r\n return $res;\r\n}\r\n \r\n\/\/\u4e8c\u7ef4\u6570\u7ec4\u8f6c\u4e00\u7ef4\u6570\u7ec4\r\npublic function changeArr($arr)\r\n{\r\n $newArr = [];\r\n foreach ($arr as $v) {\r\n if ($v && is_array($v)) {\r\n $newArr = array_merge($newArr,$v);\r\n } else {\r\n continue;\r\n }\r\n }\r\n return $newArr;\r\n}<\/pre>\n\u56db\uff1a\u603b\u7ed3<\/h2>\n
\u7ecf\u8fc7\u4e0a\u9762\u7684\u4ee3\u7801\u5904\u7406\uff0c\u5c31\u53ef\u4ee5\u5b8c\u6210\u4e0b\u8f7d\u5bfc\u5165\u6a21\u578b\u4ee5\u53ca\u6570\u636e\u7684\u5bfc\u5165\u4e86\u3002\u5982\u679c\u9700\u8981\u5bfc\u51fa\u6570\u636e\uff0c\u53ea\u9700\u8981\u5728\u7b2c\u4e8c\u6b65\u7684\u5904\u7406\u4e2d\uff0c\u67e5\u8be2\u9700\u8981\u5bfc\u51fa\u7684\u6570\u636e\uff0c\u5e76\u4e14\u7a0d\u4f5c\u4fee\u6539\u5c31\u53ef\u4ee5\u4e86\u3002\u4eca\u5929\u5c31\u5230\u8fd9\u91cc\u4e86\uff0c\u4e0b\u6b21\u4f1a\u638c\u63e1\u4ec0\u4e48\u6280\u80fd\u5462\uff1f\u4e0b\u6b21\u89c1\u54af~<\/p>\n","protected":false},"excerpt":{"rendered":"
\u524d\u8a00\uff1a \u6700\u8fd1\u5f00\u53d1\u4e00\u6b3ecrm\uff0c\u4f7f\u7528PhalApi\u6846\u67b6\u63d0\u4f9b\u6570\u636e\u63a5\u53e3\uff0c\u8981\u7528\u516c\u5171\u63a5\u53e3\u6765\u5b9e\u73b0\u5404\u4e2a\u6a21\u5757\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa\u529f\u80fd\u3002 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[138,37],"class_list":["post-1682","post","type-post","status-publish","format-standard","hentry","category-php","tag-phalapi","tag-phpexcel"],"_links":{"self":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/1682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1682"}],"version-history":[{"count":1,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/1682\/revisions"}],"predecessor-version":[{"id":1683,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/1682\/revisions\/1683"}],"wp:attachment":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}