SHARE
TWEET

Untitled

a guest Jun 20th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. try {
  2.             $resultado1 = (object)$resultado = DB::connection('ClienteBD')->table('OCRD')
  3.                         ->join('octg', 'OCRD.groupnum', '=', 'octg.groupnum')
  4.                         ->join('oinv', 'oinv.CardCode', '=', 'OCRD.cardcode')
  5.                         ->join('oslp', 'OCRD.slpcode', '=', 'oslp.SlpCode')
  6.                         ->where('OCRD.CardType', '=','C')
  7.                         ->where('oslp.Slpname','LIKE', '%'. $Zona .'%')
  8.                         ->where('OCRD.CardName', 'LIKE', '%'. $Nombre .'%')
  9.                                                 ->select('OCRD.cardcode', 'OCRD.cardname','oslp.Slpname', 'octg.PymntGroup', 'OCRD.CreditLine', 'OCRD.Balance')->get();
  10.             } catch(IlluminateDatabaseQueryException $ex){
  11.             dd($ex->getMessage());
  12.             }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top