|  |  | 
 |  |  |             </if> | 
 |  |  |  | 
 |  |  |             <if test="cateId != null and cateId != ''  "> | 
 |  |  |                 and  c.PROJ_TYPE_ID=#{cateId} | 
 |  |  |                 and  c.cate_id=#{cateId} | 
 |  |  |             </if> | 
 |  |  |  | 
 |  |  |  | 
 
 |  |  | 
 |  |  |               and  a.proj_name like concat('%',#{projName},'%') | 
 |  |  |             </if> | 
 |  |  |             <if test="cateId != null and cateId != ''  "> | 
 |  |  |                 and  b.PROJ_TYPE_ID=#{cateId} | 
 |  |  |                 and  b.cate_id=#{cateId} | 
 |  |  |             </if> | 
 |  |  |         </where> | 
 |  |  |  | 
 
 |  |  | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>储值卡名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 
 |  |  | 
 |  |  |                     <button  onclick="myGrid.resetForm()" type="button"   class="btn btn-default btn-sm"><i class="fa fa-refresh " ></i> 重置</button> | 
 |  |  |                 </div> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>储值卡名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  | <!--            <div class="form-group mr-20">--> | 
 |  |  | <!--                <label for="parentId">商品分类</label>--> | 
 |  |  | <!--                <select class="form-control select2" size="1" name="cateId" id="parentId">--> | 
 |  |  | <!--                    <option value="" selected="selected">--选择分类--</option>--> | 
 |  |  | <!--                </select>--> | 
 |  |  | <!--            </div>--> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="parentId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name="cateId" id="parentId"> | 
 |  |  |                     <option value="" selected="selected">--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  | <!--            <div class="form-group mr-20">--> | 
 |  |  | <!--                <label>会员</label>--> | 
 |  |  | <!--                <input autocomplete="off" placeholder="姓名/编号/电话"  name="vipQueryKey" type="text" class="form-control"  >--> | 
 |  |  | <!--            </div>--> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label>会员</label> | 
 |  |  |                 <input autocomplete="off" placeholder="姓名/编号/电话"  name="vipQueryKey" type="text" class="form-control"  > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label>到期时间</label><!--    入库时间的查询增加一个查询的其实时间两个字段 --> | 
 |  |  |                 <input autocomplete="off"   id="select_begin" name="beginTime" type="text" class="form-control datetimepicker">- | 
 |  |  |                 <input autocomplete="off"   name="endTime"  type="text" class="form-control datetimepicker" id="select_end"> | 
 |  |  |             </div> | 
 |  |  | <!--            <div class="form-group mr-20">--> | 
 |  |  | <!--                <label>到期时间</label><!–    入库时间的查询增加一个查询的其实时间两个字段 –>--> | 
 |  |  | <!--                <input autocomplete="off"   id="select_begin" name="beginTime" type="text" class="form-control datetimepicker">- --> | 
 |  |  | <!--                <input autocomplete="off"   name="endTime"  type="text" class="form-control datetimepicker" id="select_end">--> | 
 |  |  | <!--            </div>--> | 
 |  |  |         </form> | 
 |  |  |         <div id="option-bar" > | 
 |  |  |             <button  matrix:btn="bedListZb-exportExcel"  onclick="exportExcel()" type="button" class="btn btn-default btn-sm"><i class="fa fa-download" ></i> 导出</button> | 
 
 |  |  | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |                 </div> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >订单状态</label> | 
 |  |  |                 <label>订单状态</label> | 
 |  |  |                 <select class="form-control " name="state"  > | 
 |  |  |                     <option value=''>--请选择订单状态--</option> | 
 |  |  |                     <option value='待预约'>待预约</option> | 
 |  |  | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>商品名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |                 </div> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label>产品名称</label> | 
 |  |  |                 <label>服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |         </form> | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>储值卡名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 
 |  |  | 
 |  |  |                     <button  onclick="myGrid.resetForm()" type="button"   class="btn btn-default btn-sm"><i class="fa fa-refresh " ></i> 重置</button> | 
 |  |  |                 </div> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>储值卡名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  | <!--            <div class="form-group mr-20">--> | 
 |  |  | <!--                <label for="parentId">商品分类</label>--> | 
 |  |  | <!--                <select class="form-control select2" size="1" name="cateId" id="parentId">--> | 
 |  |  | <!--                    <option value="" selected="selected">--选择分类--</option>--> | 
 |  |  | <!--                </select>--> | 
 |  |  | <!--            </div>--> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="parentId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name="cateId" id="parentId"> | 
 |  |  |                     <option value="" selected="selected">--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label>会员</label> | 
 |  |  |                 <input autocomplete="off" placeholder="姓名/编号/电话"  name="vipQueryKey" type="text" class="form-control"  > | 
 |  |  |             </div> | 
 |  |  | <!--            <div class="form-group mr-20">--> | 
 |  |  | <!--                <label>会员</label>--> | 
 |  |  | <!--                <input autocomplete="off" placeholder="姓名/编号/电话"  name="vipQueryKey" type="text" class="form-control"  >--> | 
 |  |  | <!--            </div>--> | 
 |  |  |  | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label>到期时间</label><!--    入库时间的查询增加一个查询的其实时间两个字段 --> | 
 |  |  |                 <input autocomplete="off"   id="select_begin" name="beginTime" type="text" class="form-control datetimepicker">- | 
 |  |  |                 <input autocomplete="off"   name="endTime"  type="text" class="form-control datetimepicker" id="select_end"> | 
 |  |  |             </div> | 
 |  |  | <!--            <div class="form-group mr-20">--> | 
 |  |  | <!--                <label>到期时间</label><!–    入库时间的查询增加一个查询的其实时间两个字段 –>--> | 
 |  |  | <!--                <input autocomplete="off"   id="select_begin" name="beginTime" type="text" class="form-control datetimepicker">- --> | 
 |  |  | <!--                <input autocomplete="off"   name="endTime"  type="text" class="form-control datetimepicker" id="select_end">--> | 
 |  |  | <!--            </div>--> | 
 |  |  |         </form> | 
 |  |  |         <div id="option-bar" > | 
 |  |  |             <button matrix:btn="bedList-exportExcel" onclick="exportExcel()" type="button" class="btn btn-default btn-sm"><i class="fa fa-download" ></i> 导出</button> | 
 
 |  |  | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label  >服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |                 </div> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >订单状态</label> | 
 |  |  |                 <label>订单状态</label> | 
 |  |  |                 <select class="form-control " name="state"  > | 
 |  |  |                     <option value=''>--请选择订单状态--</option> | 
 |  |  |                     <option value='待预约'>待预约</option> | 
 |  |  | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label  >产品名称</label> | 
 |  |  |                 <label>服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } | 
 
 |  |  | 
 |  |  |                 </div> | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label>产品名称</label> | 
 |  |  |                 <label>服务名称</label> | 
 |  |  |                 <input autocomplete="off"   name="projName" type="text" class="form-control" > | 
 |  |  |             </div> | 
 |  |  |             <div class="form-group mr-20"> | 
 |  |  |                 <label for="projTypeId">项目分类</label> | 
 |  |  |                 <label for="projTypeId">商品分类</label> | 
 |  |  |                 <select class="form-control select2" size="1" name ="cateId"  id="projTypeId"> | 
 |  |  |                     <option value=''>--选择项目分类--</option> | 
 |  |  |                     <option value=''>--选择分类--</option> | 
 |  |  |                 </select> | 
 |  |  |             </div> | 
 |  |  |         </form> | 
 |  |  | 
 |  |  |  | 
 |  |  |     function initFunctionList() { | 
 |  |  |         $.AjaxProxy({ | 
 |  |  |             a : false, | 
 |  |  |             c : false | 
 |  |  |         }).invoke(basePath+"/admin/projtype/all", function(loj) { | 
 |  |  |             a: false, | 
 |  |  |             c: false, | 
 |  |  |             p: {salePlatform: '线下'} | 
 |  |  |         }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) { | 
 |  |  |             $("#projTypeId").createSelectTree(loj.attr("result").rows, { | 
 |  |  |                 append : true, | 
 |  |  |                 value:"typeName" | 
 |  |  |                 append: true, | 
 |  |  |                 value: "name", | 
 |  |  |             }); | 
 |  |  |         }); | 
 |  |  |     } |