@Override
public List<Object> getProductByShop(int shopId) throws Exception {
List<Object> list = new ArrayList<Object>();
SqlSession sqlSession = null;
try {
sqlSession = SessionUtils.getSession();
StockMapper stockMapper = sqlSession.getMapper(StockMapper.class);
ProductMapper productMapper = sqlSession.getMapper(ProductMapper.class);
List<Stock> stocks = stockMapper.selectByshopId(shopId);
for (Stock stock : stocks) {
Map<String, Object> map = new HashMap<String, Object>();
Product product = productMapper.selectByPrimaryKey(stock.getpId());
map.put("name", product.getpName());
map.put("num", stock.getsNum());
map.put("pid", stock.getpId());
map.put("price", product.getpPrice());
list.add(map);
}
} catch (Exception e) {
throw e;
} finally {
SessionUtils.closeSession(sqlSession);
}
return list;
}
public String deptuserDetailsLoad() throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = DbSessionFactory.getOracleSession();
allPermission = "*";
C_T_Sys_Dept_UserMapper mapper = sqlSession.getMapper(C_T_Sys_Dept_UserMapper.class);
C_T_Sys_UserMapper usermapper = sqlSession.getMapper(C_T_Sys_UserMapper.class);
// 根据主键取得流程基本信息
c_T_Sys_Dept_User = (C_T_Sys_Dept_User) mapper.selectByPrimaryKey(uuid);
C_T_Sys_User user = null;
if (c_T_Sys_Dept_User != null) {
user = (C_T_Sys_User) usermapper.selectByPrimaryKey(c_T_Sys_Dept_User.getUserSysName());
userName = user.getUserName();
}
// 取得部门基本信息
listDept = GetBaseInfor.getDepartmentBaseInfor("sort", sqlSession);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return ERROR;
} finally {
if (sqlSession != null) {
sqlSession.close();
sqlSession = null;
}
}
return SUCCESS;
}
@Before
public void setUp() throws Exception {
sqlSession = MybatisConnectionFactory.getSqlSessionFactory().openSession();
productMapper = sqlSession.getMapper(ProductMapper.class);
priceMapper = sqlSession.getMapper(PriceMapper.class);
setUpAppleJuice();
productMapper.createProduct(new Product("orange juice", "bad"));
}
@Override
public void getSubjectList(
String searchType,
int pageSize,
int pageNum,
String searchKey,
Model model,
String contextPath) {
Subject2 subject2 = new Subject2();
subject2.setPageNum(pageNum);
subject2.setPageSize(pageSize);
subject2.setSearchKey(searchKey);
subject2.setSearchType(searchType);
if (searchKey.equals("[noKeyword]")) {
subject2.setSearchKey("");
}
if (pageNum == 0) subject2.setPageNum(1);
if (pageSize == 0) subject2.setPageSize(8);
if (searchType == null || searchType.equals("")) subject2.setSearchType("subject");
if (searchKey == null || searchKey.equals("")) subject2.setSearchKey("");
// 현 페이지 정보
int NowpageNum = subject2.getPageNum();
int NowpageSize = subject2.getPageSize();
int start = NowpageNum * NowpageSize - (NowpageSize - 1) - 1;
subject2.setStartNum(start);
List<Subject2> SubjectList = sqlSession.getMapper(SubjectDAO.class).getSubjectList(subject2);
int SubjectListCount = sqlSession.getMapper(SubjectDAO.class).getSubjectListCount(subject2);
model.addAttribute("SubjectListCount", SubjectListCount);
// 페이징 처리 하단!
int visiblePageNum = 10;
int pagecount = 0;
int beginPage = 0;
int endPage = 0;
if (SubjectListCount != 0) { // 게시물이 없는 경우
pagecount = SubjectListCount / NowpageSize; // 115건 = 11page
if (SubjectListCount % NowpageSize > 0) { // 115건 = 나머지 5 true
pagecount++; // 11page++ = 12page
}
beginPage = (NowpageNum - 1) / visiblePageNum * visiblePageNum + 1; // 10단위 계산
endPage = beginPage + (visiblePageNum - 1);
if (endPage > pagecount) {
endPage = pagecount;
}
}
// view에 보낼 데이터
model.addAttribute("pagecount", pagecount);
model.addAttribute("beginpage", beginPage);
model.addAttribute("endpage", endPage);
model.addAttribute("pageNum", NowpageNum);
model.addAttribute("pageSize", NowpageSize);
model.addAttribute("searchType", subject2.getSearchType());
// 검색어가 없는경우 재처리
if (subject2.getSearchKey().equals("")) subject2.setSearchKey("[noKeyword]");
model.addAttribute("searchKey", subject2.getSearchKey());
model.addAttribute("SubjectList", SubjectList);
}
@Override
public int sell(Map<Integer, Integer> sells, Date date, String bz, String uId, int shopId)
throws Exception {
int ret = 0;
SqlSession sqlSession = null;
try {
sqlSession = SessionUtils.getSession();
SellMapper sellMapper = sqlSession.getMapper(SellMapper.class);
SellDetailMapper sellDetailMapper = sqlSession.getMapper(SellDetailMapper.class);
StockMapper stockMapper = sqlSession.getMapper(StockMapper.class);
Sell sell = new Sell();
sell.setsBz(bz);
sell.setsDate(date);
sell.setShopId(shopId);
sell.setuId(uId);
sellMapper.insert(sell);
Iterator<Integer> iterator = sells.keySet().iterator();
List<Stock> stocks = stockMapper.selectAll();
while (iterator.hasNext()) {
SellDetail sellDetail = new SellDetail();
sellDetail.setSellId(sell.getsId());
sellDetail.setpId(iterator.next());
sellDetail.setsNum(sells.get(sellDetail.getpId()));
sellDetailMapper.insert(sellDetail);
for (Stock stock : stocks) {
if (stock.getShopId() == shopId && stock.getpId() == sellDetail.getpId()) {
if (stock.getsNum() >= sellDetail.getsNum()) {
stock.setsNum(stock.getsNum() - sellDetail.getsNum());
stockMapper.updateByPrimaryKey(stock);
} else {
throw new Exception();
}
}
}
}
sqlSession.commit();
ret = 1;
} catch (Exception e) {
sqlSession.rollback();
throw e;
} finally {
SessionUtils.closeSession(sqlSession);
}
return ret;
}
public long saveProduct(Product product) {
ProductDaoIf productDao = session.getMapper(ProductDaoIf.class);
long id = productDao.insertProduct(product);
session.commit();
logger.debug("Product Insert Count:" + id);
return id;
}
public long savePhoto(Photo photo) {
PhotoDaoIf photoDao = session.getMapper(PhotoDaoIf.class);
int id = photoDao.insertPhoto(photo);
session.commit();
logger.debug("Photo Insert Count:" + id);
return id;
}
public String filedutyofficerDelete() throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = DbSessionFactory.getOracleSession();
if (!"".equals(checkedIds)) {
String[] arrUuids;
arrUuids = checkedIds.split("%2C");
C_T_SYS_FiledutyofficerExample example = new C_T_SYS_FiledutyofficerExample();
C_T_SYS_FiledutyofficerMapper mapper =
sqlSession.getMapper(C_T_SYS_FiledutyofficerMapper.class);
for (String tempUuid : arrUuids) {
example.or().andFiledutyofficerIdEqualTo(tempUuid);
}
mapper.deleteByExample(example);
}
jsonResult = Constants.DISP_OPERATION_SUCCESSFUL;
sqlSession.commit();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return ERROR;
} finally {
if (sqlSession != null) {
sqlSession.close();
sqlSession = null;
}
}
allPermission = "*";
return SUCCESS;
}
@Override
public int projectCount() {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
int totalCount = memberMapper.projectCount();
return totalCount;
}
@Override
public int insertSubject(Subject subject, String start, String end) {
subject.setCapacity(Integer.parseInt(subject.getCapacity_String().replace(",", "")));
subject.setLecture_totalday(
Integer.parseInt(subject.getLecture_totalday_String().replace(",", "")));
subject.setTuition_fee(Integer.parseInt(subject.getTuition_fee_String().replace(",", "")));
Time start1 = Time.valueOf(start + ":00");
Time end1 = Time.valueOf(end + ":00");
long a = (end1.getTime() - start1.getTime()) / 1000;
int time3 = (int) (subject.getLecture_totalday() * a);
Subject subject2 =
new Subject(
subject.getSubject_id(),
subject.getSubject_name(),
subject.getCapacity(),
subject.getSubject_explanation(),
subject.getInstructional_objectives(),
subject.getSubject_point(),
subject.getLecture_target(),
subject.getLecture_totalday(),
subject.getTuition_fee(),
subject.getLecture_content(),
subject.getCenter_id(),
start1,
end1,
time3 / 3600);
return sqlSession.getMapper(SubjectDAO.class).insertSubject(subject2);
}
private double calculatePriceProgress() {
Price price = new Price();
price.setEntityid(propertyId);
ArrayList<Price> prices = sqlSession.getMapper(PriceMapper.class).readByEntityId(price);
int numDaysAhead = 0;
if (!prices.isEmpty()) {
Date earliestDate = prices.get(0).getDate();
Date latestDate = prices.get(0).getTodate();
for (int i = 1; i < prices.size(); i++) {
Date fromDate = prices.get(i).getDate();
Date toDate = prices.get(i).getTodate();
/* Determine earliest date*/
if (fromDate.before(earliestDate)) {
earliestDate = fromDate;
}
/* Determine latest date*/
if (toDate.after(latestDate)) {
latestDate = toDate;
}
}
numDaysAhead = Model.getDuration(earliestDate, latestDate);
}
double progress = numDaysAhead < 180 ? numDaysAhead * 100.0 / 180.0 : 100.0;
return progress * priceWeightage;
}
@Override
public int add(String userid, String bookId, String price) {
logger.info("PurchaseServiceImpl : add 진입");
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
SimpleDateFormat sdf2 = new SimpleDateFormat("HHmmss");
Calendar c1 = Calendar.getInstance();
String purToday = sdf.format(c1.getTime());
String var = "-";
String strToday2 = sdf2.format(c1.getTime());
String result = purToday + var + strToday2;
logger.info("넘어온 책 아이디 : " + bookId);
logger.info("넘어온 유저 아이디 : " + userid);
logger.info("넘어온 책 가격 : " + price);
logger.info("생성된 주문번호 : " + result);
int price_int = TypeChange(price);
logger.info("형 변환된 책 가격 : " + price_int);
purchase.setPurNum(result);
purchase.setSum(price_int);
purchase.setAccNum(purToday);
purchase.setUserid(userid);
purchase.setBookid(bookId);
PurchaseMapper mapper = sqlSession.getMapper(PurchaseMapper.class);
return mapper.add(purchase);
}
public List<Map<String, Object>> list(Map<String, Object> params) {
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
SqlSession session = DbConnectionFactory.getSqlSessionFactory(dataSource).openSession();
try {
MainAccountActivityGroupDAO dao = session.getMapper(MainAccountActivityGroupDAO.class);
List<Map<String, Object>> tmpList = dao.list(params);
String name = MainAccountActivityGroupConstant.TFN_NAME + params.get("lang");
for (Map<String, Object> tmpMap : tmpList) {
Map<String, Object> map = new HashMap<String, Object>();
map.put(
JsonConstant.COMBOBOX_ID,
(Integer) tmpMap.get(MainAccountActivityGroupConstant.TFN_ID));
map.put(JsonConstant.COMBOBOX_NAME, (String) tmpMap.get(name.toUpperCase()));
tmpMap = CommonUtil.removeThElement(tmpMap);
map.put(JsonConstant.COMBOBOX_DATA, tmpMap);
list.add(map);
}
} catch (Exception ex) {
log.error(ex);
} finally {
session.close();
}
return list;
}
public void serialize(SqlSession sql, JsonGenerator jg)
throws JsonGenerationException, IOException, IllegalTypeException {
Map<String, GroupBean> sortedGroups = GroupsIE.getSortedGroups(sql, groupResolver);
GroupsMapper mapper = sql.getMapper(GroupsMapper.class);
jg.writeStartArray();
for (Map.Entry<String, GroupBean> entry : sortedGroups.entrySet()) {
List<GroupElementBean> members = mapper.getMembers(entry.getValue().getId());
jg.writeStartObject();
jg.writeStringField("groupPath", entry.getKey());
jg.writeFieldName("members");
jg.writeStartArray();
for (GroupElementBean member : members) {
jg.writeStartObject();
jg.writeNumberField("entity", member.getElementId());
jg.writeNumberField("groupId", member.getGroupId());
jg.writeBinaryField("contents", member.getContents());
jg.writeEndObject();
}
jg.writeEndArray();
jg.writeEndObject();
}
jg.writeEndArray();
}
@Override
public Member getMember(String uid) {
MemberDao dao = session.getMapper(MemberDao.class);
return dao.getMember(uid);
}
public Pedido getPedidoDAO(final String idPedido) {
final SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession();
final PedidoDAO pedidoDao = session.getMapper(PedidoDAO.class);
final Pedido pedido = pedidoDao.getPedidoDAO(idPedido);
session.close();
return pedido;
}
public void atualizarStatusPedidoDAO(final Pedido pedido) {
final SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession();
final PedidoDAO pedidoDao = session.getMapper(PedidoDAO.class);
pedidoDao.atualizarStatusPedidoDAO(pedido);
session.commit();
session.close();
}
public long saveProductCategory(ProductCategory productCategory) {
ProductCategoryDaoIf productCategoryDao = session.getMapper(ProductCategoryDaoIf.class);
long id = productCategoryDao.insertProductCategory(productCategory);
session.commit();
logger.debug("Product Category Insert Count:" + id);
return id;
}
public long saveProductTagScope(Long productId, Long tagId) {
ProductTagScopeDaoIf productTagScopeDao = session.getMapper(ProductTagScopeDaoIf.class);
long id = productTagScopeDao.insertProductTagScope(new ProductTagScope(productId, tagId));
session.commit();
logger.debug("Product Tag Scope Insert Count:" + id);
return id;
}
/* (non-Javadoc)
* @see mx.com.bbva.bancomer.commons.business.BbvaIBusinessObject#createCommand(mx.com.bbva.bancomer.commons.model.dto.BbvaAbstractDataTransferObject)
*/
@Override
public <T extends BbvaAbstractDataTransferObject> T createCommand(
T bbvaAbstractDataTransferObject) {
logger.debug("Entrada createCommand -- OK");
logger.debug("Datos de Entrada createCommand -- " + bbvaAbstractDataTransferObject.toString());
UsuarioVO usuarioVO = ((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO();
String userName = usuarioVO.getNombreUsuario();
int idPerfil = usuarioVO.getIdPerfil();
int idEstatus = usuarioVO.getEstatusUsuario();
usuarioVO = readCommand(usuarioVO);
((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO().setIdPerfil(idPerfil);
((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO().setNombreUsuario(userName);
((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO().setEstatusUsuario(idEstatus);
if (usuarioVO == null) {
SqlSession session = MapeadorSessionFactory.getSqlSessionFactory().openSession();
MapUsuario mapUsuario = session.getMapper(MapUsuario.class);
try {
mapUsuario.crearUsuario(((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO());
session.commit();
} catch (Exception ex) {
session.rollback();
ex.printStackTrace();
bbvaAbstractDataTransferObject.setErrorCode("SQL-001");
bbvaAbstractDataTransferObject.setErrorDescription(ex.getMessage());
} finally {
session.close();
}
logger.debug("Datos de Salida invoke -- " + bbvaAbstractDataTransferObject.toString());
logger.debug("Salida invoke -- OK");
} else {
bbvaAbstractDataTransferObject.setErrorCode("0001");
bbvaAbstractDataTransferObject.setErrorDescription("El usuario ya existe");
}
return bbvaAbstractDataTransferObject;
}
/**
* Read command.
*
* @param usuarioVO the usuario vo
* @return the usuario vo
*/
private UsuarioVO readCommand(UsuarioVO usuarioVO) {
logger.debug("Entrada createCommand -- OK");
usuarioVO.setIdPerfil(null);
usuarioVO.setNombreUsuario(null);
usuarioVO.setEstatusUsuario(null);
logger.debug("Datos de Entrada createCommand -- " + usuarioVO.toString());
UsuarioVO result = null;
try {
SqlSession session = MapeadorSessionFactory.getSqlSessionFactory().openSession();
MapUsuario mapUsuario = session.getMapper(MapUsuario.class);
if (usuarioVO != null && usuarioVO.getIdCveUsuario() != null) {
logger.debug(":::::::::::::::::::::" + usuarioVO.getIdCveUsuario());
}
try {
result = mapUsuario.obtenerUsuarios(usuarioVO).get(0);
} catch (Exception ex) {
result = null;
} finally {
session.close();
}
logger.debug("result: " + result + " -- **fin**");
logger.debug("Salida invoke -- OK");
return result;
} catch (Exception ex) {
ex.printStackTrace();
return result;
}
}
@Override
public ArrayList<Member> userAssignList(int PRO_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<Member> result = memberMapper.userAssignList(PRO_ID);
return result;
}
@Override
public Project selectNewProject(Project project) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
Project p = memberMapper.selectNewProject(project);
return p;
}
/** 测试新增 */
@Test
public void insert() {
SqlSession session = null;
try {
CalculationRecordModel model = new CalculationRecordModel();
model.setCreatedTime(new Date());
model.setCurrentNumber(1.0);
model.setPreNumber(2.0);
model.setOperator("*");
model.setResult(3.0);
model.setStatus(1);
model.setMacAddress("pc1");
session = sessionFactory.openSession();
CalculationDao calculationDao = session.getMapper(CalculationDao.class);
// calculationDao.insertCalculationRecord(model);
List<Integer> Ids = new ArrayList<Integer>();
Ids.add(3);
Ids.add(4);
// int[] Ids = {1,2};
List<CalculationRecordModel> modelList = calculationDao.getCalculationRecordByID(Ids);
for (CalculationRecordModel calculationRecordModel : modelList) {
System.out.println(calculationRecordModel);
}
session.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
}
}
@Override
public ArrayList<Member> selectJoinMember(int PRO_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<Member> member = memberMapper.selectJoinMember(PRO_ID);
return member;
}
public int countProductCaptures(int status) {
ProductCaptureDaoIf productCaptureDao = session.getMapper(ProductCaptureDaoIf.class);
Integer count = productCaptureDao.countProductCaptures(status);
session.commit();
logger.debug("Count product capture list:" + count);
return count;
}
/** @param args */
public static void main(String[] args) {
// TODO Auto-generated method stub
CompositeConfiguration config = new CompositeConfiguration();
config.addConfiguration(new SystemConfiguration());
try {
config.addConfiguration(new PropertiesConfiguration("storage.properties"));
} catch (ConfigurationException e) {
// TODO Auto-generated catch block
logger.error(e.getMessage());
}
String rootFolder = config.getString("bp.root.folder");
String altpartyid = args[0];
SqlSession sqlSession = RazorServer.openSession();
try {
if (StringUtils.isBlank(altpartyid)) {
// altpartyid = "231051"; //NextPax partner GA
altpartyid = "179795";
}
Partner partner = sqlSession.getMapper(PartnerMapper.class).exists(altpartyid);
if (partner == null) {
throw new ServiceException(Error.party_id, altpartyid);
}
A_Handler handler = new A_Handler(partner);
handler.downloadImages(rootFolder);
} catch (Exception e) {
logger.error(e.getMessage());
}
}
public ProductCapture selectOneProductCapture(long id) {
ProductCaptureDaoIf productCaptureDao = session.getMapper(ProductCaptureDaoIf.class);
ProductCapture captureProduct = productCaptureDao.selectOneProductCapture(id);
session.commit();
logger.debug("Select product capture Count:" + captureProduct);
return captureProduct;
}
public String fileDutyOfficerUpdate() throws Exception {
SqlSession sqlSession = null;
try {
sqlSession = DbSessionFactory.getOracleSession();
C_T_SYS_Filedutyofficer record = new C_T_SYS_Filedutyofficer();
C_T_SYS_FiledutyofficerMapper mapper =
sqlSession.getMapper(C_T_SYS_FiledutyofficerMapper.class);
if (null == c_T_SYS_Filedutyofficer.getFiledutyofficerId()
|| "".equals(c_T_SYS_Filedutyofficer.getFiledutyofficerId().trim())) {
c_T_SYS_Filedutyofficer.setFiledutyofficerId((new GUID().toString()));
DbSetData.setPerporyData(c_T_SYS_Filedutyofficer, record, 2);
mapper.insertSelective(record);
} else {
DbSetData.setPerporyData(c_T_SYS_Filedutyofficer, record, 1);
mapper.updateByPrimaryKey(record);
}
jsonResult = Constants.DISP_OPERATION_SUCCESSFUL;
sqlSession.commit();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return ERROR;
} finally {
if (sqlSession != null) {
sqlSession.close();
sqlSession = null;
}
}
allPermission = "*";
return SUCCESS;
}
public long saveResource(FileData fileData) {
FileDataDaoIf fileDataDao = session.getMapper(FileDataDaoIf.class);
int id = fileDataDao.insertFileData(fileData);
session.commit();
logger.debug("Resource Insert Count:" + id);
return id;
}
