| @@ 48-57 (lines=10) @@ | ||
| 45 | ]; |
|
| 46 | } |
|
| 47 | ||
| 48 | public function initFrom() |
|
| 49 | { |
|
| 50 | return $this |
|
| 51 | ->from('uprice zp') |
|
| 52 | ->leftJoin('zref rt', 'rt.obj_id = zp.type_id') |
|
| 53 | ->leftJoin('zref tu', 'tu.obj_id = zp.unit_id') |
|
| 54 | ->leftJoin('zref cu', 'cu.obj_id = zp.currency_id') |
|
| 55 | ->leftJoin('obj zo', 'zo.obj_id = zp.object_id') |
|
| 56 | ->leftJoin('zref oc', 'oc.obj_id = zo.class_id'); |
|
| 57 | } |
|
| 58 | } |
|
| 59 | ||
| @@ 46-54 (lines=9) @@ | ||
| 43 | ]; |
|
| 44 | } |
|
| 45 | ||
| 46 | public function initFrom() |
|
| 47 | { |
|
| 48 | return $this->from('zsale zs') |
|
| 49 | ->leftJoin('obj so', 'so.obj_id = zs.obj_id') |
|
| 50 | ->leftJoin('zref oc', 'oc.obj_id = so.class_id') |
|
| 51 | ->leftJoin('ztariff zt', 'zt.obj_id = zs.tariff_id') |
|
| 52 | ->leftJoin('zclient zc', 'zc.obj_id = zs.buyer_id') |
|
| 53 | ->leftJoin('zclient cr', 'cr.obj_id = zc.seller_id'); |
|
| 54 | } |
|
| 55 | } |
|
| 56 | ||