Package ru.bgcrm.dao.gsm

Class GsmDao

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.gsm.GsmDao

public class GsmDao
extends CommonDAO

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	GsmDao.OnecAuthentication
class	GsmDao.UserCar

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
GsmDao(Connection con)

Method Summary

Modifier and Type	Method	Description
String	generateAddressFrom(int userId, WaybillAddress waybillAddress)
String	generateAddressTo(int userId, WaybillAddress waybillAddress)
DailyWaybillAddress	getAddresses(int userId, Date date)
List<DailyWaybillAddress>	getAddresses(int userId, List<Date> workerDays, int cityIdOfficeAddress)
List<DailyWaybillAddress>	getDailyWaybillAddressesFromProcess(int userId, List<Date> workerDays)
static GsmDao.OnecAuthentication	getOnecAuthentication()
@NotNull String	getQueryCityTitleAndStreetTitle(WaybillAddress waybillAddress)
Map<String,List<Route>>	getRoutes(Date dateFrom, Date dateTo, int userId)
List<GsmDao.UserCar>	getUserCarList(String name)	Получение списка доступных водителю автомобилей
String	getWaybill(String number, String date)
List<Pair<Date,WaybillAddress>>	getWaybillAddressesFromProcess(int userId, List<Date> workerDays)
List<WaybillAddress>	getWaybillAddressesFromSEGroupQuartersWhichEqualsOfficeCityId(int userId, int officeCityId)
List<WaybillAddress>	getWaybillAddressesFromSEGroupQuartersWhichNotEqualsOfficeId(int userId, int officeCityId)
ru.ufanet.onec.ws.uat.WebServicePortType	getWebServicePortType()

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

GsmDao

public GsmDao(Connection con)
       throws BGException

Throws:

BGException

Method Details

getWebServicePortType

public ru.ufanet.onec.ws.uat.WebServicePortType getWebServicePortType()

getRoutes

public Map<String,List<Route>> getRoutes(Date dateFrom,
 Date dateTo,
 int userId)
                                  throws BGException,
SQLException

Throws:

BGException

SQLException

getAddresses

public DailyWaybillAddress getAddresses(int userId,
 Date date)
                                 throws BGException

Throws:

BGException

getAddresses

public List<DailyWaybillAddress> getAddresses(int userId,
 List<Date> workerDays,
 int cityIdOfficeAddress)
                                       throws BGException

Throws:

BGException

getDailyWaybillAddressesFromProcess

public List<DailyWaybillAddress> getDailyWaybillAddressesFromProcess(int userId,
 List<Date> workerDays)
                                                              throws BGException

Throws:

BGException

getWaybillAddressesFromProcess

public List<Pair<Date,WaybillAddress>> getWaybillAddressesFromProcess(int userId,
 List<Date> workerDays)
                                                               throws BGException

Throws:

BGException

getWaybillAddressesFromSEGroupQuartersWhichNotEqualsOfficeId

public List<WaybillAddress> getWaybillAddressesFromSEGroupQuartersWhichNotEqualsOfficeId(int userId,
 int officeCityId)
                                                                                  throws BGException

Throws:

BGException

getWaybillAddressesFromSEGroupQuartersWhichEqualsOfficeCityId

public List<WaybillAddress> getWaybillAddressesFromSEGroupQuartersWhichEqualsOfficeCityId(int userId,
 int officeCityId)
                                                                                   throws BGException

Throws:

BGException

generateAddressFrom

public String generateAddressFrom(int userId,
 WaybillAddress waybillAddress)
                           throws BGException

Throws:

BGException

generateAddressTo

public String generateAddressTo(int userId,
 WaybillAddress waybillAddress)
                         throws BGException

Throws:

BGException

getQueryCityTitleAndStreetTitle

@NotNull
public @NotNull String getQueryCityTitleAndStreetTitle(WaybillAddress waybillAddress)

getWaybill

public String getWaybill(String number,
 String date)
                  throws BGMessageException

Throws:

BGMessageException

getUserCarList

public List<GsmDao.UserCar> getUserCarList(String name)

Получение списка доступных водителю автомобилей

Parameters:

name - ФИО водителя

getOnecAuthentication

public static GsmDao.OnecAuthentication getOnecAuthentication()
                                                       throws BGException

Throws:

BGException