Пример #1
0
 public function Fabricantes()
 {
     $nItems = 0;
     $nErrores = 0;
     $dbLink = mysql_connect("localhost", "root", "albatronic");
     $query = "TRUNCATE {$this->dbDestino}.ErpFabricantes";
     mysql_query($query);
     $query = "select * from {$this->dbOrigen}.fabricantes";
     $result = mysql_query($query, $dbLink);
     while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
         $row = $this->utf($row);
         $c = new Fabricantes();
         $c->setIDFabricante($row['IDFabricante']);
         $c->setTitulo($row['Fabricante']);
         $c->setTelefono($row['Telefono']);
         $c->setWeb($row['Web']);
         $c->setEmail($row['EMail']);
         $c->setPrimaryKeyMD5(md5($row['IDFabricante']));
         if ($c->create() == NULL) {
             $errores[] = $c->getErrores();
             $nErrores++;
         } else {
             $nItems++;
         }
     }
     //mysql_close($dbLink);
     echo "Fabricantes {$nItems}<br/>";
     if (count($errores)) {
         echo "<pre>";
         print_r($errores);
         echo "</pre>";
     }
 }