INSERT INTO EP_ASSET_INF(

 UID,
 ORGAN_NO,
 DERP_NO,
 APPLY_USER_NO,
 BUY_APPLY_NO,
 BUY_UNIT_PRICE,
 BUY_NUM,
 STOCK_NUM,
 BUY_AMOUNT,
 MFRS,
 SUPPLIER,
 ASSET_TYPE,
 ASSET_NAME,
 FAXFREE_TIME,
 SN_NO,
 DERP_LIMIT,
 SPEC_TYPE,
 FACTORY_TIME,
 ASSET_STATUS,
 remark,
 CREATED_BY,
 CREATED_DATE,
 UPDATED_BY,
 UPDATED_DATE 
) 
SELECT 
  '0001' AS UID,
  'P10001' AS ORGAN_NO,
  'P10001_D10010' AS DERP_NO,
  'P0000029' AS APPLY_USER_NO,
  f3 AS BUY_APPLY_NO,
  f16 AS BUY_UNIT_PRICE,
  f12 AS BUY_NUM,
  0 AS STOCK_NUM,
  f16 BUY_AMOUNT,
  f13 AS MFRS,
  '易点租' AS SUPPLIER,
  '02' AS ASSET_TYPE,
  f10 AS ASSET_NAME,
  DATE(f6) AS FAXFREE_TIME,
  f9 AS SN_NO,
  f7 AS DERP_LIMIT,
  f11 AS SPEC_TYPE,
  DATE(f4) AS FACTORY_TIME,
  '1' AS ASSET_STATUS,
  f17 AS remark,
  'P0000029' AS CREATED_BY,
  NOW() AS CREATED_DATE,
  'P0000029' AS UPDATED_BY,
  NOW() AS UPDATED_DATE 
FROM
  Sheet1$ 
WHERE f10 IS NOT NULL 
  AND f9 IS NOT NULL 
  AND f14 = '易点租' 
  AND f3 IS NOT NULL;

DELIMITER $$

USE `ifdp`$$

DROP TRIGGER /*!50032 IF EXISTS */ `addPayBaseInfo`$$

CREATE
    /*!50017 DEFINER = 'ifdp'@'%' */
    TRIGGER `addPayBaseInfo` BEFORE INSERT ON `EP_ASSET_INF` 
    FOR EACH ROW BEGIN
    DECLARE n INT;
    SELECT IFNULL(MAX(RIGHT(ASSET_NO,5)),0) INTO n FROM EP_ASSET_INF WHERE MID(ASSET_NO,1,8)=DATE_FORMAT(CURDATE(),'%Y%m%d') AND UID = new.UID;
    SET NEW.ASSET_NO=CONCAT(DATE_FORMAT(CURDATE(),'%Y%m%d'),RIGHT(100001+n,5));
    END;
$$

DELIMITER ;