public static function getAttachNameSearch($attachName = "") { $condition = array(); if (!empty($attachName)) { $runIds = array(); foreach (FlowRun::model()->fetchAllAttachID() as $run) { $table = "attachment_" . AttachUtil::getTableId($run["runid"]); $sql = "SELECT 1 FROM {{$table}} WHERE FIND_IN_SET(aid,'{$run["attachmentid"]}') AND filename LIKE '%{$attachName}%'"; $flag = Ibos::app()->db->createCommand()->setText($sql)->queryScalar(); if ($flag) { $runIds[] = $run["runid"]; } } if (!empty($runIds)) { $condition[] = sprintf("FIND_IN_SET(fr.runid,'%s')", implode(",", $runIds)); } else { $condition[] = "1=2"; } } return $condition; }
protected function handleImgComponent(&$formData) { foreach ($GLOBALS["_FILES"] as $key => $value) { if (strtolower(substr($key, 0, 5)) == "data_") { $formData["{$key}"] = ""; $old = $_POST["imgid_" . substr($key, 5)]; if ($value["name"] != "") { if (!empty($old)) { AttachUtil::delAttach($old); } $upload = FileUtil::getUpload($_FILES[$key], "workflow"); $upload->save(); $attach = $upload->getAttach(); $attachment = "workflow/" . $attach["attachment"]; $imgData = array("dateline" => TIMESTAMP, "filename" => $attach["name"], "filesize" => $attach["size"], "isimage" => $attach["isimage"], "attachment" => $attachment, "uid" => $this->uid); $aid = Attachment::model()->add(array("uid" => $this->uid, "rid" => $this->runid, "tableid" => AttachUtil::getTableId($this->runid)), true); $imgData["aid"] = $aid; $newAttach = AttachmentN::model()->add(sprintf("rid:%d", $this->runid), $imgData, true); $formData["{$key}"] = $newAttach; } else { $formData["{$key}"] = $old; } } } }