Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- $resultado1 = (object)$resultado = DB::connection('ClienteBD')->table('OCRD')
- ->join('octg', 'OCRD.groupnum', '=', 'octg.groupnum')
- ->join('oinv', 'oinv.CardCode', '=', 'OCRD.cardcode')
- ->join('oslp', 'OCRD.slpcode', '=', 'oslp.SlpCode')
- ->where('OCRD.CardType', '=','C')
- ->where('oslp.Slpname','LIKE', '%'. $Zona .'%')
- ->where('OCRD.CardName', 'LIKE', '%'. $Nombre .'%')
- ->select('OCRD.cardcode', 'OCRD.cardname','oslp.Slpname', 'octg.PymntGroup', 'OCRD.CreditLine', 'OCRD.Balance')->get();
- } catch(IlluminateDatabaseQueryException $ex){
- dd($ex->getMessage());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement