Cemasys.com

CEMAsys.com ble etablert i 2007 som en av de første nordiske konsulenthusene med utelukkende fokus på bærekraft. Siden det har CEMAsys utviklet seg til et internasjonalt selskap med flere enheter. CEMAsys Nordic har raskt etablert seg som et ledende konsulentselskap i Norden, med hovedkontor i Oslo og kontor i København. CEMAsys US ble nylig etablert i Boston. Klima og bærekraft er vår kjernevirksomhet. Parallelt med vår konsulentstab er vi et ESG-Techselskap som erobrer verden med våre digitale rapporteringsplattformer.

Ved å kombinere innovative systemløsninger og analytisk konsulentekspertise gir vi våre kunder veiledning i utvikling og forbedring av deres bærekraftstrategi. Vi tilbyr helhetlige tjenester for hvert trinn av bedriftens ESG-rapporteringen, omfattende datainnsamling og -håndtering, avansert analyse, strategiutvikling og karbonkompensasjon.

Over flere år har vi vært akkreditert partner til CDP og Science Based Target. I tråd med denne verdensomfattende investorrapporteringen bistår vi selskaper med å utvikle ambisiøse og realistiske utslippsreduksjonsmål som en integrert del av deres bærekraftstrategi, og vi hjelper med transparent rapportering av deres klimapåvirkning- og arbeid.

Ønsker du å arbeide som ESG-konsulent hos et av Nordens ledende konsulenthus innen bærekraftrapportering?

Vi søker deg som er strukturert, initiativrik og har interesse for å arbeide med og akselerere den grønne omstillingen til å bli en del av våre bærekraftkonsulenter med base i Oslo.

Som konsulent vil du inngå i vårt internasjonale Climate Change & Sustainability team som leverer alle fagtjenester til selskap innen mangfoldige bransjer over hele Norden.

Vi tilbyr en utfordrende og meningsfull jobb der du får muligheten til å bidra med din kompetanse og utvikles i samarbeid med engasjerte og erfarne ESG-konsulenter. Du vil bli en del av et faglig sterkt miljø og arbeide med varierte problemstillinger for internasjonale selskaper der ditt arbeid vil være en del av løsningen i noen av verdens mest presserende utfordringer.


Cemasys Nordic konsulenter skal bidra med internasjonal utvikling, og vi ønsker internasjonale profiler med nordiske språkkunnskaper velkommen til å søke.


Sentrale arbeidsoppgaver kan være:

  • Analysere og kartlegge klimadata
  • Utvikle klimaregnskap, Scope 3 screeninger og beregninger
  • Klima- og naturrisikoanalyser
  • Vitenskapsbaserte klimamål (SBTi)
  • Strategiutvikling
  • Vesentlighetsanalyser og skrive bærekraftrapporter
  • Rapportering i henhold til GRI Standarden, CSRD rammeverket
  • Rapportering til CDP og andre anerkjente internasjonale ESG-ratinger
  • Kontakt med kunder der du har ansvar for egen kundeportefølje


Som konsulent vil du samarbeide tett med kolleger mot eksterne samarbeidspartnere. Teamet du er en del av har ansvaret for et høyt antall krevende kunder. Felles for alle kundene er at de ønsker å bidra til en mer faktabasert rapportering av bærekraftdata til sine interessenter (kunder, aksjonærer, investorer og ansatte).

Ansvaret består i å arbeide med analyser, beregninger og rapporteringsoppdrag for våre kunder, hvor mange av våre største kunder krever at all rapportering skjer på engelsk.  


Kvalifikasjoner for stillingen:

  • Høyere utdanning på mastergradsnivå med gode akademiske resultater. Økonomi, ledelse, finans og tilsvarende og/eller naturvitenskaplig bakgrunn med realfagskompetanse (matte, fysikk, kjemi)
  • Analytisk dyktig, med særskilt vekt på tall- og databehandling.
  • Solide Excel-kunnskaper verdsettes
  • Gjerne 1-2 års arbeidserfaring
  • Kompetanse innen bærekraft, klima og miljø samt kjennskap til standarder og metoder innen bærekraft er en fordel


Din profil:

  • God på kommunikasjon og relasjonsbygging med mennesker
  • Fremoverlent og initiativrik i samhandling mot selskaper og kunder
  • Trives med analyser, rapportskriving, kundekontakt og møter
  • Er resultatorientert, effektiv og evner å jobbe under press
  • Kan jobbe både selvstendig og i team, og du er fleksibel og kan bidra der det trengs i hektiske leveranseperioder
  • Liker utfordringer og ser løsninger
  • Du er omstillingsdyktig og kan arbeide med flere ulike leveranser og kunder parallelt
  • Har svært god formidlingsevne på de norsk, svensk, finsk eller dansk, både skriftlig og muntlig
  • Har svært god formidlingsevne på engelsk, både skriftlig og muntlig
  • Har en internasjonal profil


Hva vi tilbyr:

  • Fulltid (100%) stillinger i et selskap som satser internasjonalt
  • Ansvar og oppdrag mot flere av Nordens største selskaper
  • Et stimulerende og uformelt fagmiljø innen bærekraftområdet
  • Gode faglige utviklingsmuligheter på et varierende og bredt arbeidsfelt
  • Konkurransedyktig lønn og bonusprogram for ansatte
  • Nyrenoverte og moderne lokaler i Oslo sentrum

Vi oppmuntrer søkere med ulike bakgrunner, da vi kontinuerlig har fokus på å bygge mangfold i teamet vårt.

Tilleggsopplysninger til stillingen:

Du bes laste opp CV, søknadsbrev og karakterutskrifter.

Applikasjonslogg
Tid Nivå Kategori Melding
18:55:15.590094 trace system.CModule
Loading "log" application component
in /www/jobbsys/live/public/index.php (29)
18:55:15.590282 trace system.CModule
Loading "input" application component
in /www/jobbsys/live/public/index.php (29)
18:55:15.590331 trace system.CModule
Loading "request" application component
in /www/jobbsys/live/public/index.php (29)
18:55:15.590404 trace system.CModule
Loading "urlManager" application component
in /www/jobbsys/live/public/index.php (29)
18:55:15.590964 trace system.base.CModule
Loading "job" module
in /www/jobbsys/live/public/index.php (29)
18:55:15.591064 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)
18:55:15.591125 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)
18:55:15.591198 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)
18:55:15.591402 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)
18:55:15.591660 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)
18:55:15.591856 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)
18:55:15.592086 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)
18:55:15.592514 trace system.CModule
Loading "session" application component
in /www/jobbsys/live/protected/base/Controller.php (76)
in /www/jobbsys/live/public/index.php (29)
18:55:15.592792 trace system.web.filters.CFilterChain
Running filter JobController.filteraccessControl()
in /www/jobbsys/live/public/index.php (29)
18:55:15.592828 trace system.CModule
Loading "user" application component
in /www/jobbsys/live/public/index.php (29)
18:55:15.592983 trace system.CModule
Loading "securityManager" application component
in /www/jobbsys/live/protected/components/WebUser.php (34)
in /www/jobbsys/live/public/index.php (29)
18:55:15.593415 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)
18:55:15.593822 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)
18:55:15.593841 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)
18:55:15.593882 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)
18:55:15.594580 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)
18:55:15.595875 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)
18:55:15.596396 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)
18:55:15.597023 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)
18:55:15.597352 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)
18:55:15.598294 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)
18:55:15.598777 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)
18:55:15.599391 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)
18:55:15.599729 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)
18:55:15.600351 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)
18:55:15.600677 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)
18:55:15.601483 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)
18:55:15.602132 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 >=
"2023-03-30" AND t.date_start <= "2023-03-30")) ORDER BY contact.firstname
asc, contact.firstname asc. Bound with :jobId='2705248', :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)
18:55:15.603661 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)
18:55:15.603849 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='8115'
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)
18:55:15.604034 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)
18:55:15.604204 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='8115'
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)
18:55:15.604481 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)
18:55:15.609915 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)
18:55:15.609956 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)
18:55:15.610765 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)
18:55:15.610984 trace system.db.CDbCommand
Executing SQL: UPDATE `job_statistic` SET `job_post_views`=job_post_views+1
WHERE job_id=:ycp0. Bound with :ycp0='2705248'
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)
18:55:15.614129 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
(268)
in /www/jobbsys/live/public/index.php (29)
18:55:15.614255 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
(268)
in /www/jobbsys/live/public/index.php (29)
18:55:15.614391 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)
18:55:15.614453 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)
18:55:15.615334 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)
18:55:15.615648 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)
18:55:15.615864 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)
18:55:15.616477 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)
18:55:15.616520 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)
18:55:15.616543 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)
18:55:15.616612 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)
18:55:15.616660 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)
18:55:15.616681 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)
18:55:15.616700 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)
18:55:15.617667 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
(268)
in /www/jobbsys/live/public/index.php (29)
18:55:15.618256 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 (161)
18:55:15.618422 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 (161)
18:55:15.619242 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 (161)
18:55:15.619508 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 (161)
18:55:15.619652 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 (161)
18:55:15.619823 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 (161)
18:55:15.620444 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 (161)
18:55:15.620688 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='8115'
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 (161)
18:55:15.620820 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 (161)
18:55:15.620949 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='16363'
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 (161)
18:55:15.621876 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)
18:55:15.622544 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
(268)
18:55:15.622881 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
(268)
18:55:15.622925 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
(268)
18:55:15.623575 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
(268)
18:55:15.623955 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
(268)
18:55:15.624737 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
(268)
18:55:15.625050 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
(268)