private static function addVendors($dbc, $sql, $type)
 {
     $rows = DB::connection($dbc)->select($sql);
     foreach ($rows as $row) {
         $address = Address::create(['address1' => $row->address1, 'address2' => $row->address2, 'city' => $row->city, 'state' => $row->state, 'zip' => $row->zip, 'country' => $row->country, 'phone' => $row->phone, 'fax' => $row->fax, 'comments' => 'Contact: ' . $row->primary_contact . PHP_EOL . 'Emails: ' . $row->email, 'active' => 1]);
         //going to loose the contact....
         $vendor = Vendor::create(['contact_id' => 0, 'billing_address_id' => $address->id, 'shipping_address_id' => 0, 'type' => $type, 'name' => $row->company, 'account_number' => bcrypt(craigsDecryption($row->account_number)), 'active' => 1]);
     }
 }
 public static function recryptUserPassword($data)
 {
     for ($i = 0; $i < sizeof($data); $i++) {
         $password = $data[$i]['password'];
         $password = craigsDecryption($data[$i]['password']);
         $data[$i]['password'] = Crypt::encrypt($password);
         //var_dump(Crypt::decrypt($data[$i]['account_number']));
     }
     return $data;
 }