public function insert(Request $request)
{
$user = new UserModel();
$user->username = $request->get('username');
$user->password = Hash::make($request->get('password'));
// Data asal skpd di tabel dukcapil
$user->nik = strval(rand(1000000000, 2000000000));
$user->nama = $request->get('nama');
$user->email = $request->get('username') . "@yahoo.com";
$user->kota_lahir = "Bandung";
$user->tanggal_lahir = "1994-04-10";
$user->jenis_kelamin = "laki-laki";
$user->gol_darah = "O";
$user->alamat = $request->get('alamat');
$user->rt = "11";
$user->rw = "03";
$user->kel_desa = "Coblong";
$user->kec = "Cibereum";
$user->kota_kab = "Bandung Selatan";
$user->kode_pos = "40121";
$user->agama = "Islam";
$user->status = "Belum menikah";
$user->role = "SKPD";
$user->save();
DB::table('ppl_citizenreport_penanggungjawab')->insert(array('id_kategori' => $request->get('id_kategori'), 'id_skpd' => $user->id));
return redirect('manajemen-skpd')->with('message', 'Akun SKPD telah dibuat.');
}
public function post_register(UserRegister $request)
{
$user = new UserModel();
$user->username = $request->username;
$user->password = Hash::make($request->password);
$user->email = $request->email;
$user->save();
return redirect()->route('home')->with('success', 'Đăng kí tài khoản thành công');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$user = new UserModel();
$user->name = $request->name;
$user->email = $request->email;
$user->password = bcrypt($request->password);
$user->save();
return Redirect::route('admin.users.index');
}
public function makeUserTable()
{
$domains = isset($_POST['domain_list']) ? htmlspecialchars($_POST['domain_list']) : '';
$domainArray = array();
if ($domains !== '') {
$domainsArray = explode("\n", $domains);
}
$userModel = new UserModel();
$userModel->cleanTable();
foreach ($domainsArray as $siteName) {
$site = str_replace("\r", "", $siteName);
$accessKeyId = "AKIAJGMJHABBXMYJDXTQ";
$secretAccessKey = "u2KzeMmzyymW0OyXTWcqukssiguYBWxe1otpkyhE";
$ActionName = 'UrlInfo';
$ResponseGroupName = 'Rank,ContactInfo,LinksInCount';
$ServiceHost = 'awis.amazonaws.com';
$NumReturn = 10;
$StartNum = 1;
$SigVersion = '2';
$HashAlgorithm = 'HmacSHA256';
$params = array('Action' => $ActionName, 'ResponseGroup' => $ResponseGroupName, 'AWSAccessKeyId' => $accessKeyId, 'Timestamp' => gmdate("Y-m-d\\TH:i:s.\\0\\0\\0\\Z", time()), 'Count' => $NumReturn, 'Start' => $StartNum, 'SignatureVersion' => $SigVersion, 'SignatureMethod' => $HashAlgorithm, 'Url' => $site);
ksort($params);
$keyvalue = array();
foreach ($params as $k => $v) {
$keyvalue[] = $k . '=' . rawurlencode($v);
}
$queryParams = implode('&', $keyvalue);
$sign = "GET\n" . strtolower($ServiceHost) . "\n/\n" . $queryParams;
$sig1 = base64_encode(hash_hmac('sha256', $sign, $secretAccessKey, true));
$sig = rawurlencode($sig1);
$url = 'http://' . $ServiceHost . '/?' . $queryParams . '&Signature=' . $sig;
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_TIMEOUT, 4);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$result = curl_exec($ch);
curl_close($ch);
$xml = new \SimpleXMLElement($result, null, false, 'http://awis.amazonaws.com/doc/2005-07-11');
if ($xml->count() && $xml->Response->UrlInfoResult->Alexa->count()) {
$info = $xml->Response->UrlInfoResult->Alexa;
$nice_array = array('Rank' => $info->TrafficData->Rank);
}
$rank = $nice_array['Rank'];
//put into table
$userModel = new UserModel();
$userModel->rank = $rank;
$userModel->name = $site;
$userModel->save();
}
return redirect()->intended('domainTable');
}
