报价管理系统

【实例简介】这是一个用于生成报价单的工具。 

【实例截图】 :  

/** 产品管理 */ @RestController
@RequestMapping("/product") public class ProductController { private static final String FILEPATH_1="D:/nginx-1.21.6/html";  private static final String FILEPATH_2="http://localhost:11111";   @Autowired
   ClassifyMapper classifyMapper;  @Autowired
   BrandMapper brandMapper;  @Autowired
   ProductMapper productMapper;   /* 显示 */  @GetMapping("/showProduct") public JsonResult<JSONObject> showProduct(int companyid){
      List<ClassifyEntity> classifyList = classifyMapper.selectClassifyByCompanyid(companyid);  List<BrandEntity> brandList = brandMapper.selectBrandByCompanyid(companyid);  List<ProductEntity> productList = productMapper.selectProductByCompanyid(companyid);  JSONObject jo = new JSONObject();  jo.put("classifyList", classifyList);  jo.put("brandList", brandList);  jo.put("productList", productList);  return JsonResult.success("", jo);  }
   
   @PostMapping("/importImage/{companyid}") public JsonResult<String> importImage(@PathVariable("companyid")int companyid,MultipartFile file_data) throws IOException {
      String filename = file_data.getOriginalFilename();  String filepath1=FILEPATH_1 "/" companyid;  String filepath2=FILEPATH_2 "/" companyid;  File file=new File(filepath1);  if(!file.exists()) {
         file.mkdirs();  } byte[] data = new byte[1024];  InputStream ins = file_data.getInputStream();  byte[] buffer = new byte[1024];  int len = 0;  ByteArrayOutputStream baos = new ByteArrayOutputStream();  while ((len = ins.read(buffer)) != -1) {
         baos.write(buffer, 0, len);  }
      baos.flush();  data = baos.toByteArray();  FileOutputStream fos=new FileOutputStream(filepath1 "/" filename);  BufferedOutputStream bos=new BufferedOutputStream(fos);  bos.write(data);  bos.flush();  bos.close();  baos.close();  fos.close();  ins.close();  return JsonResult.success("图片上传成功", filepath2 "/" filename);  }
   
   @GetMapping("/insertProduct/{username}") public JsonResult<JSONObject> insertProduct(@PathVariable("username")String username,ProductEntity productEntity){
      productEntity.setCreator(username);  productMapper.insertProduct(productEntity);  return JsonResult.success("新增成功", null);  }
   @GetMapping("/updateProduct/{username}") public JsonResult<JSONObject> updateProduct(@PathVariable("username")String username,ProductEntity productEntity){
      productEntity.setModifier(username);  productMapper.updateProduct(productEntity);  return JsonResult.success("新增成功", null);  } //查询  @GetMapping("/selectProductByCondition/{companyid}") public JsonResult<JSONArray> selectProductByCondition(@PathVariable("companyid")int companyid,int classifyid,double price_1,double price_2,String[] brand_s){
      System.out.println(classifyid " " price_1 " " price_2);  List<ProductEntity> productList = new ArrayList<ProductEntity>();  if(classifyid==0) { if(price_1 ==0 || price_2==0) { if(brand_s!=null && brand_s.length>0) {
               String a = "";  for(int i=0;i<brand_s.length;i  ) {
                  a  = brand_s[i] " ";  }
               String b = a.trim().replace(" ", ",");  productList = productMapper.selectProductByBrandidAndCompanyid(b,companyid);  }else {
               productList = productMapper.selectProductByCompanyid(companyid);  }
         }else { if(brand_s!=null && brand_s.length>0) {
               String a = "";  for(int i=0;i<brand_s.length;i  ) {
                  a  = brand_s[i] " ";  }
               String b = a.trim().replace(" ", ",");  productList = productMapper.selectProductByBrandidAndSalepriceAndCompanyid(b, price_1, price_2, companyid);  }else {
               productList = productMapper.selectProductBySalepriceAndCompanyid(price_1, price_2, companyid);  }
         }
      }else {
         String c = classifyid "";  List<ClassifyEntity> allClassify = classifyMapper.selectClassifyByFatherclassifyid(classifyid "", companyid);  for(ClassifyEntity classify: allClassify) {
            c  = " " classify.getClassifyid();  }
         String d = c.trim().replace(" ", ",");   if(price_1 ==0 || price_2==0) { if(brand_s!=null && brand_s.length>0) {
               String a = "";  for(int i=0;i<brand_s.length;i  ) {
                  a  = brand_s[i] " ";  }
               String b = a.trim().replace(" ", ",");  productList = productMapper.selectProductByBrandidAndClassifyidAndCompanyid(b, d, companyid);  }else {
               productList = productMapper.selectProductByClassifyidAndCompanyid(d, companyid);  }
         }else { if(brand_s!=null && brand_s.length>0) {
               String a = "";  for(int i=0;i<brand_s.length;i  ) {
                  a  = brand_s[i] " ";  }
               String b = a.trim().replace(" ", ",");  productList = productMapper.selectProductByBrandidAndSalepriceAndClassifyidAndCompanyid(b, price_1, price_2, d, companyid);  }else {
               System.out.println(price_1 "," price_2 "," d "," companyid);  productList = productMapper.selectProductBySalepriceAndClassifyidAndCompanyid(price_1, price_2, d, companyid);  }
         }
      }
      JSONArray ja = new JSONArray(productList);  System.out.println(ja);  return JsonResult.success("", ja);  }
   @GetMapping("/delete_product/{productid}") public JsonResult<JSONObject> delete_product(@PathVariable("productid")int productid){
      productMapper.deleteProduct(productid);  return JsonResult.success("删除成功", null);  }
}