< Back


# Packages

-  package root
  Definition Classes
    root
-  package controllers
  Definition Classes
    root
-  package importExcel
  Definition Classes
    controllers
-  package model
  Definition Classes
    importExcel
- ExcelControlData
- ExcelController
- ExcelEnregData

c

controllers.importExcel

# ExcelController

###

#### class ExcelController extends Model

Linear Supertypes
Model, Topic, Producer, AnyRef, Any

Ordering

1. Alphabetic
2. By Inheritance

Inherited

1. ExcelController
2. Model
3. Topic
4. Producer
5. AnyRef
6. Any

1. Hide All
2. Show All

Visibility

1. Public
2. Protected

### Instance Constructors

1.  new ExcelController(LogUtil: LogUtil, JobLogUtil: JobLogUtil, piezometerDaeau: PiezometerDaeau, contributorDao: ContributorsDao, codeSandreDao: SandreCodeDao, materielTypeDao: MaterielTypeDao, matTelecomTypeDao: TelecomTypeDao, simTypeDao: SimTypeDao, accessibilitesPiezoLinkDao: AccessibilitesPiezoLinkDao, piezometerEventDao: PiezometerEventDao, centralTypeDao: CentralTypeDao, powerSupplyTypeDao: PowerSupplyTypeDao, materielEquipmentDao: MaterielEquipmentDao, equipmentTypeDao: EquipmentTypeDao, equipmentSituationDao: EquipmentSituationDao, authorizationMaterielDao: AuthorizationMaterielDao, networkDao: NetworkDao, telecomDao: TelecomDao, materielSimDao: MaterielSimDao, simSituationDao: SimSituationDao, sensorTypeDao: SensorTypeDao, telecomSituationDao: TelecomSituationDao, materielSensorDao: MaterielSensorDao, variousMaterielTypeDao: VariousMaterielTypeDao, materielCentralDao: MaterielCentralDao, materielPowerSupplyDao: MaterielPowerSupplyDao, powerSupplySituationDao: PowerSupplySituationDao, centralSituationDao: CentralSituationDao, sensorSituationDao: SensorSituationDao, variousSituationDao: VariousSituationDao, materielVariousMaterielDao: MaterielVariousMaterielDao, centralChannelTypeDao: CentralChannelTypeDao, centralChannelDao: CentralChannelDao, matPowerSupplyDao: MaterielPowerSupplyDao, matTelecomDao: TelecomDao, variousMaterielDao: MaterielVariousMaterielDao, stationWorkDao: StationWorkDao, piezometerDiagnosticDao: PiezometerDiagnosticDao, anormAccessibilitesPiezoLinkDao: AccessibilitesPiezoLinkDao, telecomModeDao: TelecomModeDao, stationContributorDao: StationContributorDao, subscriptionDao: SubscriptionDao, simsubscriptionDao: SimSubscriptionDao, subscriptionSituationDao: SubscriptionSituationDao, evtSolutionsDao: EvtSolutionsDao, evtActionDao: EvtActionDao, centralRangeDao: CentralRangeDao, matModemsTypeDao: MatModemsTypeDao, stationTempRefDao: StationTempRefDao, materielDao: MaterielDao, cityDao: CityDao, telecomTypeDao: TelecomTypeDao, stationNetworkDao: StationNetworkDao, database: Database)
   Annotations
     @Inject()

### Type Members

1.  case class ContributorSandre(name: Option[String] = None, siret: Option[String] = None, sandre: Option[String] = None, creationDate: Option[DateTime] = None, status: Option[String] = None, updateDate: Option[DateTime] = None, auteur: Option[String] = None, mnemonique: Option[String] = None, postalBox: Option[String] = None, addressComplement: Option[String] = None, road: Option[String] = None, statePlace: Option[String] = None, city: Option[String] = None, department: Option[String] = None, comments: Option[String] = None, domain: Option[Int] = None, email: Option[String] = None, phoneTel: Option[String] = None, phoneTelSecond: Option[String] = None, fax: Option[String] = None, mobile: Option[String] = None, cityCode: Option[String] = None, cedexCode: Option[Double] = None, otherReference: Option[String] = None, codepostal: Option[String] = None, contributorCode: Option[Int] = None, raisonsociale: Option[String] = None, titre: Option[String] = None, jobexecutionid: Option[Long] = None, loginmaj: Option[String] = None, datemaj: Option[DateTime] = None, publicSchedule: Option[String] = None, schedule: Option[String] = None, cityCodeDelegate: Option[String] = None, postalCodeDelegate: Option[String] = None) extends Product with Serializable

### Value Members

1.  final def !=(arg0: Any): Boolean
   Definition Classes
     AnyRef → Any
2.  final def ##: Int
   Definition Classes
     AnyRef → Any
3.  final def ==(arg0: Any): Boolean
   Definition Classes
     AnyRef → Any
4.  final def asInstanceOf[T0]: T0
   Definition Classes
     Any
5.  def clone(): AnyRef
   Attributes
     protected[lang]
   Definition Classes
     AnyRef
   Annotations
     @throws(classOf[java.lang.CloneNotSupportedException]) @IntrinsicCandidate() @native()
6.  final def eq(arg0: AnyRef): Boolean
   Definition Classes
     AnyRef
7.  def equals(arg0: AnyRef): Boolean
   Definition Classes
     AnyRef → Any
8.  def execute(routingKey: String, message: JsValue): Unit
   Definition Classes
     ExcelController → Model
9.  def executeIntegration(message: JsValue): String
10.  def executeIntegrationCompta(message: JsValue): String
11.  def executeWrapper(routingKey: String, message: JsValue): Unit
    Definition Classes
      Model
12.  def getCellOptionDateString(row: Row, col: Int): Option[String]
13.  def getCellOptionInt(row: Row, col: Int): Option[Int]
14.  def getCellOptionString(row: Row, col: Int): Option[String]
15.  final def getClass(): Class[_ <: AnyRef]
    Definition Classes
      AnyRef → Any
    Annotations
      @IntrinsicCandidate() @native()
16.  def getIndexFromConstant(myConstants: Seq[String], headers: Map[String, Int], defaultCol: Int): Int
17.  def getRoutingKey(): String
    Definition Classes
      ExcelController → Model
18.  def handleError(e: Exception, jobExecutionId: Long): Unit
    Definition Classes
      ExcelController → Model
19.  def hashCode(): Int
    Definition Classes
      AnyRef → Any
    Annotations
      @IntrinsicCandidate() @native()
20.  def initTopic(): (String, (String, JsValue) => Unit)
    Definition Classes
      Model → Topic
21.  def insertwithContact(intervenant: ContributorSandre, user: Option[String]): (Int, Int)
22.  final def isInstanceOf[T0]: Boolean
    Definition Classes
      Any
23.  def loadXLSX(jobExecutionId: Long, filesToProcess: File, inBdd: Boolean, user: String): Boolean
24.  def loadXLSXCompta(jobExecutionId: Long, filesToProcess: File, inBdd: Boolean, user: String, theGestionnaire: Option[Int], withControlOnly: Boolean, nbheader: Option[Int], filename: String, updateImmo: Boolean): Boolean
25.  lazy val logUtil: LogUtil
    Definition Classes
      Topic
26.  lazy val logsUtil: LogUtil
    Definition Classes
      Producer
27.  final def ne(arg0: AnyRef): Boolean
    Definition Classes
      AnyRef
28.  final def notify(): Unit
    Definition Classes
      AnyRef
    Annotations
      @IntrinsicCandidate() @native()
29.  final def notifyAll(): Unit
    Definition Classes
      AnyRef
    Annotations
      @IntrinsicCandidate() @native()
30.  def purge_materiel(message: JsValue): String
31.  def sendRPC[A](routingKey: String, message: String)(implicit rds: Reads[A], m: ClassTag[A]): Future[A]
    Definition Classes
      Producer
32.  def sendRPC[A](routingKey: String, message: String, connection: Connection, channel: Channel, replyQueueName: String)(implicit rds: Reads[A], m: ClassTag[A]): Future[A]
    Definition Classes
      Producer
33.  def sendRPC[A](routingKey: String, message: String, timeout: Duration)(implicit rds: Reads[A], m: ClassTag[A]): A
    Definition Classes
      Producer
    Annotations
      @throws(classOf[java.util.concurrent.TimeoutException])
34.  def sendTopic(routingKey: String, message: String): Unit
    Definition Classes
      Producer
35.  def sendTopic(exchangeName: String, routingKey: String, queueName: String, message: String): Unit
    Definition Classes
      Producer
36.  final def synchronized[T0](arg0: => T0): T0
    Definition Classes
      AnyRef
37.  def toString(): String
    Definition Classes
      AnyRef → Any
38.  final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
      AnyRef
    Annotations
      @throws(classOf[java.lang.InterruptedException])
39.  final def wait(arg0: Long): Unit
    Definition Classes
      AnyRef
    Annotations
      @throws(classOf[java.lang.InterruptedException])
40.  final def wait(): Unit
    Definition Classes
      AnyRef
    Annotations
      @throws(classOf[java.lang.InterruptedException])

### Deprecated Value Members

1.  def finalize(): Unit
   Attributes
     protected[lang]
   Definition Classes
     AnyRef
   Annotations
     @throws(classOf[java.lang.Throwable]) @Deprecated
   Deprecated

     (Since version 9)

2.  def sendRPC(routingKey: String, message: String, consumerFn: (String, Envelope, BasicProperties, Array[Byte]) => Unit): Unit
   Definition Classes
     Producer
   Annotations
     @deprecated @Deprecated
   Deprecated

     Use sendRPC[A](routingKey: String, message: String)(implicit rds: Reads[A]): Future[JsResult[A]]

3.  def sendRPC(exchangeName: String, routingKey: String, queueName: String, message: String, consumerFn: (String, Envelope, BasicProperties, Array[Byte]) => Unit): Unit
   Definition Classes
     Producer
   Annotations
     @deprecated @Deprecated
   Deprecated

     Use sendRPC[A](routingKey: String, message: String)(implicit rds: Reads[A]): Future[JsResult[A]]

### Inherited from Model

### Inherited from Topic

### Inherited from Producer

### Inherited from AnyRef

### Inherited from Any

### Ungrouped