ChronoServerWebService

Chronobot Bid Manager Web Service

SOAPMonitorService

SOAP Monitor Service

org.apache.axis.monitor.SOAPMonitorService

SOAPMonitorPort

5001

100

AdminServlet

Axis Admin Servlet

org.apache.axis.transport.http.AdminServlet

100

AxisServlet

Apache-Axis Servlet

org.apache.axis.transport.http.AxisServlet

MappingName1

tw.org.itri.icl.chronobot.util.TimerStartup

SOAPMonitorService

/SOAPMonitor

AdminServlet

/servlet/AdminServlet

AxisServlet

/servlet/AxisServlet

AxisServlet

*.jws

AxisServlet

/services/*

MappingName1

/TimerStartup

Chronobot Database Connection Pool

jdbc/Chronobot

javax.sql.DataSource

Container

NegoServer

http://localhost:8080/pittChronobotNegotiation/services/ChronobotNegotiation

java.lang.String

BidHandleClassList

tw.org.itri.icl.chronobot.bid.ChronobotBidHandle

java.lang.String

user_login

SELECT * FROM user_info WHERE disabled = 0 AND user_id = '{0}' AND passwd = '{1}'{2}

java.lang.String

list_bidroom

SELECT bidroom_id BidRoomId, bidroom_name BidRoomName, bidroom_descr BidRoomDescr, (SELECT COUNT(*) FROM bid_entity WHERE bidding_rooms.bidroom_id = bid_entity.bidroom_id AND canceled = 0 AND status = 0) BidNum FROM bidding_rooms WHERE deleted = 0{0}

java.lang.String

listBidRoomBids

SELECT * FROM bid_entity WHERE canceled = 0 AND bidroom_id = {0}{1}

java.lang.String

addNewBid.checkBid

SELECT COUNT(*) FROM bid_entity WHERE canceled = 0 AND status = 0 AND bidroom_id = {0}{1}

java.lang.String

addNewBid.addBid

INSERT INTO bid_entity (starter_id, bidroom_id, start_time, end_time{4}) VALUES ('{0}', '{1}', '{2}', '{3}'{5})

java.lang.String

addNewBid.getBidId

SELECT @@IDENTITY

java.lang.String

placeBid.checkIfClosed

SELECT status FROM bid_entity WHERE canceled = 0 AND bid_id = {0} AND bidroom_id = {1}

java.lang.String

placeBid.checkIfExist

SELECT COUNT(*) FROM bidding_status WHERE retracted = 0 AND bid_id = {0} AND bidroom_id = {1} AND user_id = '{2}'

java.lang.String

placeBid.checkSchedule

SELECT user_tasks.description Description, user_tasks.location Location, user_tasks.start_time Start_time, user_tasks.end_time End_time FROM bid_entity, user_tasks WHERE bid_entity.canceled = 0 AND user_tasks.user_id = '{2}' AND bid_entity.bid_id = {0} AND bid_entity.bidroom_id = {1} AND (((user_tasks.start_time < bid_entity.task_start) AND (bid_entity.task_start < user_tasks.end_time)) OR ((user_tasks.start_time < bid_entity.task_end) AND (bid_entity.task_end < user_tasks.end_time)))

java.lang.String

placeBid.placeBid

INSERT INTO bidding_status (bid_id, bidroom_id, user_id, place_date, Qob{3}) SELECT {0}, {1}, '{2}', GETDATE(), DATEPART(millisecond, GETDATE()){4} FROM bid_entity, user_info WHERE bid_entity.bid_id = {0} AND bid_entity.bidroom_id = {1} AND user_info.user_id = '{2}'

java.lang.String

updateBidderTaskAndInfo.updateTask

INSERT INTO user_tasks (user_id, description, start_time, end_time, location) SELECT '{0}', bid_descr, '{3}', '{4}', location FROM bid_entity WHERE bid_id = {1} AND bidroom_id = {2}

java.lang.String

updateBidderTaskAndInfo.updateUserInfo

UPDATE user_info SET num_bids_won = num_bids_won + 1 WHERE user_id = '{0}'

java.lang.String

getBidders

SELECT * FROM bidding_status WHERE retracted = 0 AND result = 0 AND bid_id = {0} ORDER BY Qob DESC

java.lang.String

getBiddersByQoB

SELECT * FROM bidding_status WHERE retracted = 0 AND result = 0 AND bid_id = {0} AND Qob = {1}

java.lang.String

listClosingBids

SELECT * FROM bid_entity WHERE end_time < GETDATE() AND canceled = 0 AND status = 0

java.lang.String

listUserOngoingBids

SELECT * FROM bid_entity WHERE canceled = 0 AND status = 0 AND user_id = '{0}'

java.lang.String

listBidders

SELECT * FROM bidding_status WHERE bid_id = {0}{1}

java.lang.String

queryBid

SELECT * FROM bid_entity WHERE bid_id = {0}{1}

java.lang.String

getHighestQoB

SELECT MAX(Qob) FROM bidding_status WHERE retracted = 0 AND result = 0 AND bid_id = {0}

java.lang.String

getHoursSumByQoB

SELECT SUM(place_time) FROM bidding_status WHERE retracted = 0 AND result = 0 AND bid_id = {0} AND Qob = {1}

java.lang.String

listUserBids

SELECT bidding_status.*, bid_entity.bid_descr FROM bidding_status, bid_entity WHERE bidding_status.retracted = 0 AND bid_entity.canceled = 0 AND bidding_status.bid_id = bid_entity.bid_id AND bidding_status.user_id = '{0}'{1}

java.lang.String

listFeasibleBids

SELECT bid_entity.* FROM bid_entity, user_tasks WHERE bid_entity.canceled = 0 AND bid_entity.status = 0 AND user_tasks.user_id = '{0}' AND NOT (((user_tasks.start_time < bid_entity.task_start) AND (bid_entity.task_start < user_tasks.end_time)) OR ((user_tasks.start_time < bid_entity.task_end) AND (bid_entity.task_end < user_tasks.end_time))){1}

java.lang.String

listStartedBids

SELECT * FROM bid_entity WHERE canceled = 0 AND starter_id = '{0}'{1}

java.lang.String

addTask

INSERT INTO user_tasks (user_id{1}) VALUES ('{0}'{2})

java.lang.String

deleteTask

DELETE FROM user_tasks WHERE user_id = '{0}' AND task_id = {1}

java.lang.String

updateTask

UPDATE user_tasks SET user_id = '{0}'{2} WHERE user_id = '{0}' AND task_id = {1}

java.lang.String

listTasks

SELECT * FROM user_tasks WHERE user_id = '{0}'{1}

java.lang.String

checkTaskCollision

SELECT COUNT(*) FROM user_tasks WHERE user_id = '{0}' AND ((('{2}' <= start_time) AND (start_time < '{3}')) OR (('{2}' < end_time) AND (end_time <= '{3}'))) AND NOT task_id = {1}

java.lang.String

cancelBid

UPDATE bid_entity SET canceled = 1, cancel_reason = '{3}'{4} WHERE canceled = 0 AND starter_id = '{0}' AND bid_id = {1} AND bidroom_id = {2}

java.lang.String

retractBid

UPDATE bidding_status SET retracted = 1, retract_reason = '{3}'{4} WHERE retracted = 0 AND user_id = '{0}' AND bid_id = {1} AND bidroom_id = {2}

java.lang.String

getRolePermission

SELECT role_permission.permission FROM role_permission JOIN user_info ON user_info.user_id = '{0}' AND user_info.passwd = '{1}' AND user_info.role = role_permission.role WHERE role_permission.msg = {2}

java.lang.String

addUser.checkUserId

SELECT COUNT(*) FROM user_info WHERE user_id = '{0}'

java.lang.String

addUser.addUser

INSERT INTO user_info (user_id{1}) VALUES ('{0}'{2})

java.lang.String

delUser

UPDATE user_info SET disabled = 1{1} WHERE user_id = '{0}'

java.lang.String

getUser

SELECT * FROM user_info WHERE user_id = '{0}'{1}

java.lang.String

setUser

UPDATE user_info SET user_id = '{0}'{1} WHERE user_id = '{0}'

java.lang.String

addBidroom.checkBidRoomName

SELECT COUNT(*) FROM bidding_rooms WHERE deleted = 0 AND bidroom_name = '{0}'{1}

java.lang.String

addBidroom.addBidroom

INSERT INTO bidding_rooms (bidroom_name{1}) VALUES ('{0}'{2})

java.lang.String

addBidroom.getBidRoomId

SELECT @@IDENTITY

java.lang.String

delBidroom

UPDATE bidding_rooms SET deleted = 1{1} WHERE bidroom_id = '{0}'

java.lang.String

starterUpdateBid.checkBid

SELECT status FROM bid_entity WHERE starter_id = '{0}' AND bidroom_id = {1} AND bid_id = {2} AND canceled = 0

java.lang.String

starterUpdateBid.updateBid

UPDATE bid_entity SET starter_id = '{0}', bidroom_id = {1}{3} WHERE starter_id = '{0}' AND bidroom_id = {1} AND bid_id = {2} AND canceled = 0

java.lang.String

addCategory.checkCategory

SELECT c1.cat_id AS PARENT, (c1.id_path + '/' + CAST(c1.cat_id AS VARCHAR)) AS IDPATH, (c1.name_path + '/' + c1.cat_name) AS NAMEPATH, c2.cat_id AS LINK, c3.cat_id AS CHILD FROM category AS c1 LEFT JOIN category AS c2 ON c1.bidroom_id = c2.bidroom_id AND c2.disabled = 0 AND c2.cat_link = 0 AND c2.cat_id = {3} LEFT JOIN category AS c3 ON c1.bidroom_id = c3.bidroom_id AND c1.cat_id = c3.cat_parent AND c3.disabled = 0 AND c3.cat_name = '{2}' WHERE c1.bidroom_id = {0} AND c1.is_leaf = 0 AND c1.cat_id = {1} UNION SELECT 0, '', '', c2.cat_id, c3.cat_id FROM category AS c1 LEFT JOIN category AS c2 ON c1.bidroom_id = c2.bidroom_id AND c2.disabled = 0 AND c2.cat_link = 0 AND c2.cat_id = {3} LEFT JOIN category AS c3 ON c1.bidroom_id = c3.bidroom_id AND c3.cat_parent = 0 AND c3.disabled = 0 AND c3.cat_name = '{2}' WHERE c1.bidroom_id = {0} AND {1} = 0

java.lang.String

addCategory.addCategory

INSERT INTO category (bidroom_id, cat_name, cat_parent, cat_link, id_path, name_path{6}) VALUES ({0}, '{2}', {1}, {3}, '{4}', '{5}'{7})

java.lang.String

addCategory.getCategoryId

SELECT @@IDENTITY

java.lang.String

delCategory

UPDATE category SET disabled = 1{2} WHERE bidroom_id = {0} AND cat_id = {1}

java.lang.String

listSubCategory

SELECT c0.cat_id, c0.cat_name, c0.name_path, (SELECT COUNT(*) FROM category AS c1 LEFT JOIN category AS c2 ON c1.bidroom_id = c2.bidroom_id AND c2.disabled = 0 AND (c1.cat_id = c2.cat_id OR c2.name_path LIKE (c1.name_path + '/' + c1.cat_name + '%')) JOIN bid_entity AS b ON c2.bidroom_id = b.bidroom_id AND c2.cat_id = b.category AND b.canceled = 0{2} WHERE c1.disabled = 0 AND c1.cat_id = c0.cat_id) AS BidNum FROM category AS c0 WHERE c0.cat_link = 0 AND c0.disabled = 0 AND c0.bidroom_id = {0} AND c0.cat_parent = {1} UNION SELECT c0.cat_link, c0.cat_name + '@', c0.name_path, (SELECT COUNT(*) FROM category AS c1 LEFT JOIN category AS c2 ON c1.bidroom_id = c2.bidroom_id AND c2.disabled = 0 AND (c1.cat_id = c2.cat_id OR c2.name_path LIKE (c1.name_path + '/' + c1.cat_name + '%')) JOIN bid_entity AS b ON c2.bidroom_id = b.bidroom_id AND c2.cat_id = b.category AND b.canceled = 0{2} WHERE c1.disabled = 0 AND c1.cat_id = c0.cat_link) AS BidNum FROM category AS c0 WHERE c0.cat_link > 0 AND c0.disabled = 0 AND c0.bidroom_id = {0} AND c0.cat_parent = {1}

java.lang.String

getCategory

SELECT * FROM category WHERE bidroom_id = {0} AND cat_id = {1} AND cat_link = 0 AND disabled = 0 UNION SELECT c2.* FROM category c1 JOIN category c2 ON c1.cat_link = c2.cat_id AND c1.bidroom_id = c2.bidroom_id AND c2.disabled = 0 WHERE c1.bidroom_id = {0} AND c1.cat_id = {1} AND c1.cat_link > 0 AND c1.disabled = 0

java.lang.String

getBid

SELECT * FROM bid_entity WHERE bidroom_id = {0} AND bid_id = {1}{2}

java.lang.String

micropayment.getAccount

SELECT pointvalue, bonusvalue FROM member WHERE id = '{0}'

java.lang.String

micropayment.log

INSERT INTO PointsLog (id, typeid, mercid, termid, cdate, ctime, lidm, amount, bonus, memo) VALUES ('{0}', {1}, '{2}', '{3}', '{4}', '{5}', '{6}', {7}, {8}, '{9}')

java.lang.String