$order = \OrderMain::findFirst("oid='" . $oid . "'");

 $shop = \OrderShop::find(array(

                    'conditions'=>"oid=:oid:",

                    'bind'=>array('oid'=>$oid)

                ))

$builder = $this->modelsManager->createBuilder()

                ->columns("s.sid,s.oid,s.uuid,s.shop_id,s.shop_type_name,s.shop_name,s.shop_attr,s.shop_num,s.shop_price,s.post_true,

                    s.post_type,s.post_number,s.post_time,s.receive_true,s.create_time,m.order_status")

                ->addfrom("OrderMain",'m')

                ->leftjoin("OrderShop",'m.oid=s.oid','s');

            $builder->andWhere("m.delete_flg=0")->orderBy("m.create_time desc");