Norautron AS

Norautron AS er et selskap i teknologikonsernet Embron Group AS og er komplett kontraktsprodusent av kundespesifisert elektronikk og elektromekaniske produkter. Vi tilbyr et bredt spekter av tjenester innenfor prototyping, industrialisering og serieproduksjon av mekanikk, kretskort og komplette produkter/ systemer. Norautron AS er sertifisert i henhold ISO-9001/14001 og AQAP 2110. Vi har ca 950 ansatte globalt, hvorav 270 i Norge, som arbeider i et miljø der det stilles store krav til nøyaktighet, kvalitet og leveringstid i alle ledd. Selskapet i Norge omsetter for over 1.000 MNOK. Norautron har datterselskaper i Kina, Sverige og Polen samt et kontor i USA.

For mer informasjon om Norautron, se vår web side: www.norautron.no

Procurement Analyst

DETALJERT OG STRUKTURERT PROCURMENT ANALYST I 100% STILLING

Har du et øye for detaljer, er strukturert, nøyaktig og løsningsorientert? Vi leter etter en person som liker å ha orden på data og har interesse for excel. Stillingen ligger under Procurement og rapporterer til Strategic Procurement Manager

Vi legger stor vekt på personlige egenskaper og ønsker å utvikle rett person til å bli en kunnskapsrik ressurs i vårt strategiske team.


Arbeidsoppgaver:

  • Analysere og vedlikeholde ERP grunndata
    • Vedlikeholde ledetider i ERP ved å innhente informasjon, klargjøre data for import og rapportere endring
    • Klargjøre produktstrukturer i excel for import til ERP
    • Rydde grunndata i ERP for strukturer som fases ut

              

  • Utarbeide BOM (produkt) rapporter:
    • Kostanalyse
    • Tilgjengelighet
    • Ledetid
    • Produktanalyse ved bruk av SiiconExpert


Dine kvalifikasjoner vil påvirke oppgaver og grad av selvstendighet i arbeidshverdagen. Du vil være en del av en avdeling på 4 som jobber med strategisk arbeid i form av kost, grunndata og rutiner. Noen oppgaver er ferdigdefinert, mens andre blir til ut fra kompetanse.


Den ideelle kandidaten

Den rette kandidaten er klar til å «ta i et tak» og finne seg til rette i et endringsorientert miljø med kort beslutningsprosess og rask gjennomføring. Du er nysgjerrig av natur og motiveres av å finne løsninger og bygge gode rutiner.

Du har evnen til å skifte fokus etter behov, gjøre fortløpende prioriteringer, og samtidig godta og respektere beslutninger når de er tatt.


Personlige egenskaper

  • Du er strukturert, analytisk og grundig i ditt arbeid
  • Løsningsorientert
  • Tar initiativ til å finne informasjon når du trenger det
  • Er en lagspiller, men er også komfortabel med å jobbe selvstendig
  • Positiv og nysgjerrig

 

Ønskede Kvalifikasjoner

  • Relevant utdanning innen logistikk eller økonomi
  • Excel (svært god kjennskap og anvendelse)
  • ERP-system; IFS (erfaring fra IFS ikke viktig, men en fordel)
  • Kjennskap til elektronikk komponenter er en fordel
  • Gode kommunikasjonsevner, både skriftlig og muntlig i Norsk og Engelsk

 

Norautron tilbyr

  • Grundig opplæring i et inspirerende miljø med trivelige kolleger
  • En spennende og utfordrende stilling
  • Konkurransedyktige betingelser
  • Gode utviklingsmuligheter
  • Kantineordning og firmaleiligheter


Kontaktperson: Laila Mikkelsen.

E-post: laila.mikkelsen@norautron.com

Tlf: 934 09 150

 

Søknadsfrist: 12.mai. Søknader vurderes fortløpende

 

Applikasjonslogg
Tid Nivå Kategori Melding
19:30:55.957304 trace system.CModule
Loading "log" application component
in /www/jobbsys/live/public/index.php (29)
19:30:55.957418 trace system.CModule
Loading "input" application component
in /www/jobbsys/live/public/index.php (29)
19:30:55.957463 trace system.CModule
Loading "request" application component
in /www/jobbsys/live/public/index.php (29)
19:30:55.957525 trace system.CModule
Loading "urlManager" application component
in /www/jobbsys/live/public/index.php (29)
19:30:55.958060 trace system.base.CModule
Loading "job" module
in /www/jobbsys/live/public/index.php (29)
19:30:55.958163 trace system.CModule
Loading "assetManager" application component
in /www/jobbsys/live/protected/base/WebModule.php (255)
in /www/jobbsys/live/protected/base/WebModule.php (233)
in /www/jobbsys/live/protected/modules/job/JobModule.php (38)
19:30:55.958224 trace system.CModule
Loading "clientScript" application component
in /www/jobbsys/live/protected/base/WebModule.php (283)
in /www/jobbsys/live/protected/base/WebModule.php (233)
in /www/jobbsys/live/protected/modules/job/JobModule.php (38)
19:30:55.958261 trace system.base.CModule
Loading "user" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/job/JobModule.php (38)
in /www/jobbsys/live/public/index.php (29)
19:30:55.958422 trace system.base.CModule
Loading "customer" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/user/UserModule.php (41)
in /www/jobbsys/live/protected/base/WebModule.php (240)
19:30:55.958581 trace system.base.CModule
Loading "admin" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (52)
in /www/jobbsys/live/protected/base/WebModule.php (240)
19:30:55.958734 trace system.base.CModule
Loading "content" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/admin/AdminModule.php (58)
in /www/jobbsys/live/protected/base/WebModule.php (240)
19:30:55.958903 trace system.base.CModule
Loading "cv" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (52)
in /www/jobbsys/live/protected/base/WebModule.php (240)
19:30:55.959160 trace system.CModule
Loading "session" application component
in /www/jobbsys/live/protected/base/Controller.php (76)
in /www/jobbsys/live/public/index.php (29)
19:30:55.959611 trace system.web.filters.CFilterChain
Running filter JobController.filteraccessControl()
in /www/jobbsys/live/public/index.php (29)
19:30:55.959633 trace system.CModule
Loading "user" application component
in /www/jobbsys/live/public/index.php (29)
19:30:55.959703 trace system.CModule
Loading "securityManager" application component
in /www/jobbsys/live/protected/components/WebUser.php (34)
in /www/jobbsys/live/public/index.php (29)
19:30:55.959945 trace system.CModule
Loading "messages" application component
in /www/jobbsys/live/protected/helpers/LayoutHelper.php (192)
in /www/jobbsys/live/protected/modules/job/models/Job.php (662)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
19:30:55.960210 trace system.db.ar.CActiveRecord
Job.find()
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.960226 trace system.CModule
Loading "db" application component
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.960258 trace system.db.CDbConnection
Opening DB connection
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.961065 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.962163 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.962518 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `customer_client`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.963052 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `customer_client`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.963269 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `customer`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.963982 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `customer`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.964354 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job_category`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.964834 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job_category`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.965128 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job_contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.965593 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job_contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.965804 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.966351 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.966737 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`lang_id` AS `t0_c1`,
`t`.`customer_client_id` AS `t0_c2`, `t`.`address_id` AS `t0_c3`,
`t`.`title` AS `t0_c4`, `t`.`position` AS `t0_c5`, `t`.`visibility` AS
`t0_c6`, `t`.`content` AS `t0_c7`, `t`.`alt_customer_name` AS `t0_c8`,
`t`.`customer_description` AS `t0_c9`, `t`.`reference_number` AS `t0_c10`,
`t`.`last_search_day` AS `t0_c11`, `t`.`date_start` AS `t0_c12`,
`t`.`date_finish` AS `t0_c13`, `t`.`date_modified` AS `t0_c14`,
`t`.`display_rule` AS `t0_c15`, `t`.`default_link` AS `t0_c16`, `t`.`link`
AS `t0_c17`, `t`.`logo` AS `t0_c18`, `t`.`active` AS `t0_c19`, `t`.`status`
AS `t0_c20`, `t`.`created_by` AS `t0_c21`, `t`.`created_date` AS `t0_c22`,
`t`.`modified_by` AS `t0_c23`, `t`.`modified_date` AS `t0_c24`,
`t`.`sort_priority` AS `t0_c25`, `t`.`import_id` AS `t0_c26`,
`t`.`import_source_id` AS `t0_c27`, `t`.`application_list` AS `t0_c28`,
`t`.`application_list_show` AS `t0_c29`, `customerClient`.`id` AS `t1_c0`,
`customerClient`.`agency_id` AS `t1_c1`, `customerClient`.`customer_id` AS
`t1_c2`, `customerClient`.`client_id` AS `t1_c3`,
`customerClient`.`default_view` AS `t1_c4`, `customerClient`.`active` AS
`t1_c5`, `customer`.`id` AS `t2_c0`, `customer`.`primary_user_id` AS
`t2_c1`, `customer`.`name` AS `t2_c2`, `customer`.`orgno` AS `t2_c3`,
`customer`.`type` AS `t2_c4`, `customer`.`catalog` AS `t2_c5`,
`customer`.`homepage` AS `t2_c6`, `customer`.`email` AS `t2_c7`,
`customer`.`phone` AS `t2_c8`, `customer`.`fax` AS `t2_c9`,
`customer`.`description` AS `t2_c10`, `customer`.`default_job_description`
AS `t2_c11`, `customer`.`have_template` AS `t2_c12`,
`customer`.`not_billing` AS `t2_c13`, `customer`.`active` AS `t2_c14`,
`customer`.`logo` AS `t2_c15`, `customer`.`link` AS `t2_c16`,
`customer`.`filter_type` AS `t2_c17`, `customer`.`open_application` AS
`t2_c18`, `customer`.`open_application_description` AS `t2_c19`,
`customer`.`created_by` AS `t2_c20`, `customer`.`created_date` AS `t2_c21`,
`customer`.`modified_by` AS `t2_c22`, `customer`.`modified_date` AS
`t2_c23`, `customer`.`delete_app_days` AS `t2_c24`, `client`.`id` AS
`t3_c0`, `client`.`primary_user_id` AS `t3_c1`, `client`.`name` AS `t3_c2`,
`client`.`orgno` AS `t3_c3`, `client`.`type` AS `t3_c4`, `client`.`catalog`
AS `t3_c5`, `client`.`homepage` AS `t3_c6`, `client`.`email` AS `t3_c7`,
`client`.`phone` AS `t3_c8`, `client`.`fax` AS `t3_c9`,
`client`.`description` AS `t3_c10`, `client`.`default_job_description` AS
`t3_c11`, `client`.`have_template` AS `t3_c12`, `client`.`not_billing` AS
`t3_c13`, `client`.`active` AS `t3_c14`, `client`.`logo` AS `t3_c15`,
`client`.`link` AS `t3_c16`, `client`.`filter_type` AS `t3_c17`,
`client`.`open_application` AS `t3_c18`,
`client`.`open_application_description` AS `t3_c19`, `client`.`created_by`
AS `t3_c20`, `client`.`created_date` AS `t3_c21`, `client`.`modified_by` AS
`t3_c22`, `client`.`modified_date` AS `t3_c23`, `client`.`delete_app_days`
AS `t3_c24`, `jobCategories`.`id` AS `t4_c0`, `jobCategories`.`job_id` AS
`t4_c1`, `jobCategories`.`category_id` AS `t4_c2`, `jobContacts`.`id` AS
`t5_c0`, `jobContacts`.`job_id` AS `t5_c1`, `jobContacts`.`contact_id` AS
`t5_c2`, `jobContacts`.`permission` AS `t5_c3`, `jobContacts`.`type` AS
`t5_c4`, `jobContacts`.`sort_order` AS `t5_c5`, `contact`.`id` AS `t6_c0`,
`contact`.`user_id` AS `t6_c1`, `contact`.`customer_id` AS `t6_c2`,
`contact`.`title` AS `t6_c3`, `contact`.`firstname` AS `t6_c4`,
`contact`.`lastname` AS `t6_c5`, `contact`.`phone` AS `t6_c6`,
`contact`.`cellphone` AS `t6_c7`, `contact`.`email` AS `t6_c8`,
`contact`.`email_display` AS `t6_c9`, `contact`.`perms` AS `t6_c10`,
`contact`.`active` AS `t6_c11`, `contact`.`receive_open_application` AS
`t6_c12`, `contact`.`created_by` AS `t6_c13`, `contact`.`created_date` AS
`t6_c14`, `contact`.`modified_by` AS `t6_c15`, `contact`.`modified_date` AS
`t6_c16` FROM `job` `t`  INNER JOIN `customer_client` `customerClient` ON
(`t`.`customer_client_id`=`customerClient`.`id`) INNER JOIN `customer`
`customer` ON (`customerClient`.`customer_id`=`customer`.`id`) INNER JOIN
`customer` `client` ON (`customerClient`.`client_id`=`client`.`id`) LEFT
JOIN `job_category` `jobCategories` ON (`jobCategories`.`job_id`=`t`.`id`)
LEFT JOIN `job_contact` `jobContacts` ON (`jobContacts`.`job_id`=`t`.`id`)
LEFT JOIN `contact` `contact` ON
(`jobContacts`.`contact_id`=`contact`.`id`) AND ((contact.active!=0) AND
(contact.active = :contactActive)) WHERE ((t.status!=15) AND (t.id = :jobId
AND t.active = :jobActive AND t.status = :jobStatus AND t.date_finish >=
"2024-05-02" AND t.date_start <= "2024-05-02")) ORDER BY contact.firstname
asc, contact.firstname asc. Bound with :jobId='2706939', :jobActive=1,
:jobStatus=11, :contactActive=1
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.967907 trace system.db.ar.CActiveRecord
lazy loading Contact.customer
in /www/jobbsys/live/protected/modules/customer/models/Contact.php (495)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.968112 trace system.db.CDbCommand
Querying SQL: SELECT `customer`.`id` AS `t1_c0`,
`customer`.`primary_user_id` AS `t1_c1`, `customer`.`name` AS `t1_c2`,
`customer`.`orgno` AS `t1_c3`, `customer`.`type` AS `t1_c4`,
`customer`.`catalog` AS `t1_c5`, `customer`.`homepage` AS `t1_c6`,
`customer`.`email` AS `t1_c7`, `customer`.`phone` AS `t1_c8`,
`customer`.`fax` AS `t1_c9`, `customer`.`description` AS `t1_c10`,
`customer`.`default_job_description` AS `t1_c11`,
`customer`.`have_template` AS `t1_c12`, `customer`.`not_billing` AS
`t1_c13`, `customer`.`active` AS `t1_c14`, `customer`.`logo` AS `t1_c15`,
`customer`.`link` AS `t1_c16`, `customer`.`filter_type` AS `t1_c17`,
`customer`.`open_application` AS `t1_c18`,
`customer`.`open_application_description` AS `t1_c19`,
`customer`.`created_by` AS `t1_c20`, `customer`.`created_date` AS `t1_c21`,
`customer`.`modified_by` AS `t1_c22`, `customer`.`modified_date` AS
`t1_c23`, `customer`.`delete_app_days` AS `t1_c24` FROM `customer`
`customer`  WHERE (`customer`.`id`=:ypl0). Bound with :ypl0='113766'
in /www/jobbsys/live/protected/modules/customer/models/Contact.php (495)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.968312 trace system.db.ar.CActiveRecord
lazy loading Contact.customer
in /www/jobbsys/live/protected/modules/customer/models/Contact.php (495)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.968435 trace system.db.CDbCommand
Querying SQL: SELECT `customer`.`id` AS `t1_c0`,
`customer`.`primary_user_id` AS `t1_c1`, `customer`.`name` AS `t1_c2`,
`customer`.`orgno` AS `t1_c3`, `customer`.`type` AS `t1_c4`,
`customer`.`catalog` AS `t1_c5`, `customer`.`homepage` AS `t1_c6`,
`customer`.`email` AS `t1_c7`, `customer`.`phone` AS `t1_c8`,
`customer`.`fax` AS `t1_c9`, `customer`.`description` AS `t1_c10`,
`customer`.`default_job_description` AS `t1_c11`,
`customer`.`have_template` AS `t1_c12`, `customer`.`not_billing` AS
`t1_c13`, `customer`.`active` AS `t1_c14`, `customer`.`logo` AS `t1_c15`,
`customer`.`link` AS `t1_c16`, `customer`.`filter_type` AS `t1_c17`,
`customer`.`open_application` AS `t1_c18`,
`customer`.`open_application_description` AS `t1_c19`,
`customer`.`created_by` AS `t1_c20`, `customer`.`created_date` AS `t1_c21`,
`customer`.`modified_by` AS `t1_c22`, `customer`.`modified_date` AS
`t1_c23`, `customer`.`delete_app_days` AS `t1_c24` FROM `customer`
`customer`  WHERE (`customer`.`id`=:ypl0). Bound with :ypl0='113766'
in /www/jobbsys/live/protected/modules/customer/models/Contact.php (495)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
19:30:55.968624 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `category`
WHERE lang_id='no'
ORDER BY `id` ASC
in /www/jobbsys/live/protected/modules/job/models/Category.php (98)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(174)
in /www/jobbsys/live/public/index.php (29)
19:30:55.971584 trace system.db.ar.CActiveRecord
JobStatistic.updateAll()
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
19:30:55.971620 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job_statistic`
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
19:30:55.972559 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job_statistic`
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
19:30:55.972799 trace system.db.CDbCommand
Executing SQL: UPDATE `job_statistic` SET `job_post_views`=job_post_views+1
WHERE job_id=:ycp0. Bound with :ycp0='2706939'
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
19:30:55.974828 trace system.db.ar.CActiveRecord
UserFavourites.findAll()
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
19:30:55.974889 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `user_favourites`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
19:30:55.975691 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `user_favourites`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
19:30:55.976046 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `user_favourites` `t`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
19:30:55.976733 trace system.CModule
Loading "pageTitle" application component
in /www/jobbsys/live/protected/base/Controller.php (108)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
in /www/jobbsys/live/public/index.php (29)
19:30:55.976772 trace system.CModule
Loading "menu" application component
in /www/jobbsys/live/protected/base/Controller.php (108)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
in /www/jobbsys/live/public/index.php (29)
19:30:55.976823 trace system.db.ar.CActiveRecord
User.findByPk()
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
19:30:55.976860 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `user`
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
19:30:55.977637 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `user`
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
19:30:55.977933 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `user` `t` WHERE (t.status!=10) AND (`t`.`id`
IS NULL) LIMIT 1
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
19:30:55.978135 trace system.CModule
Loading "authManager" application component
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (104)
in /www/jobbsys/live/protected/components/Menu.php (62)
19:30:55.978394 trace application
Checking ACL for WEB_PAGES::read, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (104)
19:30:55.978430 trace application
Checking ACL for WEB_PAGES::add, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/modules/admin/AdminModule.php (178)
19:30:55.978446 trace application
Checking ACL for CUSTOMER::add, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (110)
19:30:55.978506 trace application
Checking ACL for JOB_POST::admin_functions, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (159)
19:30:55.978549 trace application
Checking ACL for CUSTOMER::edit, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (219)
19:30:55.978566 trace application
Checking ACL for USER::edit, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (230)
19:30:55.978583 trace application
Checking ACL for JOB_POST::add, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (243)
19:30:55.979234 trace system.CModule
Loading "widgetFactory" application component
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (36)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
in /www/jobbsys/live/public/index.php (29)
19:30:55.980110 trace system.db.ar.CActiveRecord
lazy loading Job.address
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.980350 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.981179 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.981453 trace system.db.CDbCommand
Querying SQL: SELECT `address`.`id` AS `t1_c0`, `address`.`country_id` AS
`t1_c1`, `address`.`address` AS `t1_c2`, `address`.`formatted_address` AS
`t1_c3`, `address`.`administrative_area_level_1` AS `t1_c4`,
`address`.`administrative_area_level_2` AS `t1_c5`,
`address`.`administrative_area_level_3` AS `t1_c6`, `address`.`route` AS
`t1_c7`, `address`.`street_number` AS `t1_c8`, `address`.`postal_code` AS
`t1_c9`, `address`.`postal_town` AS `t1_c10`, `address`.`lat` AS `t1_c11`,
`address`.`lng` AS `t1_c12`, `address`.`status` AS `t1_c13` FROM `address`
`address`  WHERE (`address`.`id`=:ypl0). Bound with :ypl0=NULL
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.981573 trace system.db.ar.CActiveRecord
lazy loading Customer.streetAddress
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.981769 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `customer_address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.982436 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `customer_address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.982711 trace system.db.CDbCommand
Querying SQL: SELECT `streetAddress`.`id` AS `t1_c0`,
`streetAddress`.`customer_id` AS `t1_c1`, `streetAddress`.`address_id` AS
`t1_c2`, `streetAddress`.`reference` AS `t1_c3`, `streetAddress`.`type` AS
`t1_c4` FROM `customer_address` `streetAddress`  WHERE (streetAddress.type
= :type) AND (`streetAddress`.`customer_id`=:ypl0). Bound with :type=1,
:ypl0='113766'
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.982871 trace system.db.ar.CActiveRecord
lazy loading CustomerAddress.address
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.982995 trace system.db.CDbCommand
Querying SQL: SELECT `address`.`id` AS `t1_c0`, `address`.`country_id` AS
`t1_c1`, `address`.`address` AS `t1_c2`, `address`.`formatted_address` AS
`t1_c3`, `address`.`administrative_area_level_1` AS `t1_c4`,
`address`.`administrative_area_level_2` AS `t1_c5`,
`address`.`administrative_area_level_3` AS `t1_c6`, `address`.`route` AS
`t1_c7`, `address`.`street_number` AS `t1_c8`, `address`.`postal_code` AS
`t1_c9`, `address`.`postal_town` AS `t1_c10`, `address`.`lat` AS `t1_c11`,
`address`.`lng` AS `t1_c12`, `address`.`status` AS `t1_c13` FROM `address`
`address`  WHERE (`address`.`id`=:ypl0). Bound with :ypl0='12595'
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
19:30:55.984280 trace system.CModule
Loading "statePersister" application component
in /www/jobbsys/live/protected/components/views/newLangBox.php (4)
in /www/jobbsys/live/protected/components/LangBox.php (11)
in /www/jobbsys/live/protected/views/layouts/new.php (130)
19:30:55.984765 trace system.CModule
Loading "systemMsg" application component
in /www/jobbsys/live/protected/widgets/SystemMessagesWidget.php (27)
in /www/jobbsys/live/protected/views/layouts/new.php (248)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
19:30:55.984963 trace system.db.ar.CActiveRecord
ContentCategory.findAll()
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
19:30:55.985027 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `content_category`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
19:30:55.985698 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `content_category`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
19:30:55.985996 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `content`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
19:30:55.986664 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `content`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
19:30:55.986937 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`lang_id` AS `t0_c1`,
`t`.`parent_id` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`grp_alias` AS
`t0_c4`, `pages`.`title` AS `t1_c6`, `pages`.`alias` AS `t1_c8`,
`pages`.`url` AS `t1_c9`, `pages`.`sort_order` AS `t1_c12`, `pages`.`id` AS
`t1_c0` FROM `content_category` `t`  LEFT OUTER JOIN `content` `pages` ON
(`pages`.`category_id`=`t`.`id`) AND (pages.lang_id = :pagesLangId AND
pages.active = 1 AND pages.parent_id IS NULL) WHERE (((t.lang_id=:langId)
AND (t.id=:ycp1)) AND (t.parent_id=:ycp2)) ORDER BY pages.sort_order ASC.
Bound with :langId='no', :ycp1='4', :ycp2='1', :pagesLangId='no'
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)