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 and 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 and Description
GsmDao(java.sql.Connection con)

Method Summary

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

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, 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 Detail

GsmDao

public GsmDao(java.sql.Connection con)
       throws BGException

Throws:

BGException

Method Detail

getWebServicePortType

public WebServicePortType getWebServicePortType()

getRoutes

public java.util.Map<java.lang.String,java.util.List<Route>> getRoutes(java.util.Date dateFrom,
                                                                       java.util.Date dateTo,
                                                                       int userId)
                                                                throws BGException,
                                                                       java.sql.SQLException

Throws:

BGException

java.sql.SQLException

getAddresses

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

Throws:

BGException

getAddresses

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

Throws:

BGException

getDailyWaybillAddressesFromProcess

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

Throws:

BGException

getWaybillAddressesFromProcess

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

Throws:

BGException

getWaybillAddressesFromSEGroupQuartersWhichNotEqualsOfficeId

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

Throws:

BGException

getWaybillAddressesFromSEGroupQuartersWhichEqualsOfficeCityId

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

Throws:

BGException

generateAddressFrom

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

Throws:

BGException

generateAddressTo

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

Throws:

BGException

getQueryCityTitleAndStreetTitle

public java.lang.String getQueryCityTitleAndStreetTitle(WaybillAddress waybillAddress)

getWaybill

public java.lang.String getWaybill(java.lang.String number,
                                   java.lang.String date)
                            throws BGMessageException

Throws:

BGMessageException

getUserCarList

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

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

Parameters:

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

getOnecAuthentication

public static GsmDao.OnecAuthentication getOnecAuthentication()
                                                       throws BGException

Throws:

BGException