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:
