Example #1
0
File: utils.php Project: yunter/crm
function getSelectedRecords($input, $module, $idstring, $excludedRecords)
{
    global $current_user, $adb;
    if ($idstring == 'relatedListSelectAll') {
        $recordid = vtlib_purify($input['recordid']);
        if ($module == 'Accounts') {
            $result = getCampaignAccountIds($recordid);
        }
        if ($module == 'Contacts') {
            $result = getCampaignContactIds($recordid);
        }
        if ($module == 'Leads') {
            $result = getCampaignLeadIds($recordid);
        }
        $storearray = array();
        for ($i = 0; $i < $adb->num_rows($result); $i++) {
            $storearray[] = $adb->query_result($result, $i, 'id');
        }
        $excludedRecords = explode(';', $excludedRecords);
        $storearray = array_diff($storearray, $excludedRecords);
    } else {
        if ($module == 'Documents') {
            if ($input['selectallmode'] == 'true') {
                $result = getSelectAllQuery($input, $module);
                $storearray = array();
                $focus = CRMEntity::getInstance($module);
                for ($i = 0; $i < $adb->num_rows($result); $i++) {
                    $storearray[] = $adb->query_result($result, $i, $focus->table_index);
                }
                $excludedRecords = explode(';', $excludedRecords);
                $storearray = array_diff($storearray, $excludedRecords);
                if ($idstring != 'all') {
                    $storearray = array_merge($storearray, explode(';', $idstring));
                }
                $storearray = array_unique($storearray);
            } else {
                $storearray = explode(";", $idstring);
            }
        } elseif ($idstring == 'all') {
            $result = getSelectAllQuery($input, $module);
            $storearray = array();
            $focus = CRMEntity::getInstance($module);
            for ($i = 0; $i < $adb->num_rows($result); $i++) {
                $storearray[] = $adb->query_result($result, $i, $focus->table_index);
            }
            $excludedRecords = explode(';', $excludedRecords);
            $storearray = array_diff($storearray, $excludedRecords);
        } else {
            $storearray = explode(";", $idstring);
        }
    }
    return $storearray;
}
<?php

/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
*/
require_once 'modules/Users/Users.php';
require_once 'include/QueryGenerator/QueryGenerator.php';
require_once 'include/utils/utils.php';
$idlist = vtlib_purify($_REQUEST['idlist']);
$viewid = vtlib_purify($_REQUEST['viewname']);
$module = vtlib_purify($_REQUEST['module']);
$related_module = vtlib_purify($_REQUEST['related_module']);
global $adb;
if (vtlib_purify($_REQUEST['mode']) == 'relatedlist') {
    if ($related_module == 'Accounts') {
        $result = getCampaignAccountIds($idlist);
    }
    if ($related_module == 'Contacts') {
        $result = getCampaignContactIds($idlist);
    }
    if ($related_module == 'Leads') {
        $result = getCampaignLeadIds($idlist);
    }
} else {
    $result = getSelectAllQuery($_REQUEST, $module);
}
$numRows = $adb->num_rows($result);
echo $numRows;