$eventObj->BeforeProcessExport($pageObject);
}
$strWhereClause = "";
$strHavingClause = "";
$strSearchCriteria = "and";
$selected_recs = array();
$options = true;
if (@$_REQUEST["a"] != "") {
$options = false;
$sWhere = "1=0";
// process selection
$selected_recs = array();
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
$keys = array();
$keys["SourceID"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]);
$selected_recs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < 1) {
continue;
}
$keys = array();
$keys["SourceID"] = urldecode($arr[0]);
$selected_recs[] = $keys;
}
}
foreach ($selected_recs as $keys) {
$sWhere = $sWhere . " or ";
}
// Before Process event
if ($eventObj->exists("BeforeProcessPrint")) {
$eventObj->BeforeProcessPrint($conn, $pageObject);
}
$strWhereClause = "";
$strHavingClause = "";
$strSearchCriteria = "and";
$selected_recs = array();
if (@$_REQUEST["a"] != "") {
$sWhere = "1=0";
// process selection
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
$keys = array();
$keys["id"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]);
$selected_recs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < 1) {
continue;
}
$keys = array();
$keys["id"] = urldecode($arr[0]);
$selected_recs[] = $keys;
}
}
foreach ($selected_recs as $keys) {
$sWhere = $sWhere . " or ";
/**
* Delete selected records
*/
function deleteRecords()
{
global $globalEvents;
$this->deleteMessage = "";
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
for ($i = 0; $i < count($this->arrKeyFields); $i++) {
$keys[$this->arrKeyFields[$i]] = refine($_REQUEST["mdelete" . ($i + 1)][mdeleteIndex($ind)]);
}
$this->selectedRecs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < count($this->arrKeyFields)) {
continue;
}
for ($i = 0; $i < count($this->arrKeyFields); $i++) {
$keys[$this->arrKeyFields[$i]] = urldecode(@$arr[$i]);
}
$this->selectedRecs[] = $keys;
}
}
$this->recordsDeleted = 0;
$this->lockDelRec = array();
foreach ($this->selectedRecs as $keys) {
$where = KeyWhere($keys);
// delete only owned records
if ($this->nSecOptions != ADVSECURITY_ALL && $this->nLoginMethod == SECURITY_TABLE && $this->createLoginPage) {
$where = whereAdd($where, SecuritySQL("Delete"));
}
$strSQl = "delete from " . AddTableWrappers($this->origTName) . " where " . $where;
$retval = true;
$deletedrs = db_query(SQLQuery::gSQLWhere_having($this->gsqlHead, $this->gsqlFrom, $this->gsqlWhereExpr, $this->gsqlGroupBy, $this->gsqlHaving, $where), $this->conn);
$deleted_values = $this->cipherer->DecryptFetchedArray($deletedrs);
if ($globalEvents->exists("IsRecordEditable", $this->tName)) {
if (!$globalEvents->IsRecordEditable($deleted_values, true, $this->tName)) {
continue;
}
}
if ($this->eventExists("BeforeDelete")) {
$tdeleteMessage = $this->deleteMessage;
$retval = $this->eventsObject->BeforeDelete($where, $deleted_values, $tdeleteMessage, $this);
$this->deleteMessage = $tdeleteMessage;
}
$lockRecord = false;
if ($this->lockingObj) {
$lockWhere = "";
foreach ($keys as $keysvalue) {
$lockWhere .= rawurlencode($keysvalue) . "&";
}
$lockWhere = substr($lockWhere, 0, -1);
$lockSQL = "select * from " . AddTableWrappers("") . " where " . AddFieldWrappers("keys") . "=" . db_prepare_string($lockWhere) . " and " . AddFieldWrappers("table") . "=" . db_prepare_string($this->origTName) . " and " . AddFieldWrappers("action") . "=1";
$lockSet = db_query($lockSQL, $this->conn);
if ($data = db_fetch_array($lockSet)) {
$lockRecord = true;
$this->lockDelRec[] = $keys;
}
if ($this->mode == LIST_SIMPLE) {
$_SESSION[$this->sessionPrefix . "_lockDelRec"] = $this->lockDelRec;
}
}
if (!$lockRecord && @$_REQUEST["a"] == "delete" && $retval) {
$this->recordsDeleted++;
// delete associated uploaded files if any
DeleteUploadedFiles($this->pSet, $deleted_values);
LogInfo($strSQl);
db_exec($strSQl, $this->conn);
if ($this->audit && $deleted_values) {
$fieldsList = $this->pSet->getFieldsList();
$i = 0;
foreach ($deleted_values as $key => $value) {
if (IsBinaryType($this->pSet->getFieldType($fieldsList[$i]))) {
$deleted_audit_values[$fieldsList[$i]] = $value;
} else {
$deleted_audit_values[$key] = $value;
}
$i++;
}
$this->audit->LogDelete($this->tName, $deleted_audit_values, $keys);
}
if ($this->eventExists("AfterDelete")) {
$tdeleteMessage = $this->deleteMessage;
$this->eventsObject->AfterDelete($where, $deleted_values, $tdeleteMessage, $this);
$this->deleteMessage = $tdeleteMessage;
}
}
if (strlen($this->deleteMessage)) {
$this->xt->assignbyref("message", $this->deleteMessage);
$this->xt->assign("message_block", true);
}
}
if (count($this->selectedRecs) && $this->eventExists("AfterMassDelete")) {
$this->eventsObject->AfterMassDelete($this->recordsDeleted, $this);
}
}
}
$strWhereClause = "";
$strHavingClause = "";
$strSearchCriteria = "and";
$selected_recs = array();
$options = true;
if (@$_REQUEST["a"] != "") {
$options = false;
$sWhere = "1=0";
// process selection
$selected_recs = array();
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
$keys = array();
$keys["GroupID"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]);
$keys["CompanyID"] = refine($_REQUEST["mdelete2"][mdeleteIndex($ind)]);
$selected_recs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < 2) {
continue;
}
$keys = array();
$keys["GroupID"] = urldecode($arr[0]);
$keys["CompanyID"] = urldecode($arr[1]);
$selected_recs[] = $keys;
}
}
foreach ($selected_recs as $keys) {
$strWhereClause = "";
$strHavingClause = "";
$strSearchCriteria = "and";
$selected_recs = array();
$options = true;
if (@$_REQUEST["a"] != "") {
$options = false;
$sWhere = "1=0";
// process selection
$selected_recs = array();
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
$keys = array();
$keys["Grp_id"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]);
$keys["StockCode"] = refine($_REQUEST["mdelete2"][mdeleteIndex($ind)]);
$keys["Coy_Id"] = refine($_REQUEST["mdelete3"][mdeleteIndex($ind)]);
$selected_recs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < 3) {
continue;
}
$keys = array();
$keys["Grp_id"] = urldecode($arr[0]);
$keys["StockCode"] = urldecode($arr[1]);
$keys["Coy_Id"] = urldecode($arr[2]);
$selected_recs[] = $keys;
}
}
$gQuery->ReplaceFieldsWithDummies(GetBinaryFieldsIndices());
}
// Before Process event
if ($eventObj->exists("BeforeProcessPrint")) {
$eventObj->BeforeProcessPrint($conn);
}
$strWhereClause = "";
$strHavingClause = "";
$selected_recs = array();
if (@$_REQUEST["a"] != "") {
$sWhere = "1=0";
// process selection
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
$keys = array();
$keys["Record ID"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]);
$selected_recs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < 1) {
continue;
}
$keys = array();
$keys["Record ID"] = urldecode($arr[0]);
$selected_recs[] = $keys;
}
}
foreach ($selected_recs as $keys) {
$sWhere = $sWhere . " or ";
}
$strWhereClause = "";
$strHavingClause = "";
$strSearchCriteria = "and";
$selected_recs = array();
$options = true;
if (@$_REQUEST["a"] != "") {
$options = false;
$sWhere = "1=0";
// process selection
$selected_recs = array();
if (@$_REQUEST["mdelete"]) {
foreach (@$_REQUEST["mdelete"] as $ind) {
$keys = array();
$keys["grp_id"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]);
$keys["coy_id"] = refine($_REQUEST["mdelete2"][mdeleteIndex($ind)]);
$selected_recs[] = $keys;
}
} elseif (@$_REQUEST["selection"]) {
foreach (@$_REQUEST["selection"] as $keyblock) {
$arr = explode("&", refine($keyblock));
if (count($arr) < 2) {
continue;
}
$keys = array();
$keys["grp_id"] = urldecode($arr[0]);
$keys["coy_id"] = urldecode($arr[1]);
$selected_recs[] = $keys;
}
}
foreach ($selected_recs as $keys) {
