//CompanyController
@RequestMapping(value = "/findCompanyForPayment", method = RequestMethod.POST)
    public ResponseEntity<BaseReturn<List<Map<String, Object>>>> findCompanyForPayment(@RequestBody List<SelectOption> filters) {
        BaseReturn<List<Map<String, Object>>> response = new BaseReturn<>();
        try {
            response.setData(companyDAO.findCompanyForPayment(filters));
        } catch (Exception e) {
            LOGGER.error("CompanyController: {}", e);
            e.printStackTrace();
            response.setCode(ResponseMessage.GENERIC_ERROR.getCode());
            response.setMessage(e.getMessage());
        }
        return new ResponseEntity<BaseReturn<List<Map<String, Object>>>>(response, HttpStatus.OK);

    }

//CompanyDaoImpl 43


    @Override
    public List<Map<String, Object>> findCompanyForBillItem(List<SelectOption> filters) throws ClassNotFoundException, DateFormatException, ParseException, NoSuchFieldException {
        String whereSql = "";
        if (filters != null && filters.size() > 0 ){
            SelectOption so = filters.get(0);
            whereSql = " where company.name like upper('"+so.getLow()+"')";
        }
        String sql = "select distinct company.name from company " +
                " left join request on request.company_id = company.id " +
                " left join bill_item on bill_item.request_id = request.id " + whereSql; //Fetch companies that have bill_item's
        List<Map<String, Object>> companyList = jdbcTemplate.queryForList(sql);
        return companyList;
    }

    @Override
    public List<Map<String, Object>> findCompanyForPayment(List<SelectOption> filters) throws ClassNotFoundException, DateFormatException, ParseException, NoSuchFieldException {
        String whereSql = "";
        if (filters != null && filters.size() > 0 ){
            SelectOption so = filters.get(0);
            whereSql = " where company.name like upper('"+so.getLow()+"')";
        }
        String sql = "select distinct company.name from bill_item " +
                "inner join request on request.id = bill_item.request_id " +
                "inner join company on company.id = request.company_id " + whereSql + " order by request.create_date desc";
        List<Map<String, Object>> companyList = jdbcTemplate.queryForList(sql);
        return companyList;
    }

//PaymentDaoImpl 92 end of sql

 " +
                "    left join company on company.id = request.company_id";

//Collection controller js 
searchField
				companyName : null,
				companyTaxNo : null,

line 180
                        if(searchData.companyName)
				filters.push({"fullFieldName" : "Company.name", "option" : "CP", "low" : searchData.companyName});
			if(searchData.companyTaxNo)
				filters.push({"fullFieldName" : "Company.taxNo", "option" : "EQ", "low" : searchData.companyTaxNo});


//Bill xml 102
resultField="name" --> not Company/name

//Collection xml 80


									<filterbar:FilterItem mandatory="false" label="Şirket Vergi No" name="Payment_TaxNo">
										<filterbar:control>
											<Input placeholder="Vergi No"
												   value="{searchModel>/companyTaxNo}"/>
										</filterbar:control>
									</filterbar:FilterItem>
									<filterbar:FilterItem mandatory="false" label="Şirket Adı" name="Payment_CompanyName">
										<filterbar:control>
											<custom:DynamicSuggestInput
													value="{searchModel>/companyName}"
													placeholder="Şirket Adı"
													showSuggestion="true"
													suggestSource="/CreditSystem/company/findCompanyForPayment"
													filterField="Company.name"
													filterOption="CP"
													resultField="name"
													startSuggestion="2"/>
										</filterbar:control>
									</filterbar:FilterItem>