示例#1
0
 public function modifyavatarAction()
 {
     $re = array("returncode" => ReturnCode::$SUCCESS);
     $request = $this->getRequest();
     $user = $this->get('security.context')->getToken()->getUser();
     $dm = $this->get('doctrine.odm.mongodb.document_manager');
     $da = $this->get("we_data_access");
     $login_account = $user->getUsername();
     $photofile = $_FILES['photofile']['tmp_name'];
     if (empty($photofile)) {
         $photofile = tempnam(sys_get_temp_dir(), "we");
         unlink($photofile);
         $somecontent1 = base64_decode($request->get('photodata'));
         if ($handle = fopen($photofile, "w+")) {
             if (!fwrite($handle, $somecontent1) == FALSE) {
                 fclose($handle);
             }
         }
     }
     $photofile_24 = $photofile . "_24";
     $photofile_48 = $photofile . "_48";
     try {
         if (empty($photofile)) {
             throw new \Exception("param is null");
         }
         $im = new \Imagick($photofile);
         $im->scaleImage(48, 48);
         $im->writeImage($photofile_48);
         $im->destroy();
         $im = new \Imagick($photofile);
         $im->scaleImage(24, 24);
         $im->writeImage($photofile_24);
         $im->destroy();
         $table = $da->GetData("staff", "select photo_path,photo_path_small,photo_path_big \n        from we_staff where login_account=?", array((string) $login_account));
         if ($table && $table["staff"]["recordcount"] > 0) {
             Utils::removeFile($table["staff"]["rows"][0]["photo_path"], $dm);
             Utils::removeFile($table["staff"]["rows"][0]["photo_path_small"], $dm);
             Utils::removeFile($table["staff"]["rows"][0]["photo_path_big"], $dm);
         }
         if (!empty($photofile)) {
             $photofile = Utils::saveFile($photofile, $dm);
         }
         if (!empty($photofile_48)) {
             $photofile_48 = Utils::saveFile($photofile_48, $dm);
         }
         if (!empty($photofile_24)) {
             $photofile_24 = Utils::saveFile($photofile_24, $dm);
         }
         $da->ExecSQL("update we_staff set photo_path=?,photo_path_big=?,photo_path_small=? \n        where login_account=?", array((string) $photofile_48, (string) $photofile, (string) $photofile_24, (string) $login_account));
         $message = json_encode(array("path" => $this->container->getParameter('FILE_WEBSERVER_URL') . $photofile));
         $staffMgr = new \Justsy\BaseBundle\Management\Staff($da, $this->get("we_data_access_im"), $user, $this->container->get("logger"), $this->container);
         Utils::sendImPresence($user->fafa_jid, implode(",", $staffMgr->getFriendJidList()), "staff-changeinfo", $message, $this->container, "", "", false, Utils::$systemmessage_code);
         $re["returncode"] = ReturnCode::$SUCCESS;
         $re["fileid"] = $photofile;
         $re["photo_path"] = $photofile_48;
         $re["photo_path_big"] = $photofile;
         $re["photo_path_small"] = $photofile_24;
     } catch (\Exception $e) {
         $re["returncode"] = ReturnCode::$SYSERROR;
         $this->get('logger')->err($e);
     }
     $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
     $response->headers->set('Content-Type', 'text/json');
     return $response;
 }
 public function setgrouplogoAction()
 {
     $request = $this->getRequest();
     $groupid = $request->get("groupid");
     $dm = $this->container->get('doctrine.odm.mongodb.document_manager');
     $da = $this->get('we_data_access_im');
     $photofile = "";
     try {
         $photofile = empty($_FILES['photofile']) ? null : $_FILES['photofile']['tmp_name'];
     } catch (\Exception $e) {
     }
     if (empty($photofile)) {
         $photofile = tempnam(sys_get_temp_dir(), "we");
         unlink($photofile);
         $somecontent1 = base64_decode($request->get('photodata'));
         if ($handle = fopen($photofile, "w+")) {
             if (!fwrite($handle, $somecontent1) == FALSE) {
                 fclose($handle);
             }
         }
     }
     $returncode = "0000";
     $path = "";
     try {
         if (empty($photofile)) {
             throw new \Exception("param is null");
         }
         $im = new \Imagick($photofile);
         $im->scaleImage(120, 120);
         $im->writeImage($photofile);
         $im->destroy();
         $sql = "select logo from im_group where groupid=?;";
         $table = $da->GetData("group", $sql, array((string) $groupid));
         if ($table && $table["group"]["recordcount"] > 0) {
             $file = $table["group"]["rows"][0]["logo"];
             if (!empty($file)) {
                 Utils::removeFile($table["group"]["rows"][0]["logo"], $dm);
             }
         }
         $fileid = "";
         if (!empty($photofile)) {
             $fileid = Utils::saveFile($photofile, $dm);
         }
         $sql = "update im_group set logo=? where groupid=?;";
         try {
             $da->ExecSQL($sql, array((string) $fileid, (string) $groupid));
         } catch (\Exception $e) {
             $this->get("logger")->err($e->getMessage());
         }
         if (!empty($fileid)) {
             $path = $this->container->getParameter('FILE_WEBSERVER_URL');
             $path = $path . $fileid;
         }
         $path = $path . $fileid;
         //发送出席
         $groupMgr = new \Justsy\BaseBundle\Management\GroupMgr($this->get('we_data_access'), $da, $this->container);
         $groupObj = $groupMgr->getGroupMemberJid($groupid);
         $to_jid = $groupObj["member_jid"];
         $groupname = $groupObj["groupname"];
         $user = $this->get('security.context')->getToken()->getUser();
         $nick_name = $user->nick_name;
         $send_jid = $user->fafa_jid;
         if (!empty($to_jid)) {
             $title = "group-changelogo";
             $message = $nick_name . "修改了群(" . $groupname . ")头像!";
             Utils::sendImPresence($send_jid, $to_jid, $title, $message, $this->container, "", "", false, Utils::$systemmessage_code);
         }
     } catch (\Exception $e) {
         $returncode = "9999";
         $this->get("logger")->err($e->getMessage());
     }
     $result = array("returncode" => $returncode, "fileid" => $fileid, "path" => $path);
     $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($result) . ");" : json_encode($result));
     $response->headers->set('Content-Type', 'text/json');
     return $response;
 }
示例#3
0
 public function IndexAction()
 {
     $da = $this->get("we_data_access");
     $user = $this->get('security.context')->getToken()->getUser();
     $eno = $user->eno;
     $username = $user->getUsername();
     $request = $this->getRequest();
     $logo = $request->get("fileid");
     $crop = $request->get("crop");
     $type = $request->get("type");
     $index = $request->get("index");
     if (empty($type)) {
         $re = array("success" => false, "msg" => "请输入type参数值");
         $result = new Response(json_encode($re));
         $result->headers->set('Content-Type', 'text/json');
         return $result;
     }
     $width = 0;
     $height = 0;
     if ($type == 1) {
         $width = 180;
         $height = 180;
     } else {
         if ($type == 2) {
             $width = 400;
             $height = 130;
         } else {
             if ($type == 3) {
                 $width = 640;
                 $height = 1136;
             }
         }
     }
     if (!empty($crop)) {
         $crop = json_decode($crop, true);
     }
     $appid = $request->get("appid");
     $success = true;
     $newfileid = "";
     if (!empty($logo) && !empty($crop)) {
         //源图像另存为
         $doc = $this->get('doctrine.odm.mongodb.document_manager')->getRepository('JustsyMongoDocBundle:WeDocument')->find($logo);
         if (!empty($doc)) {
             $filename1 = strtolower($doc->getName());
             $expname = explode(".", $filename1);
             $expname = $expname[1];
             $src = tempnam(sys_get_temp_dir(), "tmp") . "." . $expname;
             $file = $doc->getFile();
             $filename2 = $file->getFilename();
             $tybes = $file->getBytes();
             $cont = fopen($src, 'w');
             fwrite($cont, $tybes);
             fclose($cont);
             $gd = new \Justsy\BaseBundle\Common\Gd();
             $gd->open($src);
             if ($gd->is_image()) {
                 $gd->crop((int) $crop["x"], (int) $crop["y"], (int) $crop["w"], (int) $crop["h"]);
                 $gd->resize_to($width, $height, 'force');
                 $gd->save_to($src);
                 $dm = $this->get('doctrine.odm.mongodb.document_manager');
                 $doc = new \Justsy\MongoDocBundle\Document\WeDocument();
                 $doc->setName(basename($src));
                 $doc->setFile($src);
                 $dm->persist($doc);
                 $dm->flush();
                 $newfileid = $doc->getId();
             }
             unlink($src);
             //数据记录操作处理
             $field = "";
             if ($type == 1) {
                 $sql = "update we_apps_portalconfig set logo=? where appid=?";
                 $field = "logo as fileid";
             } else {
                 if ($type == 2) {
                     $sql = "update we_apps_portalconfig set login_image=? where appid=?";
                     $field = "login_image as fileid";
                 } else {
                     if ($type == 3) {
                         $sql = "update we_apps_portalconfig set start_image=? where appid=?";
                         $field = "start_image as fileid";
                     } else {
                         if ($type == 4) {
                             $sql = "update we_apps_portalconfig set guide" . $index . "=? where appid=?";
                             $field = "guide" . $index . " as fileid";
                         }
                     }
                 }
             }
             $params = array((string) $newfileid, $appid);
             //记录原来文件id
             $remove_fileid = "";
             try {
                 $remove_sql = "select " . $field . " from we_apps_portalconfig where appid=?;";
                 $ds = $da->GetData("table", $remove_sql, array((string) $appid));
                 if ($ds && $ds["table"]["recordcount"] > 0) {
                     $remove_fileid = $ds["table"]["rows"][0]["fileid"];
                 }
             } catch (\Exception $e) {
             }
             $dm = $this->get('doctrine.odm.mongodb.document_manager');
             Utils::removeFile($logo, $dm);
             try {
                 $da->ExecSQL($sql, $params);
                 //更改成功后删除原mogo文件
                 Utils::removeFile($remove_fileid, $dm);
             } catch (\Exception $e) {
                 $success = false;
                 $this->get("logger")->err($e->getMessage());
             }
         }
     }
     $re = array("success" => $success, "fileid" => $newfileid);
     $result = new Response(json_encode($re));
     $result->headers->set('Content-Type', 'text/json');
     return $result;
 }
示例#4
0
 public function modifygrouplogoAction()
 {
     $re = array("returncode" => ReturnCode::$SUCCESS);
     $user = $this->get('security.context')->getToken()->getUser();
     $dm = $this->get('doctrine.odm.mongodb.document_manager');
     $request = $this->getRequest();
     $circle_id = $request->get("circle_id");
     $group_id = $request->get("group_id");
     $filepath = $_FILES['filepath']['tmp_name'];
     if (empty($filepath)) {
         $filepath = tempnam(sys_get_temp_dir(), "we");
         unlink($filepath);
         $somecontent1 = base64_decode($request->get('filedata'));
         if ($handle = fopen($filepath, "w+")) {
             if (!fwrite($handle, $somecontent1) == FALSE) {
                 fclose($handle);
             }
         }
     }
     $da = $this->get("we_data_access");
     try {
         if (empty($circle_id) || empty($group_id) || empty($filepath)) {
             $re["returncode"] = ReturnCode::$SYSERROR;
             $re["error"] = "参数传递错误!";
             $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
             $response->headers->set('Content-Type', 'text/json');
             return $response;
         }
         $filepath = Utils::saveFile($filepath, $dm);
         $sql = 'select group_id,group_photo_path,fafa_groupid,group_name from we_groups where group_id=? and circle_id=?';
         $dataset = $da->GetData('we_groups', $sql, array($group_id, $circle_id));
         if ($dataset != null && count($dataset['we_groups']['rows']) > 0) {
             Utils::removeFile($dataset['we_groups']["rows"][0]["group_photo_path"], $dm);
             $sql = "update we_groups set group_photo_path=? where group_id=? ";
             $para = array($filepath, $group_id);
             $da->ExecSQL($sql, $para);
             //取群成员
             $sql = "select b.fafa_jid from we_group_staff a left join  we_staff b on a.login_account=b.login_account where a.group_id=? and b.fafa_jid is not null";
             $para = array($group_id);
             $data = $da->GetData('dt', $sql, $para);
             if ($data != null && count($data['dt']['rows']) > 0) {
                 //修改头像之后需要发出席消息。让各端及时修改头像
                 $fafa_jid = $user->fafa_jid;
                 $tojid = array();
                 for ($i = 0; $i < count($data['dt']['rows']); $i++) {
                     array_push($tojid, $data['dt']['rows'][$i]['fafa_jid']);
                 }
                 $groupjid = $dataset['we_groups']["rows"][0]["fafa_groupid"];
                 $groupname = $dataset['we_groups']["rows"][0]["group_name"];
                 $message = json_encode(array('group_id' => $group_id, 'logo_path' => $filepath, 'jid' => $groupjid, 'group_name' => $groupname));
                 Utils::sendImMessage($fafa_jid, implode(",", $tojid), "group_info_change", $message, $this->container, "", "", false, Utils::$systemmessage_code);
             }
         }
         $re["returncode"] = ReturnCode::$SUCCESS;
         $re["filepath"] = $filepath;
     } catch (\Exception $e) {
         $re["returncode"] = ReturnCode::$SYSERROR;
         $re["error"] = "系统错误,创建圈子失败!";
         $this->get('logger')->err($e);
     }
     $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
     $response->headers->set('Content-Type', 'text/json');
     return $response;
 }
示例#5
0
 public function modifycirclelogoAction()
 {
     $re = array("returncode" => ReturnCode::$SUCCESS);
     $request = $this->getRequest();
     $user = $this->get('security.context')->getToken()->getUser();
     $dm = $this->get('doctrine.odm.mongodb.document_manager');
     $da = $this->get("we_data_access");
     $circleid = $request->get("circle_id");
     // multipart/form-data
     $filepath = $_FILES['filepath']['tmp_name'];
     if (empty($filepath)) {
         $filepath = tempnam(sys_get_temp_dir(), "we");
         unlink($filepath);
         $somecontent1 = base64_decode($request->get('filedata'));
         if ($handle = fopen($filepath, "w+")) {
             if (!fwrite($handle, $somecontent1) == FALSE) {
                 fclose($handle);
             }
         }
     }
     $filepath_24 = $filepath . "_24";
     $filepath_48 = $filepath . "_48";
     try {
         if (empty($circleid) || empty($filepath)) {
             $re["returncode"] = ReturnCode::$SYSERROR;
             $re["error"] = "参数传递错误!";
             $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
             $response->headers->set('Content-Type', 'text/json');
             return $response;
         }
         $im = new \Imagick($filepath);
         $im->scaleImage(48, 48);
         $im->writeImage($filepath_48);
         $im->destroy();
         $im = new \Imagick($filepath);
         $im->scaleImage(24, 24);
         $im->writeImage($filepath_24);
         $im->destroy();
         if (!empty($filepath)) {
             $filepath = Utils::saveFile($filepath, $dm);
         }
         if (!empty($filepath_48)) {
             $filepath_48 = Utils::saveFile($filepath_48, $dm);
         }
         if (!empty($filepath_24)) {
             $filepath_24 = Utils::saveFile($filepath_24, $dm);
         }
         $sql = "select logo_path,logo_path_small,logo_path_big,fafa_groupid,circle_name from we_circle where circle_id=?";
         $table = $da->GetData("circle", $sql, array($circleid));
         if ($table && $table['circle']['recordcount'] > 0) {
             Utils::removeFile($table['circle']['rows'][0]['logo_path'], $dm);
             Utils::removeFile($table['circle']['rows'][0]['logo_path_small'], $dm);
             Utils::removeFile($table['circle']['rows'][0]['logo_path_big'], $dm);
         }
         $sql = "update we_circle set logo_path=?,logo_path_small=?,logo_path_big=? where circle_id=?";
         $params = array($filepath_48, $filepath_24, $filepath, $circleid);
         $da->ExecSQL($sql, $params);
         //取圈子成员
         $sql = "select b.fafa_jid from we_circle_staff a left join we_staff b on a.login_account=b.login_account where a.circle_id=? and b.fafa_jid is not null";
         $para = array($circleid);
         $data = $da->GetData('dt', $sql, $para);
         if ($data != null && count($data['dt']['rows']) > 0) {
             //修改头像之后需要发出席消息。让各端及时修改头像
             $fafa_jid = $user->fafa_jid;
             $tojid = array();
             for ($i = 0; $i < count($data['dt']['rows']); $i++) {
                 array_push($tojid, $data['dt']['rows'][$i]['fafa_jid']);
             }
             if ($table != null && count($table['circle']['rows']) > 0) {
                 $circlejid = $table["circle"]["rows"][0]["fafa_groupid"];
                 $circlename = $table["circle"]["rows"][0]["circle_name"];
                 $message = json_encode(array('circle_id' => $circleid, 'logo_path' => $filepath, 'circle_name' => $circlename, 'jid' => $circlejid));
                 Utils::sendImMessage($fafa_jid, implode(",", $tojid), "circle_info_change", $message, $this->container, "", "", false, Utils::$systemmessage_code);
             }
         }
         $re["returncode"] = ReturnCode::$SUCCESS;
         $re["filepath"] = $filepath_48;
         $re["filepath_small"] = $filepath_24;
         $re["filepath_big"] = $filepath;
     } catch (\Exception $e) {
         $re["returncode"] = ReturnCode::$SYSERROR;
         $re["error"] = "系统错误,创建圈子失败!";
         $this->get('logger')->err($e);
     }
     $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
     $response->headers->set('Content-Type', 'text/json');
     return $response;
 }
示例#6
0
 public function removeWorkflowNode($parameter)
 {
     $node_id = isset($parameter["node_id"]) ? $parameter["node_id"] : "";
     if (empty($node_id)) {
         //节点已不存在时,直接返回
         return false;
     }
     $data = $this->getNode($parameter);
     if (empty($data)) {
         //节点已不存在时,直接返回
         return null;
     }
     $account = $parameter["user"]->getUserName();
     if ($data["submit_staff"] == $account) {
         //如果是申请人并且是流程的创建者删除该节点时,删除该 流程所有数据
         $wf = $this->getWorkflow($data);
         if (!empty($wf) && $wf["createstaff"] == $account) {
             $this->conn->ExecSQL("delete from we_app_businessworkflow where wf_id=?", array((string) $data["wf_id"]));
         }
     }
     $sql = "select * from we_app_workflow_attachment where node_id=?";
     $attachmentDS = $this->conn->GetData("t", $sql, array((string) $node_id));
     $sql2 = "delete from we_app_workflow_node where node_id=?";
     $sql3 = "delete from we_app_workflow_nodesetting where node_id=?";
     $sql4 = "delete from we_app_workflow_attachment where node_id=?";
     $this->conn->ExecSQLs(array($sql2, $sql3, $sql4), array(array((string) $node_id), array((string) $node_id), array((string) $node_id)));
     if (count($attachmentDS["t"]["rows"]) > 0) {
         for ($i = 0; $i < count($attachmentDS["t"]["rows"]); $i++) {
             $file_id = $attachmentDS["t"]["rows"][$i]["file_id"];
             Utils::removeFile($file_id, $this->containerObj);
         }
     }
     return $data;
 }
示例#7
0
 public function modifyavatar($parameter)
 {
     $re = array("success" => true);
     $request = $this->container->getRequest();
     $user = $parameter["user"];
     $dm = $this->container->get('doctrine.odm.mongodb.document_manager');
     $da = $this->container->get("we_data_access");
     $da_im = $this->container->get("we_data_access_im");
     $login_account = $user->getUsername();
     $photofile = $_FILES['photofile']['tmp_name'];
     if (empty($photofile)) {
         $photofile = tempnam(sys_get_temp_dir(), "we");
         unlink($photofile);
         $somecontent1 = base64_decode($parameter['photodata']);
         if ($handle = fopen($photofile, "w+")) {
             if (!fwrite($handle, $somecontent1) == FALSE) {
                 fclose($handle);
             }
         }
     }
     $photofile_24 = $photofile . "_24";
     $photofile_48 = $photofile . "_48";
     try {
         if (empty($photofile)) {
             throw new \Exception("param is null");
         }
         $im = new \Imagick($photofile);
         $im->scaleImage(48, 48);
         $im->writeImage($photofile_48);
         $im->destroy();
         $im = new \Imagick($photofile);
         $im->scaleImage(24, 24);
         $im->writeImage($photofile_24);
         $im->destroy();
         $table = $this->getInfo();
         if (!empty($table)) {
             Utils::removeFile($table["photo_path"], $dm);
             Utils::removeFile($table["photo_path_small"], $dm);
             Utils::removeFile($table["photo_path_big"], $dm);
         }
         if (!empty($photofile)) {
             $photofile = Utils::saveFile($photofile, $dm);
         }
         if (!empty($photofile_48)) {
             $photofile_48 = Utils::saveFile($photofile_48, $dm);
         }
         if (!empty($photofile_24)) {
             $photofile_24 = Utils::saveFile($photofile_24, $dm);
         }
         $da->ExecSQL("update we_staff set photo_path=?,photo_path_big=?,photo_path_small=? \n\t        where login_account=?", array((string) $photofile_48, (string) $photofile, (string) $photofile_24, (string) $login_account));
         $da_im->ExecSQL("update im_employee set photo=? where loginname=?", array((string) $photofile, (string) $table["fafa_jid"]));
         $this->getInfo(true);
         $this->syncAttrsToIM();
         $message = json_encode(array('jid' => $user->fafa_jid, "path" => $this->container->getParameter('FILE_WEBSERVER_URL') . $photofile));
         Utils::sendImPresence($user->fafa_jid, implode(",", $this->getFriendJidList()), "staff-changeinfo", $message, $this->container, "", "", false, Utils::$systemmessage_code);
         $re["success"] = true;
         $re["fileid"] = $photofile;
         $re["photo_path"] = $photofile_48;
         $re["photo_path_big"] = $photofile;
         $re["photo_path_small"] = $photofile_24;
     } catch (\Exception $e) {
         $re["success"] = false;
         $this->get('logger')->err($e);
     }
     return $re;
 }
 public function updatePortalIconAction()
 {
     $da = $this->get("we_data_access");
     $user = $this->get('security.context')->getToken()->getUser();
     $eno = $user->eno;
     $username = $user->getUsername();
     $request = $this->getRequest();
     $logo = $request->get("fileid");
     $crop = $request->get("crop");
     if (!empty($crop)) {
         $crop = json_decode($crop, true);
     }
     $appid = $request->get("appid");
     $success = true;
     $newfileid = "";
     if (!empty($logo) && !empty($crop)) {
         //源图像另存为
         $doc = $this->get('doctrine.odm.mongodb.document_manager')->getRepository('JustsyMongoDocBundle:WeDocument')->find($logo);
         if (!empty($doc)) {
             $filename1 = strtolower($doc->getName());
             $expname = explode(".", $filename1);
             $expname = $expname[1];
             $src = tempnam(sys_get_temp_dir(), "tmp") . "." . $expname;
             $file = $doc->getFile();
             $filename2 = $file->getFilename();
             $tybes = $file->getBytes();
             $cont = fopen($src, 'w');
             fwrite($cont, $tybes);
             fclose($cont);
             $gd = new \Justsy\AppCenterBundle\Common\Gd();
             $gd->open($src);
             if ($gd->is_image()) {
                 $gd->crop((int) $crop["x"], (int) $crop["y"], (int) $crop["w"], (int) $crop["h"]);
                 $gd->resize_to(180, 180, 'force');
                 $gd->save_to($src);
                 $dm = $this->get('doctrine.odm.mongodb.document_manager');
                 $doc = new \Justsy\MongoDocBundle\Document\WeDocument();
                 $doc->setName(basename($src));
                 $doc->setFile($src);
                 $dm->persist($doc);
                 $dm->flush();
                 $newfileid = $doc->getId();
             }
             unlink($src);
             //数据记录操作处理
             $sql = "update we_apps_portalconfig set logo=? where appid=?";
             $params = array((string) $newfileid, $appid);
             //删除原来的文件
             $dm = $this->get('doctrine.odm.mongodb.document_manager');
             Utils::removeFile($logo, $dm);
             try {
                 $da->ExecSQL($sql, $params);
             } catch (\Exception $e) {
                 $success = false;
                 $this->get("logger")->err($e->getMessage());
             }
         }
     }
     $re = array("success" => $success, "fileid" => $newfileid);
     $result = new Response(json_encode($re));
     $result->headers->set('Content-Type', 'text/json');
     return $result;
 }