Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 6027 | Rev 6029 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 6027 Rev 6028
Línea 1098... Línea 1098...
1098
 
1098
 
1099
        if ($search) {
1099
        if ($search) {
1100
            $select->where->nest()
1100
            $select->where->nest()
1101
                ->like('first_name', '%' . $search . '%')
1101
                ->like('first_name', '%' . $search . '%')
1102
                ->or->like('last_name', '%' . $search . '%')
-
 
1103
                ->or->like(new Expression("CONCAT(first_name,' ',last_name)"), '%' . $search . '%')
-
 
1104
                ->or->like(new Expression("CONCAT(last_name,' ',first_name)"), '%' . $search . '%')
1102
                ->or->like('last_name', '%' . $search . '%')
1105
                ->or->like('email', '%' . $search . '%')
1103
                ->or->like('email', '%' . $search . '%')
1106
                ->unnest();
1104
                ->unnest();
Línea 1107... Línea 1105...
1107
        }
1105
        }
Línea 1179... Línea 1177...
1179
 
1177
 
1180
        if ($search) {
1178
        if ($search) {
1181
            $select->where->nest()
1179
            $select->where->nest()
1182
                ->like('first_name', '%' . $search . '%')
1180
                ->like('first_name', '%' . $search . '%')
1183
                ->or->like('last_name', '%' . $search . '%')
-
 
1184
                ->or->like(new Expression("CONCAT(first_name,' ',last_name)"), '%' . $search . '%')
-
 
1185
                ->or->like(new Expression("CONCAT(last_name,' ',first_name)"), '%' . $search . '%')
1181
                ->or->like('last_name', '%' . $search . '%')
1186
                ->or->like('email', '%' . $search . '%')
1182
                ->or->like('email', '%' . $search . '%')
1187
                ->unnest();
1183
                ->unnest();
Línea 1188... Línea 1184...
1188
        }
1184
        }
Línea 1224... Línea 1220...
1224
 
1220
 
1225
        if ($search) {
1221
        if ($search) {
1226
            $select->where->nest()
1222
            $select->where->nest()
1227
                ->like('first_name', '%' . $search . '%')
1223
                ->like('first_name', '%' . $search . '%')
1228
                ->or->like('last_name', '%' . $search . '%')
-
 
1229
                ->or->like(new Expression("CONCAT(first_name,' ',last_name)"), '%' . $search . '%')
-
 
1230
                ->or->like(new Expression("CONCAT(last_name,' ',first_name)"), '%' . $search . '%')
1224
                ->or->like('last_name', '%' . $search . '%')
1231
                ->or->like('email', '%' . $search . '%')
1225
                ->or->like('email', '%' . $search . '%')
1232
                ->unnest();
1226
                ->unnest();
Línea 1233... Línea 1227...
1233
        }
1227
        }
Línea 1268... Línea 1262...
1268
 
1262
 
1269
        if ($search) {
1263
        if ($search) {
1270
            $select->where->nest()
1264
            $select->where->nest()
1271
                ->like('first_name', '%' . $search . '%')
1265
                ->like('first_name', '%' . $search . '%')
1272
                ->or->like('last_name', '%' . $search . '%')
-
 
1273
                ->or->like(new Expression("CONCAT(first_name,' ',last_name)"), '%' . $search . '%')
-
 
1274
                ->or->like(new Expression("CONCAT(last_name,' ',first_name)"), '%' . $search . '%')
1266
                ->or->like('last_name', '%' . $search . '%')
1275
                ->or->like('email', '%' . $search . '%')
1267
                ->or->like('email', '%' . $search . '%')
1276
                ->unnest();
1268
                ->unnest();
Línea 1277... Línea 1269...
1277
        }
1269
        }
Línea 1310... Línea 1302...
1310
 
1302
 
1311
        if ($search) {
1303
        if ($search) {
1312
            $select->where->nest()
1304
            $select->where->nest()
1313
                ->like('first_name', '%' . $search . '%')
1305
                ->like('first_name', '%' . $search . '%')
1314
                ->or->like('last_name', '%' . $search . '%')
-
 
1315
                ->or->like(new Expression("CONCAT(first_name,' ',last_name)"), '%' . $search . '%')
-
 
1316
                ->or->like(new Expression("CONCAT(last_name,' ',first_name)"), '%' . $search . '%')
1306
                ->or->like('last_name', '%' . $search . '%')
1317
                ->or->like('email', '%' . $search . '%')
1307
                ->or->like('email', '%' . $search . '%')
1318
                ->unnest();
1308
                ->unnest();
Línea 1319... Línea 1309...
1319
        }
1309
        }