upgrade/newdirectory-0.0.1/alternate_subsubsectors.php

   1 #!/usr/bin/php5
   2 <?php
   3 require_once 'connect.db.inc.php';
   4
   5 $globals->debug = 0; //do not store backtraces
   6
   7 $data = implode('', file('arbo-UTF8.xml'));
   8 $parser = xml_parser_create();
   9 xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
  10 xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
  11 xml_parse_into_struct($parser, $data, $values, $tags);
  12 xml_parser_free($parser);
  13
  14 // loop through the structures
  15 foreach ($values as $val) {
  16     if ($val['tag'] == 'grand-domaine' && $val['type'] == 'open') {
  17         $res = XDB::execute('INSERT INTO  profile_job_sector_enum (name)
  18                                   VALUES  ({?})',
  19                             ucfirst(mb_strtolower($val['attributes']['intitule'])));
  20         $sectorid = XDB::insertId();
  21     }
  22     if ($val['tag'] == 'domaine' && $val['type'] == 'open') {
  23         $res = XDB::execute('INSERT INTO  profile_job_subsector_enum (sectorid, name)
  24                                   VALUES  ({?}, {?})',
  25                             $sectorid, $val['attributes']['intitule']);
  26         $subsectorid = XDB::insertId();
  27     }
  28     if ($val['tag'] == 'domaine-intermediaire' && $val['type'] == 'open') {
  29         $res = XDB::execute('INSERT INTO  profile_job_subsector_enum (sectorid, name, flags)
  30                                   VALUES  ({?}, {?}, \'optgroup\')',
  31                             $sectorid, $val['attributes']['intitule']);
  32     }
  33     if ($val['tag'] == 'fiche' && $val['type'] == 'open') {
  34         $res = XDB::execute('INSERT INTO  profile_job_subsubsector_enum (sectorid, subsectorid, name)
  35                                   VALUES  ({?}, {?}, {?})',
  36                             $sectorid, $subsectorid, $val['attributes']['intitule']);
  37         $subsubsectorid = XDB::insertId();
  38         $id = 0;
  39     }
  40     if ($val['tag'] == 'appellation' && $val['type'] == 'complete') {
  41         $res = XDB::execute('INSERT INTO  profile_job_alternates (id, subsubsectorid, name)
  42                                   VALUES  ({?}, {?}, {?})',
  43                             $id, $subsubsectorid, $val['attributes']['intitule']);
  44         ++$id;
  45     }
  46 }
  47
  48 /* vim:set et sw=4 sts=4 ts=4: */
  49 ?>