public function run() { // Initialize empty array $license = array(); $date = new DateTime(); $license[] = array('name' => 'Adobe Photoshop CS6', 'serial' => 'ZOMG-WtF-BBQ-SRSLY', 'purchase_date' => '2013-10-02', 'purchase_cost' => '2435.99', 'purchase_order' => '1', 'maintained' => '0', 'order_number' => '987698576946', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'seats' => 5, 'license_name' => '', 'license_email' => '', 'notes' => '', 'user_id' => 1, 'depreciation_id' => 2, 'deleted_at' => NULL, 'depreciate' => '0'); $license[] = array('name' => 'Git Tower', 'serial' => '98049890394-340485934', 'purchase_date' => '2013-10-02', 'purchase_cost' => '2435.99', 'purchase_order' => '1', 'maintained' => '1', 'order_number' => '987698576946', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'seats' => 2, 'license_name' => 'Alison Gianotto', 'license_email' => '*****@*****.**', 'notes' => '', 'user_id' => 1, 'depreciation_id' => 2, 'deleted_at' => NULL, 'depreciate' => '0'); // Delete all the old data DB::table('licenses')->truncate(); // Insert the new posts License::insert($license); }
$l->software($datas['logiciel']); $l->admin(true); } //Insert "other" keys $iter = XDB::iterator('SELECT logiciel, cle, eleve_id, binet_id FROM msdnaa.cles_autres'); while ($datas = $iter->next()) { $l = new License(); $l->insert(); $l->key($datas['cle']); $l->software($datas['logiciel']); if ($datas['eleve_id']) { $l->uid($datas['eleve_id']); } if ($datas['binet_id']) { $l->gid($datas['binet_id']); } } //Insert unregistred user keys $iter = XDB::iterator('SELECT logiciel, cle, prenom, nom, statut, mail FROM msdnaa.cles_unregistered_users'); while ($datas = $iter->next()) { $l = new License(); $l->insert(); $l->key($datas['cle']); $l->software($datas['logiciel']); $l->uid(0); $l->comments("Key given to " . $datas['prenom'] . " " . $datas['nom'] . " (" . $datas['statut'] . ") " . $datas['mail']); } echo "Done \n"; // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: