My Query is like:
SELECT tbl_leads . * , tbl_lead_category.vLeadCategoryName AS
vLeadCategoryName, tbl_lead_category.vLeadCategoryIcon AS vLeadCategoryIcon,
Concat( vFirst, ' ', vLast ) AS vFirst
FROM tbl_leads
LEFT JOIN tbl_lead_category ON tbl_lead_category.iLeadCategoryID =
tbl_leads.iLeadCategoryID
LEFT JOIN tbl_user ON tbl_user.iUserID = tbl_leads.iUserID
WHERE (
tbl_leads.eDeleted = '0'
)
AND (
tbl_leads.iUserID = '1'
)
AND (
vCompanyName LIKE '%t%'
OR vCompanyUrl LIKE '%t%'
OR vPersonName LIKE '%t%'
OR vDesignationName LIKE '%t%'
OR vSkypeID LIKE '%t%'
OR vEmailID LIKE '%t%'
OR vPhoneNumber LIKE '%t%')
and my code for this:
$select = $this->tableGateway->getSql()->select();
$select->columns(array('*'));
$select->join('tbl_lead_category',
'tbl_lead_category.iLeadCategoryID = tbl_leads.iLeadCategoryID',
array('vLeadCategoryName', 'vLeadCategoryIcon'), "LEFT")
->join('tbl_user', 'tbl_user.iUserID =
tbl_leads.iUserID',array("vFirst"=>new
\Zend\Db\Sql\Predicate\Expression("Concat(vFirst,' ',vLast)")),"LEFT");
//$select->join('tbl_designation', 'tbl_designation.iDesignationID =
tbl_leads.iDesignationID', array('vDesignationName'), "LEFT");
$where = new \Zend\Db\Sql\Where();
$where->NEST->equalTo('tbl_leads.eDeleted','0')->UNNEST;
if(isset($iUserID) && $iUserID != "")
$where->AND->NEST->equalTo ('tbl_leads.iUserID', $iUserID)->UNNEST;
// start for searching
if (isset($data['sSearch']) && $data['sSearch'] != "") {
for ($i = 0; $i < count($aColumns) - 1; $i++) {
$where->OR->like($aColumns[$i], "%" . $data['sSearch'] .
"%");
// how can i get parentheses to my where which i am searching
}
}
/*i have tried this, but its giving error: not nested**/
if (isset($data['sSearch']) && $data['sSearch'] != "") {
$where->AND->NEST;
for ($i = 0; $i < count($aColumns) - 1; $i++) {
$where->OR->like($aColumns[$i], "%" . $data['sSearch'] .
"%");
// how can i get parentheses to my where which i am searching
}
$where->UNNEST;
}
pls suggest me for solution.
--
List: [email protected]
Info: http://framework.zend.com/archives
Unsubscribe: [email protected]
