public function actionSaveTemplate()
{
$request = Yii::$app->request;
if ($request->isPost) {
$model_upload = new UploadForm();
$model_upload->file = UploadedFile::getInstanceByName('DocContent');
if ($model_upload->validate()) {
$id = $request->get("id");
$model = DocumentTemplate::find()->where(["DocumentID" => $id])->one();
if (!$model) {
$model = new DocumentTemplate();
}
$model->DocumentID = $id;
$model->URL = "/uploads/print/template/test.doc";
$model->save();
$model->URL = "/uploads/print/template/" . $model->ID . ".doc";
$model->save();
$path = dirname(Yii::$app->basePath) . $model->URL;
if ($model_upload->file->saveAs($path)) {
echo "success";
exit;
}
} else {
echo "failed";
}
}
}
public function actionUpload($documentID = null)
{
Yii::$app->response->format = Response::FORMAT_JSON;
$result = ['success' => false];
$uploadForm = new UploadForm();
$uploadForm->file = UploadedFile::getInstanceByName('file');
$uploadForm->documentID = $documentID;
if ($uploadForm->validate() && $uploadForm->upload()) {
$result['success'] = true;
}
return $result;
}
public function actionUpload()
{
$model = new UploadForm();
$username = Yii::$app->session['username'];
$user = User::find()->where(['username' => $username])->one();
if (Yii::$app->request->isPost) {
$model->file = UploadedFile::getInstanceByName('file');
$name = time();
$url = Yii::$app->basePath . "/web" . '/';
if ($model->validate()) {
$model->file->saveAs($url . 'images/' . $name . '.' . $model->file->extension);
$user->facepic = "images/" . $name . '.' . $model->file->extension;
$user->save();
}
}
echo "1";
}
public function actionEdit()
{
$request = Yii::$app->request;
if (Yii::$app->request->isPost) {
$model_upload = new UploadForm();
//var_dump($_FILES);
$model_upload->file = UploadedFile::getInstanceByName('DocContent');
if ($model_upload->validate()) {
$model = Report::find()->where(["ID" => $request->get("id")])->one();
$path = "/uploads/report/" . $model->Type . "/" . $model->UID;
$filename = dirname(Yii::getAlias('@app')) . $path . "/" . $model->ID . '.' . $model_upload->file->extension;
if ($model_upload->file->saveAs($filename)) {
echo "success";
exit;
}
}
}
echo "failed";
}
public function actionImport()
{
$model = new UploadForm();
$request = Yii::$app->request;
$arr = [];
if ($request->isPost) {
$model->file = UploadedFile::getInstanceByName('file');
if ($model->validate()) {
$path = dirname(Yii::getAlias('@app')) . '/uploads/' . $this->depart_id . 'import.' . $model->file->extension;
$model->file->saveAs($path);
error_reporting(E_ALL);
date_default_timezone_set('Asia/shanghai');
$objPHPExcel = new \PHPExcel();
$objReader = \PHPExcel_IOFactory::createReaderForFile($path);
$objPHPExcel = $objReader->load($path);
$objPHPExcel->setActiveSheetIndex(0);
$objWorksheet = $objPHPExcel->getActiveSheet();
$i = 0;
foreach ($objWorksheet->getRowIterator() as $row) {
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
foreach ($cellIterator as $cell) {
$value = $cell->getFormattedValue();
$arr[$i][] = $value;
}
$i++;
}
}
}
$script = <<<JS
\$("#pop .pop-title", window.parent.document).html("{$this->_model->type}导入");
\$("#footer").append('<input type="button" name="delColSelected" value="删除选定列"> | ');
\$("#footer").append('<input type="button" name="delRowSelected" value="删除选定行"> | ');
\$("#footer").append('<input type="button" name="cleanColSelected" value="清除选定列"> | ');
\$("#footer").append('<input type="text" name="ACol" size="3">O<input type="text" name="BCol" size="3"><input type="button" name="DH" value="倒换"> |');
\$("#footer").append('<input type="text" id="yy" size="4"><input type="button" name="setYear" value="设置年份"> |');
JS;
$this->layout = "edit";
return $this->render("import", ["model" => $this->_model, "script" => $script, "excel" => $arr, "action" => $request->get("action")]);
}
