public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $typeid = intval(EnvUtil::getRequest("typeid")); if (empty($typeid)) { $this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("Parameters error", "error"))); } $removeSuccess = ReportType::model()->remove($typeid); if ($removeSuccess) { $reports = Report::model()->fetchRepidAndAidByTypeids($typeid); if (!empty($reports)) { if ($reports["aids"]) { AttachUtil::delAttach($reports["aids"]); } ReportRecord::model()->deleteAll("repid IN('{$reports["repids"]}')"); Report::model()->deleteAll("repid IN('{$reports["repids"]}')"); } $return["isSuccess"] = true; $return["msg"] = Ibos::lang("Del succeed", "message"); } else { $return["isSuccess"] = false; $return["msg"] = Ibos::lang("Del failed", "message"); } $this->ajaxReturn($return); } }
public function delBody($bodyIds, $archiveId = 0) { $table = sprintf("{{%s}}", $this->getTableName($archiveId)); $bodys = Yii::app()->db->createCommand()->select("attachmentid")->from($table)->where("FIND_IN_SET(bodyid,'{$bodyIds}')")->queryAll(); $attachIds = ConvertUtil::getSubByKey($bodys, "attachmentid"); $attachId = StringUtil::filterStr(implode(",", $attachIds)); if (!empty($attachId)) { AttachUtil::delAttach($attachId); } return Yii::app()->db->createCommand()->delete($table, "FIND_IN_SET(bodyid,'{$bodyIds}')"); }
public function actionDelAttach() { $runId = intval(EnvUtil::getRequest("runid")); $attachId = intval(EnvUtil::getRequest("aid")); $run = FlowRun::model()->fetchByPk($runId); if ($run) { $aids = explode(",", $run["attachmentid"]); foreach ($aids as $i => $aid) { if ($aid == $attachId) { unset($aids[$i]); break; } } FlowRun::model()->modify($runId, array("attachmentid" => implode(",", $aids))); AttachUtil::delAttach($attachId); $this->ajaxReturn(array("isSuccess" => true)); } $this->ajaxReturn(array("isSuccess" => false)); }
public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $repids = EnvUtil::getRequest("repids"); $uid = Ibos::app()->user->uid; if (empty($repids)) { $this->error(Ibos::lang("Parameters error", "error"), $this->createUrl("default/index")); } $pk = ""; if (strpos($repids, ",")) { $repids = trim($repids, ","); $pk = explode(",", $repids); } else { $pk = array($repids); } $reports = Report::model()->fetchAllByPk($pk); foreach ($reports as $report) { if ($report["uid"] != $uid) { $this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("You do not have permission to delete the report"))); } } $aids = Report::model()->fetchAllAidByRepids($pk); if ($aids) { AttachUtil::delAttach($aids); } $isInstallCalendar = ModuleUtil::getIsEnabled("calendar"); if ($isInstallCalendar) { Calendars::model()->deleteALL("`calendarid` IN(select `cid` from {{calendar_rep_record}} where FIND_IN_SET(`repid`, '{$repids}')) "); CalendarRepRecord::model()->deleteAll("repid IN ({$repids})"); } $delSuccess = Report::model()->deleteByPk($pk); if ($delSuccess) { ReportRecord::model()->deleteAll("repid IN('{$repids}')"); ReportStats::model()->deleteAll("repid IN ({$repids})"); $this->ajaxReturn(array("isSuccess" => true, "msg" => Ibos::lang("Del succeed", "message"))); } else { $this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("Del failed", "message"))); } } }
public function completelyDelete($emailIds, $uid, $archiveId = 0) { $isSuccess = 0; $emailIds = is_array($emailIds) ? $emailIds : array($emailIds); $mainTable = sprintf("{{%s}}", $this->getTableName($archiveId)); $bodyTable = sprintf("{{%s}}", EmailBody::model()->getTableName($archiveId)); $bodyIds = Ibos::app()->db->createCommand()->select("bodyid")->from($mainTable)->where("FIND_IN_SET(emailid,'" . implode(",", $emailIds) . "')")->queryAll(); if ($bodyIds) { $bodyIds = ConvertUtil::getSubByKey($bodyIds, "bodyid"); } foreach ($bodyIds as $i => $bodyId) { $body = Ibos::app()->db->createCommand()->select("fromid,attachmentid")->from($bodyTable)->where("bodyid = {$bodyId} AND fromid = {$uid}")->queryRow(); if ($body || !isset($emailIds[$i])) { if (isset($emailIds[$i])) { $readerRows = Ibos::app()->db->createCommand()->select("bodyid")->from($mainTable)->where("emailid = {$emailIds[$i]} AND isread != 0 AND toid != {$uid}")->queryRow(); } else { $readerRows = false; } if ($readerRows) { if (Ibos::app()->db->createCommand()->update($bodyTable, array("issenderdel" => 1), "bodyid = " . $bodyId)) { $isSuccess = 1; } } else { if (isset($emailIds[$i])) { $nextStep = Ibos::app()->db->createCommand()->delete($mainTable, "emailid = " . $emailIds[$i]); } else { Ibos::app()->db->createCommand()->delete($bodyTable, "bodyid = " . $bodyId); $nextStep = true; } if ($nextStep) { if ($body["attachmentid"] !== "") { AttachUtil::delAttach($body["attachmentid"]); } $isSuccess = 1; } } } else { $lastRows = Ibos::app()->db->createCommand()->select("toid")->from($mainTable)->where("bodyid = {$bodyId} AND toid != {$uid}")->queryRow(); if (!$lastRows) { Ibos::app()->db->createCommand()->delete($mainTable, "emailid = " . $emailIds[$i]); $attachmentId = Ibos::app()->db->createCommand()->select("attachmentid")->from($bodyTable)->where("bodyid = " . $bodyId)->queryScalar(); if ($attachmentId && $attachmentId !== "") { AttachUtil::delAttach($attachmentId); } $isSuccess++; } else { Ibos::app()->db->createCommand()->delete($mainTable, "emailid = {$emailIds[$i]} AND toid = {$uid}"); $isSuccess++; } } } return $isSuccess; }
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; } } } }
public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $resumeids = EnvUtil::getRequest("resumeids"); if (empty($resumeids)) { $this->error(Ibos::lang("Parameters error", "error"), $this->createUrl("resume/index")); } $pk = ""; if (strpos($resumeids, ",")) { $pk = explode(",", trim($resumeids, ",")); } else { $pk = $resumeids; } $delSuccess = Resume::model()->deleteByPk($pk); if ($delSuccess) { ResumeContact::model()->deleteAll("FIND_IN_SET(resumeid,'{$resumeids}') "); ResumeInterview::model()->deleteAll("FIND_IN_SET(resumeid,'{$resumeids}') "); ResumeBgchecks::model()->deleteAll("FIND_IN_SET(resumeid,'{$resumeids}') "); $detail = ResumeDetail::model()->fetchAll("FIND_IN_SET(resumeid,'{$resumeids}') "); $avataridArr = ConvertUtil::getSubByKey($detail, "avatarid"); $attachmentidArr = ConvertUtil::getSubByKey($detail, "attachmentid"); if (!empty($avataridArr)) { foreach ($avataridArr as $avatarid) { AttachUtil::delAttach($avatarid); } } if (!empty($attachmentidArr)) { foreach ($attachmentidArr as $attachmentid) { AttachUtil::delAttach($attachmentid); } } ResumeDetail::model()->deleteAll("FIND_IN_SET(resumeid,'{$resumeids}') "); $this->ajaxReturn(array("isSuccess" => 1, "msg" => Ibos::lang("Del succeed", "message"))); } else { $this->ajaxReturn(array("isSuccess" => 0, "msg" => Ibos::lang("Del failed", "message"))); } } }
public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $articleids = trim(EnvUtil::getRequest("articleids"), ","); $attachmentids = ""; $attachmentIdArr = Article::model()->fetchAllFieldValueByArticleids("attachmentid", $articleids); foreach ($attachmentIdArr as $attachmentid) { if (!empty($attachmentid)) { $attachmentids .= $attachmentid . ","; } } $count = 0; if (!empty($attachmentids)) { $splitArray = explode(",", trim($attachmentids, ",")); $attachmentidArray = array_unique($splitArray); $attachmentids = implode(",", $attachmentidArray); $count = AttachUtil::delAttach($attachmentids); } if ($this->getVoteInstalled()) { Vote::model()->deleteAllByRelationIdsAndModule($articleids, "article"); } ArticlePicture::model()->deleteAllByArticleIds($articleids); Article::model()->deleteAllByArticleIds($articleids); ArticleApproval::model()->deleteByArtIds($articleids); $this->ajaxReturn(array("isSuccess" => true, "count" => $count, "msg" => Ibos::lang("Del succeed", "message"))); } }
public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $diaryids = EnvUtil::getRequest("diaryids"); $uid = Ibos::app()->user->uid; if (empty($diaryids)) { $this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("Select at least one"))); } $pk = ""; if (strpos($diaryids, ",")) { $diaryids = trim($diaryids, ","); $pk = explode(",", $diaryids); } else { $pk = array($diaryids); } $diarys = Diary::model()->fetchAllByPk($pk); foreach ($diarys as $diary) { if (!ICDiary::checkReadScope($uid, $diary)) { $this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("You do not have permission to delete the log"))); } } $aids = Diary::model()->fetchAllAidByPks($pk); if ($aids) { AttachUtil::delAttach($aids); } $isInstallCalendar = ModuleUtil::getIsEnabled("calendar"); if ($isInstallCalendar) { Calendars::model()->deleteALL("`calendarid` IN(select `cid` from {{calendar_record}} where FIND_IN_SET(`did`, '{$diaryids}')) "); CalendarRecord::model()->deleteAll("did IN ({$diaryids})"); } Diary::model()->deleteByPk($pk); DiaryRecord::model()->deleteAll("diaryid IN ({$diaryids})"); DiaryStats::model()->deleteAll("diaryid IN ({$diaryids})"); $this->ajaxReturn(array("isSuccess" => true, "msg" => Ibos::lang("Del succeed", "message"))); } }
public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $docids = trim(EnvUtil::getRequest("docids"), ","); $attachmentIdArr = Officialdoc::model()->fetchAidsByDocids($docids); AttachUtil::delAttach($attachmentIdArr); if (!empty($docids)) { Officialdoc::model()->deleteAllByDocIds($docids); OfficialdocVersion::model()->deleteAllByDocids($docids); OfficialdocReader::model()->deleteReaderByDocIds($docids); OfficialdocApproval::model()->deleteByDocIds($docids); OfficialdocBack::model()->deleteByDocIds($docids); $this->ajaxReturn(array("isSuccess" => true, "info" => Ibos::lang("Del succeed", "message"))); } else { $this->ajaxReturn(array("isSuccess" => false, "info" => Ibos::lang("Parameters error", "error"))); } } }
private function _deleteFeedAttach($feedIds) { $feeddata = $this->getFeeds($feedIds); $feedDataInfo = ConvertUtil::getSubByKey($feeddata, "feeddata"); $attachIds = array(); foreach ($feedDataInfo as $value) { $value = unserialize($value); !empty($value["attach_id"]) && ($attachIds = array_merge($attachIds, $value["attach_id"])); } array_filter($attachIds); array_unique($attachIds); !empty($attachIds) && AttachUtil::delAttach($attachIds); }
public function actionDel() { if (Ibos::app()->request->isAjaxRequest) { $assignmentId = intval(EnvUtil::getRequest("id")); $checkRes = $this->checkAvailableById($assignmentId); if (!$checkRes["isSuccess"]) { $this->ajaxReturn($checkRes); } $assignment = Assignment::model()->fetchByPk($assignmentId); $uid = Ibos::app()->user->uid; if ($uid != $assignment["designeeuid"]) { $this->ajaxReturn(array("isSuccess" => false, "msg" => Ibos::lang("You donot have permission to delete"))); } if (!empty($assignment["attachmentid"])) { AttachUtil::delAttach($assignment["attachmentid"]); } if ($this->getIsInstallCalendar() && !empty($assignment["remindtime"])) { Calendars::model()->deleteALL("`calendarid` IN(select `calendarid` from {{assignment_remind}} where assignmentid = {$assignmentId}) "); AssignmentRemind::model()->deleteAll("assignmentid = {$assignmentId}"); } AssignmentLog::model()->addLog($assignmentId, "del", Ibos::lang("Delete the assignment")); Assignment::model()->deleteByPk($assignmentId); AssignmentApply::model()->deleteAll("assignmentid = {$assignmentId}"); $this->ajaxReturn(array("isSuccess" => true, "msg" => Ibos::lang("Del succeed", "message"))); } }