List of usage examples for org.hibernate.type BooleanType INSTANCE
BooleanType INSTANCE
To view the source code for org.hibernate.type BooleanType INSTANCE.
Click Source Link
From source file:com.exilant.GLEngine.CoaCache.java
License:Open Source License
@Transactional(propagation = Propagation.REQUIRES_NEW) public void loadAccountData() { /*/* w ww . j av a2 s .co m*/ * 1.Loads all the account codes and details of that as GLAccount objects in theGLAccountCode,theGLAccountId HashMap's */ // Temporary place holders final HashMap glAccountCodes = new HashMap(); final HashMap glAccountIds = new HashMap(); final HashMap accountDetailType = new HashMap(); String sql = "select id as \"id\",name as \"name\",tableName as \"tableName\"," + "description as \"description\",columnName as \"columnName\",attributeName as \"attributeName\"" + ",nbrOfLevels as \"nbrOfLevels\" from AccountDetailType"; final Session currentSession = persistenceService.getSession(); SQLQuery createSQLQuery = currentSession.createSQLQuery(sql); createSQLQuery.addScalar("id", IntegerType.INSTANCE).addScalar("name").addScalar("tableName") .addScalar("description").addScalar("columnName").addScalar("attributeName") .setResultTransformer(Transformers.aliasToBean(AccountDetailType.class)); List<AccountDetailType> accountDetailTypeList = new ArrayList<AccountDetailType>(); List<GLAccount> glAccountCodesList = new ArrayList<GLAccount>(); new ArrayList<GLAccount>(); accountDetailTypeList = createSQLQuery.list(); for (final AccountDetailType type : accountDetailTypeList) accountDetailType.put(type.getAttributeName(), type); sql = "select ID as \"ID\", glCode as \"glCode\" ,name as \"name\" ," + "isActiveForPosting as \"isActiveForPosting\" ,classification as \"classification\", functionReqd as \"functionRequired\" from chartofaccounts "; createSQLQuery = currentSession.createSQLQuery(sql); createSQLQuery.addScalar("ID", IntegerType.INSTANCE).addScalar("glCode").addScalar("name") .addScalar("isActiveForPosting", BooleanType.INSTANCE) .addScalar("classification", LongType.INSTANCE).addScalar("functionRequired", BooleanType.INSTANCE) .setResultTransformer(Transformers.aliasToBean(GLAccount.class)); glAccountCodesList = createSQLQuery.list(); for (final GLAccount type : glAccountCodesList) glAccountCodes.put(type.getCode(), type); for (final GLAccount type : glAccountCodesList) glAccountIds.put(type.getId(), type); loadParameters(glAccountCodes, glAccountIds); try { final HashMap<String, HashMap> hm = new HashMap<String, HashMap>(); hm.put(ACCOUNTDETAILTYPENODE, accountDetailType); hm.put(GLACCCODENODE, glAccountCodes); if (LOGGER.isDebugEnabled()) LOGGER.debug("Loading size:" + glAccountCodes.size()); hm.put(GLACCIDNODE, glAccountIds); applicationCacheManager.put(ROOTNODE, hm); } catch (final Exception e) { throw e; } }
From source file:com.gp.cong.lcl.common.constant.ExportUnitQueryUtils.java
public List<ManifestBean> getUnitViewDrList(Long unitSSId, HttpServletRequest request) throws Exception { // to show DR or Bl list in View Dr page User user = (User) request.getSession().getAttribute("loginuser"); StringBuilder queryBuilder = new StringBuilder(); queryBuilder//from ww w.j a v a2s .co m .append(" SELECT fn.fileId AS fileId, fn.fileNo AS fileNo, fn.STATUS AS STATUS,fn.state as state,"); queryBuilder.append( "(SELECT CONCAT_WS('~~~',ar.invoice_number,ar.status) FROM ar_red_invoice ar WHERE ar.bl_number = fn.fileNo ORDER BY ar.id DESC LIMIT 1) AS arInvoiceNumber,"); queryBuilder.append( " getDisposion_UnLoc(fn.fileId) AS disposition, IF(fn.state ='BL' , BlNumberSystemForLclExports(bl.file_number_id),'') AS blNo,"); queryBuilder.append( " piece.total_piece as totalPieceCount, piece.total_weight_imperial as totalWeightImperial ,piece.total_volume_imperial as totalVolumeImperial, "); queryBuilder.append( " blPiece.blCft as blCft ,blPiece.blCbm as blCbm,blPiece.blLbs as blLbs ,blPiece.blKgs as blKgs, "); queryBuilder.append(" IF(fn.state = 'BL',bl.rate_type,'') AS rateType, "); queryBuilder.append( " (SELECT SUM(chg.ap_amount) FROM lcl_booking_ac chg WHERE chg.file_number_id = fn.fileId AND deleted = '0' AND chg.ap_gl_mapping_id IN (SELECT id FROM gl_mapping WHERE charge_code = 'FFCOMM' AND shipment_type='LCLE')) AS ffComm, "); queryBuilder.append( " IF(fn.state = 'BL',TradingPartnerAcctName(bl.ship_acct_no),TradingPartnerAcctName(b.ship_acct_no)) AS shipperName, "); queryBuilder.append( " IF(fn.state = 'BL',TradingPartnerAcctName(bl.cons_acct_no),TradingPartnerAcctName(b.cons_acct_no)) AS consigneeName, "); queryBuilder.append( " IF(fn.state = 'BL',TradingPartnerAcctName(bl.fwd_acct_no),TradingPartnerAcctName(b.fwd_acct_no)) AS forwarderName, "); queryBuilder.append(" UnLocationGetCodeByID(b.poo_id) AS origin,"); queryBuilder.append(" UnLocationGetCodeByID (b.fd_id) AS destination,"); queryBuilder.append(" UnLocationGetCodeByID (b.pol_id) AS pol,"); queryBuilder.append(" UnLocationGetCodeByID (b.pod_id) AS pod,"); queryBuilder.append( " IF(fn.state = 'BL',TerminalGetLocationByNo(bl.billing_terminal),TerminalGetLocationByNo(b.billing_terminal))AS terminalLocation,"); queryBuilder.append( " IF(b.poo_pickup,(SELECT pickup_city FROM lcl_booking_pad WHERE file_number_id =fn.fileId),'') AS pickupCity, "); queryBuilder .append(" UnLocationGetNameByID(b.poo_id) AS originName,getStateCode(b.poo_id) AS originState,"); queryBuilder.append( " UnLocationGetNameByID(b.pol_id) AS polName,getStateCode(b.pol_id) AS polState,UnLocationGetNameByID(b.pod_id) AS podName,"); queryBuilder.append( " getStateCode(b.pod_id) AS podCountry,UnLocationGetNameByID(b.fd_id) AS destinationName,getStateCode(b.fd_id) AS destinationCountry,"); queryBuilder.append( " bl.billing_type AS billingType,IF(b.client_pwk_recvd = 1, 'Y', '') AS doc,(SELECT invoice_number FROM TRANSACTION WHERE drcpt = fn.fileNo LIMIT 1) AS blInvoiceNo,"); queryBuilder.append( "(SELECT schedule_no FROM lcl_ss_header WHERE id = b.booked_ss_header_id) AS bookedVoyageNo,bl.posted_by_user_id AS postedByUserId,fn.haz AS hazmat,"); queryBuilder.append( "(SELECT CONCAT_WS('~~~',GROUP_CONCAT(htc.code SEPARATOR '<br>'),COUNT(htc.code),GROUP_CONCAT(LEFT(htc.code, INSTR(htc.code, '/') - 1)))"); queryBuilder.append(" FROM lcl_booking_hot_code htc WHERE htc.file_number_id = fn.fileId) AS hotCodes, "); queryBuilder.append( " IF(bl.file_number_id != fn.fileId , null ,IF(fn.state = 'BL',(SELECT SUM(chg.ar_amount)+ SUM(chg.adjustment_amount) FROM lcl_bl_ac chg WHERE chg.file_number_id = bl.file_number_id AND chg.ar_bill_to_party = 'A'),(SELECT SUM(chg.ar_amount)+ SUM(chg.adjustment_amount) FROM lcl_booking_ac chg WHERE chg.file_number_id = fn.fileId AND chg.ar_bill_to_party = 'A'))) AS colCharge, "); queryBuilder.append( " IF(bl.file_number_id != fn.fileId , null ,IF(fn.state = 'BL',(SELECT SUM(chg.ar_amount)+ SUM(chg.adjustment_amount) FROM lcl_bl_ac chg WHERE chg.file_number_id = bl.file_number_id AND chg.ar_bill_to_party != 'A'),(SELECT SUM(chg.ar_amount)+ SUM(chg.adjustment_amount) FROM lcl_booking_ac chg WHERE chg.file_number_id = fn.fileId AND chg.ar_bill_to_party != 'A'))) AS ppdCharge, "); queryBuilder.append( " IF(bl.file_number_id != fn.fileId , '' ,IF(fn.state = 'BL',(SELECT GROUP_CONCAT(DISTINCT chg.ar_bill_to_party SEPARATOR '/') FROM lcl_bl_ac chg WHERE chg.file_number_id = bl.file_number_id AND chg.ar_bill_to_party != 'A'),(SELECT GROUP_CONCAT(DISTINCT chg.ar_bill_to_party SEPARATOR '/') FROM lcl_booking_ac chg WHERE chg.file_number_id = fn.fileId AND chg.ar_bill_to_party != 'A'))) AS ppdParties, "); // checking condition for status and classname label in list queryBuilder.append(" CASE "); Boolean isManifest_Posted_Bl = new RoleDutyDAO().getRoleDetails("lcl_manifest_postedbl", user.getRole().getRoleId()); if (isManifest_Posted_Bl) { queryBuilder.append(" WHEN fn.state <> 'BL' AND lbe.no_bl_required ='1' THEN 'purpleBold' "); } queryBuilder.append(" WHEN fn.state <> 'BL' THEN 'fileNo' "); queryBuilder.append(" WHEN bl.file_number_id != fn.fileId THEN 'greenBold14px' "); queryBuilder.append( " WHEN (bl.posted_by_user_id <> '' OR bl.posted_by_user_id IS NOT NULL ) AND fn.status <> 'M' THEN 'purpleBold' "); queryBuilder.append(" WHEN fn.status ='M' THEN 'greenBold14px' "); queryBuilder.append( " WHEN fn.state = 'BL' AND (bl.posted_by_user_id='' OR bl.posted_by_user_id IS NULL) THEN 'fileNo' END AS className, "); // ---------------------------------------------------------------STATUS LABEL----------------------------------------------------------------------------- queryBuilder.append(" CASE "); if (isManifest_Posted_Bl) { queryBuilder.append(" WHEN fn.state <> 'BL' AND lbe.no_bl_required ='1' THEN 'NO B/L Required' "); } queryBuilder.append(" WHEN fn.state <> 'BL' THEN 'NoBL'"); queryBuilder.append(" WHEN bl.file_number_id != fn.fileId THEN 'CONS'"); queryBuilder.append( " WHEN (bl.posted_by_user_id <> '' OR bl.posted_by_user_id IS NOT NULL ) AND fn.status <> 'M' THEN 'POSTED' "); queryBuilder.append(" WHEN fn.status ='M' THEN 'MANIFESTED' "); queryBuilder.append( " WHEN fn.state = 'BL' AND (bl.posted_by_user_id = '' OR bl.posted_by_user_id IS NULL) THEN 'POOL' END AS statusLabel,"); queryBuilder.append(" IF(lc.id IS NOT NULL,TRUE,FALSE) AS isCorrection, "); queryBuilder.append(" IF(lc.id IS NOT NULL,(SELECT SUM(ch.new_amount) FROM lcl_correction_Charge ch "); queryBuilder.append(" JOIN gl_mapping gl ON gl.id = ch.gl_mapping_id WHERE "); queryBuilder.append(" ch.correction_id=lc.id AND gl.charge_code='FTFFEE'), "); queryBuilder.append( " (SELECT SUM(blac.ar_amount) FROM lcl_bl_Ac blac JOIN gl_mapping gl ON gl.id = blac.ar_gl_mapping_id "); queryBuilder.append(" WHERE file_number_id = bl.file_number_id AND gl.charge_code='FTFFEE')) AS ftfFee "); // --------------------------------------------------------MAIN SUB QUERY------------------------------------------------------------------------------------ queryBuilder.append(" from ( "); queryBuilder.append( " SELECT f.id AS fileId, f.file_number AS fileNo, f.state AS state, f.status AS STATUS, lbp.hazmat AS haz "); queryBuilder.append( " FROM lcl_file_number f JOIN lcl_booking_piece lbp ON lbp.file_number_id = f.id JOIN lcl_booking_piece_unit u ON u.booking_piece_id = lbp.id "); queryBuilder.append(" WHERE u.lcl_unit_ss_id =:unitSdId ) fn"); // ---------------------------------------------------------JOIN STATS HERE----------------------------------------------------------------------------------- queryBuilder.append(" LEFT JOIN lcl_booking b ON fn.fileId = b.file_number_id "); // ------------------------------------- Conslidation logic is applied please verify ---------------------------------------------------------------- queryBuilder .append(" LEFT JOIN lcl_bl bl ON (bl.file_number_id = getHouseBLForConsolidateDr(fn.fileId))"); queryBuilder.append( " LEFT JOIN lcl_correction lc ON (lc.file_number_id = bl.file_number_id AND lc.status = 'A') "); if (isManifest_Posted_Bl) { queryBuilder.append(" JOIN lcl_booking_export lbe ON fn.fileId = lbe.file_number_id "); } queryBuilder.append(getSumOfCommodityValues()); queryBuilder.append(getSumOfBlCommodityValues()); queryBuilder.append(" GROUP BY fn.fileId "); queryBuilder.append(" ORDER BY fn.fileNo "); SQLQuery query = getCurrentSession().createSQLQuery(queryBuilder.toString()); query.setParameter("unitSdId", unitSSId); query.setResultTransformer(Transformers.aliasToBean(ManifestBean.class)); query.addScalar("fileId", LongType.INSTANCE); query.addScalar("fileNo", StringType.INSTANCE); query.addScalar("status", StringType.INSTANCE); query.addScalar("state", StringType.INSTANCE); query.addScalar("arInvoiceNumber", StringType.INSTANCE); query.addScalar("disposition", StringType.INSTANCE); query.addScalar("blNo", StringType.INSTANCE); query.addScalar("totalPieceCount", IntegerType.INSTANCE); query.addScalar("totalWeightImperial", BigDecimalType.INSTANCE); query.addScalar("totalVolumeImperial", BigDecimalType.INSTANCE); query.addScalar("blCft", BigDecimalType.INSTANCE); query.addScalar("blCbm", BigDecimalType.INSTANCE); query.addScalar("blKgs", BigDecimalType.INSTANCE); query.addScalar("blLbs", BigDecimalType.INSTANCE); query.addScalar("rateType", StringType.INSTANCE); query.addScalar("ffComm", BigDecimalType.INSTANCE); query.addScalar("shipperName", StringType.INSTANCE); query.addScalar("consigneeName", StringType.INSTANCE); query.addScalar("forwarderName", StringType.INSTANCE); query.addScalar("origin", StringType.INSTANCE); query.addScalar("destination", StringType.INSTANCE); query.addScalar("pol", StringType.INSTANCE); query.addScalar("pod", StringType.INSTANCE); query.addScalar("terminalLocation", StringType.INSTANCE); query.addScalar("pickupCity", StringType.INSTANCE); query.addScalar("originName", StringType.INSTANCE); query.addScalar("originState", StringType.INSTANCE); query.addScalar("polName", StringType.INSTANCE); query.addScalar("polState", StringType.INSTANCE); query.addScalar("podName", StringType.INSTANCE); query.addScalar("podCountry", StringType.INSTANCE); query.addScalar("destinationName", StringType.INSTANCE); query.addScalar("destinationCountry", StringType.INSTANCE); query.addScalar("billingType", StringType.INSTANCE); query.addScalar("doc", StringType.INSTANCE); query.addScalar("blInvoiceNo", StringType.INSTANCE); query.addScalar("bookedVoyageNo", StringType.INSTANCE); query.addScalar("hotCodes", StringType.INSTANCE); query.addScalar("postedByUserId", IntegerType.INSTANCE); query.addScalar("hazmat", BooleanType.INSTANCE); query.addScalar("colCharge", BigDecimalType.INSTANCE); query.addScalar("ppdCharge", BigDecimalType.INSTANCE); query.addScalar("ppdParties", StringType.INSTANCE); query.addScalar("className", StringType.INSTANCE); query.addScalar("statusLabel", StringType.INSTANCE); query.addScalar("isCorrection", BooleanType.INSTANCE); query.addScalar("ftfFee", BigDecimalType.INSTANCE); List<ManifestBean> drList = query.list(); return drList; }
From source file:com.gp.cong.lcl.common.constant.ExportUnitQueryUtils.java
public boolean isDrAvailableInVoyage(String headerId, String unitSsId) throws Exception { String sb = " select if(count(*)>0,true,false) as result from lcl_unit_ss lus join lcl_booking_piece_unit bu " + " on bu.lcl_unit_ss_id = lus.id join lcl_booking_piece b on b.id= bu.booking_piece_id " + " join lcl_file_number f on f.id = b.file_number_id " + " join lcl_ss_header lsh on lsh.id = lus.ss_header_id where f.state not in ('B') and lsh.id =:headerId"; if (!"0".equalsIgnoreCase(unitSsId)) { sb += " and lus.id=" + unitSsId; }//w ww. j av a2 s. c o m SQLQuery query = getCurrentSession().createSQLQuery(sb); query.setParameter("headerId", headerId); query.addScalar("result", BooleanType.INSTANCE); return (Boolean) query.uniqueResult(); }
From source file:com.gp.cong.lcl.common.constant.ExportUnitQueryUtils.java
public boolean isPickedFile(Long fileId) throws Exception { StringBuilder sb = new StringBuilder(); sb.append(" SELECT if( count(*) > 0, true, false) as result FROM lcl_booking_piece bp "); sb.append(" JOIN lcl_booking_piece_unit bpu ON bpu.`booking_piece_id` = bp.`id` "); sb.append(" JOIN lcl_unit_ss lus ON lus.id = bpu.`lcl_unit_ss_id` "); sb.append(" JOIN lcl_ss_detail lsd ON lsd.`ss_header_id` = lus.`ss_header_id` "); sb.append(" WHERE bp.`file_number_id` =:fileId "); SQLQuery query = getCurrentSession().createSQLQuery(sb.toString()); query.setParameter("fileId", fileId); return (boolean) query.addScalar("result", BooleanType.INSTANCE).uniqueResult(); }
From source file:com.gp.cong.lcl.common.constant.ExportUnitQueryUtils.java
public boolean isDrContainCollectCharge(Long fileId) throws Exception { StringBuilder sb = new StringBuilder(); sb.append(" select if( count(*)>0 , true ,false ) as result from lcl_bl_ac ac "); sb.append(" join lcl_bl bl on bl.file_number_id = ac.file_number_id "); sb.append(" where ac.file_number_id=:fileId and ac.ar_bill_to_party = 'A' "); SQLQuery query = getCurrentSession().createSQLQuery(sb.toString()); query.setParameter("fileId", fileId); return (boolean) query.addScalar("result", BooleanType.INSTANCE).uniqueResult(); }
From source file:com.gp.cong.lcl.common.constant.ExportUnitQueryUtils.java
public boolean validateCollectCharges(String headerId, String unitssId, String fileId) throws Exception { SQLQuery query = null;/*www. ja v a 2 s. c om*/ if (!fileId.isEmpty()) { query = getCurrentSession().createSQLQuery("select if( count(*)>0 ,true ,false) as result from " + " lcl_bl_ac ac where ac.file_number_id =:fileId and ac.ar_bill_to_party='A'"); query.setLong("fileId", Long.parseLong(fileId)); } else { List<Long> actualDrList = new ExportUnitQueryUtils().getAllPickedCargoBkg(Long.parseLong(headerId), Long.parseLong(unitssId)); query = getCurrentSession().createSQLQuery("select if( count(*)>0 ,true ,false) as result from " + " lcl_bl_ac ac where ac.file_number_id in(:fileList) and ac.ar_bill_to_party='A'"); query.setParameterList("fileList", actualDrList); } return (boolean) query.addScalar("result", BooleanType.INSTANCE).uniqueResult(); }
From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingHotCodeDAO.java
public boolean isHotCodeNotExist(String Code, String fileId) throws Exception { SQLQuery query = getCurrentSession() .createSQLQuery("select if(count(*)<1,true,false) as result from lcl_booking_hot_code " + " where code=:code and file_number_id=:fileId"); query.setParameter("fileId", fileId); query.setParameter("code", Code); query.addScalar("result", BooleanType.INSTANCE); return (Boolean) query.uniqueResult(); }
From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingHotCodeDAO.java
public boolean isHotCodeExistForThreeDigit(String fileId, String type, String Code) throws Exception { // type is not but exists method will affected SQLQuery query = getCurrentSession() .createSQLQuery("select if(count(*)<1,true,false) as result from lcl_booking_hot_code " + " where SUBSTRING_INDEX(code,'/',1)=:code and file_number_id=:fileId"); query.setParameter("fileId", fileId); query.setParameter("code", Code); query.addScalar("result", BooleanType.INSTANCE); return (Boolean) query.uniqueResult(); }
From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingHotCodeDAO.java
public boolean isHotCodeValidate(Long fileId, String code) throws Exception { // type is not but exists method will affected SQLQuery query = getCurrentSession() .createSQLQuery("select if(count(*)>0,true,false) as result from lcl_booking_hot_code " + " where SUBSTRING_INDEX(code,'/',1)=:code and file_number_id=:fileId"); query.setParameter("fileId", fileId); query.setParameter("code", code); query.addScalar("result", BooleanType.INSTANCE); return (Boolean) query.uniqueResult(); }
From source file:com.gp.cong.logisoft.hibernate.dao.lcl.LclBookingHotCodeDAO.java
public Boolean isHazmatHotCodeExist(String fileId) throws Exception { StringBuilder queryStr = new StringBuilder(); queryStr.append("SELECT if((SELECT hazrds FROM ").append(dataBaseName).append( ".ldgins WHERE loadcd = SUBSTRING_INDEX(lp.code,'/',1))='y',true,false) as result FROM lcl_booking_hot_code lp JOIN genericcode_dup gd "); queryStr.append("ON gd.code = SUBSTRING_INDEX(lp.code,'/',1) and "); queryStr.append("gd.Codetypeid= (SELECT codetypeid FROM codetype WHERE description='Hot Codes') "); queryStr.append("AND gd.Field1='Y' WHERE lp.file_number_id =:fileId limit 1"); SQLQuery query = getCurrentSession().createSQLQuery(queryStr.toString()); query.setParameter("fileId", fileId); query.addScalar("result", BooleanType.INSTANCE); return (Boolean) (query.uniqueResult() != null ? query.uniqueResult() : Boolean.FALSE); }