/**
* Function returns query for module record's search
* @param <String> $searchValue - part of record name (label column of crmentity table)
* @param <Integer> $parentId - parent record id
* @param <String> $parentModule - parent module name
* @return <String> - query
*/
function getSearchRecordsQuery($searchValue, $parentId = false, $parentModule = false)
{
if ($parentId && $parentModule == 'Accounts') {
$query = "SELECT * FROM vtiger_crmentity\n\t\t\t\t\t\tINNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n\t\t\t\t\t\tWHERE deleted = 0 AND vtiger_contactdetails.parentid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'Potentials') {
$query = "SELECT * FROM vtiger_crmentity\n\t\t\t\t\t\tINNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n\t\t\t\t\t\tLEFT JOIN vtiger_contpotentialrel ON vtiger_contpotentialrel.contactid = vtiger_contactdetails.contactid\n\t\t\t\t\t\tWHERE deleted = 0 AND vtiger_contpotentialrel.potentialid = {$parentId}\n\t\t\t\t\t\tAND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'HelpDesk') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_troubletickets ON vtiger_troubletickets.contact_id = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_troubletickets.ticketid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'Campaigns') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_campaigncontrel ON vtiger_campaigncontrel.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_campaigncontrel.campaignid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'Vendors') {
$query = "SELECT vtiger_crmentity.* FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_vendorcontactrel ON vtiger_vendorcontactrel.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_vendorcontactrel.vendorid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'PurchaseOrder') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_purchaseorder ON vtiger_purchaseorder.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_purchaseorder.purchaseorderid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'SalesOrder') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_salesorder ON vtiger_salesorder.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_salesorder.salesorderid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'Invoice') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_invoice ON vtiger_invoice.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_invoice.invoiceid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
}
}
}
}
}
}
}
}
return parent::getSearchRecordsQuery($parentId, $parentModule);
}
/**
* Function returns query for module record's search
* @param <String> $searchValue - part of record name (label column of crmentity table)
* @param <Integer> $parentId - parent record id
* @param <String> $parentModule - parent module name
* @return <String> - query
*/
function getSearchRecordsQuery($searchValue, $parentId = false, $parentModule = false)
{
if ($parentId && $parentModule == 'Accounts') {
$query = "SELECT * FROM vtiger_crmentity\n\t\t\t\t\t\tINNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n\t\t\t\t\t\tWHERE deleted = 0 AND vtiger_contactdetails.parentid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'HelpDesk') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_troubletickets ON vtiger_troubletickets.contact_id = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_troubletickets.ticketid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'Campaigns') {
$query = "SELECT * FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_campaigncontrel ON vtiger_campaigncontrel.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_campaigncontrel.campaignid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
} else {
if ($parentId && $parentModule == 'Vendors') {
$query = "SELECT vtiger_crmentity.* FROM vtiger_crmentity\n INNER JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_crmentity.crmid\n INNER JOIN vtiger_vendorcontactrel ON vtiger_vendorcontactrel.contactid = vtiger_contactdetails.contactid\n WHERE deleted=0 AND vtiger_vendorcontactrel.vendorid = {$parentId} AND label like '%{$searchValue}%'";
return $query;
}
}
}
}
return parent::getSearchRecordsQuery($parentId, $parentModule);
}
/**
* Function returns query for module record's search
* @param <String> $searchValue - part of record name (label column of crmentity table)
* @param <Integer> $parentId - parent record id
* @param <String> $parentModule - parent module name
* @return <String> - query
*/
public function getSearchRecordsQuery($searchValue, $parentId = false, $parentModule = false)
{
if ($parentId && in_array($parentModule, array('Accounts', 'Contacts'))) {
$query = "SELECT * FROM vtiger_crmentity\n\t\t\t\t\t\tINNER JOIN vtiger_potential ON vtiger_potential.potentialid = vtiger_crmentity.crmid\n\t\t\t\t\t\tWHERE deleted = 0 AND vtiger_potential.related_to = {$parentId} AND label like '%{$searchValue}%'";
return $query;
}
return parent::getSearchRecordsQuery($parentId, $parentModule);
}
