<?php
if (session_status() == PHP_SESSION_NONE) {
    session_start();
}
require_once '../donbc/class.user.php';
require_once '../donbc/dbcon.php';
$user = new USER ;
if(isset($_GET['reg']))
{
$regno = $_GET['reg'] ;
}
else
{
$regno = $_SESSION['client_id'] ;
}
//
function sendViaPost($url, $arr_params, $headers = array('Content-Type: application/x-www-form-urlencoded')) 
{
    $response = array();
    $final_url_data = $arr_params;
    if (is_array($arr_params)) {
        $final_url_data = http_build_query($arr_params, '', '&');
    }
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $final_url_data);
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_NOSIGNAL, 1);
    curl_setopt($ch, CURLOPT_VERBOSE, 1);
    curl_setopt($ch, CURLOPT_TIMEOUT, 30);
    $response['body'] = curl_exec($ch);
    $response['code'] = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);
    return $response['body'];
}


//get data from address
$sqlallo = $DBcon->prepare("select * from allotee_biodata where regno = '$regno'") ;
$sqlallo->execute() ;
if($sqlallo->rowcount() > 0)
{
$addrow = $sqlallo->fetch(pdo::FETCH_ASSOC) ;
$custodian = $addrow['custodian'] ;
$office = $addrow['allote_office'] ;
$phone = $addrow['allote_phone'] ;
$email = $addrow['allote_email'] ;
$astate = $addrow['state'] ;
$lga = $addrow['lga'] ;
$nation = $addrow['nationality'] ;
$creg = $addrow['company_regno'] ;
$mid = $addrow['identification_means'] ;
$idno = $addrow['id_no'] ;
$adm = $addrow['admin'] ;
}
//get data from bio data
$sqlstal = $DBcon->prepare("select * from stall_details where regno = '$regno'") ;
$sqlstal->execute() ;
if($sqlstal->rowcount() > 0)
{
$addro = $sqlstal->fetch(pdo::FETCH_ASSOC) ;
$mname = $addro['market'] ;
$town = $addro['town'] ;
$mlga = $addro['lga'] ;
$msection = $addro['market_section'] ;
$zone = $addro['zone'] ;
$lineno = $addro['line_no'] ;
$stallno = $addro['stall_no'] ;
$stype = $addro['stall_type'] ;
$certno = $addro['alloc_cert_no'] ;
$basis = $addro['bas_of_occup'] ;
$ansid = $addro['ansid_no'] ;
$eno = $addro['en_no'] ;
$fmno = $addro['formno'] ;
$fmen = $fmno."/".$eno ;
}
//$pwd = $addros['pwd'] ;
//$ans = $addros['ans'] ;
//$image = $addros['image'] ;
//get data from next of kin
$sqln = $DBcon->prepare("select * from nextofkin where regno = '$regno'") ;
$sqln->execute() ;
if($sqln->rowcount() > 0)
{
$addron = $sqln->fetch(pdo::FETCH_ASSOC) ;
$nkn = $addron['names'] ;
$relation = $addron['relationship'] ;
$nphone = $addron['phoneno'] ;
}
//get passport
$sqld = $DBcon->prepare("select * from documents where regno = '$regno'") ;
$sqld->execute() ;
if($sqld->rowcount() > 0)
{
$addd = $sqld->fetch(pdo::FETCH_ASSOC) ;
$image = $addd['image'] ;
}
{
	/*
//message parameter
$senderID ="ANSMAPORTAL";
$mobile = $phone;
$messageBody = "Congrat!,Your Stall Digitalisation Excercise is succesful. your Logins: ID: $regno." ;
$url = "https://www.bulksmsnigeria.com/api/v1/sms/create";
$apiToken = 'MmgcsjkuDtlloSXw3sZZOwHciYBPst0nKiBPLgwhTKEBQrzP58ixejQhXdPa';

//Pass all Parameters into a array to be submitted to the SendViaPost function as a Single Variable
$arr_params = array(
    'from'  	=>  $senderID,
    'to'  		=>  $mobile,
    'body'  	=>  $messageBody,
    'api_token' =>  $apiToken,
    'dnd'       =>  1
);

if(!isset($_GET['reg']))
{
sendViaPost($url,$arr_params) ;
}
*/
}

// new sms gateway
  $email = "fortressystem@gmail.com";
  $password = "IFYchris27@101";
  
  if($_SESSION['stat']=='Completed')
  {
  $message = "Congrat!,Your Stall Digitalisation Excercise is succesful. your Unique Logins: ID: $regno.";
  }
  else
  {
  $message = "Your Stall Digitalisation Excercise is Pending. your Unique Logins: ID: $regno.";
  }
  $sender_name = "Ansmaportal";
  $recipients = "$phone";
  $forcednd = 1;

  $data = array("email" => $email, "password" => $password,"message"=>$message, "sender_name"=>$sender_name,"recipients"=>$recipients,"forcednd"=>$forcednd);
  $data_string = json_encode($data);
  $ch = curl_init('https://app.multitexter.com/v2/app/sms');
  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
  curl_setopt($ch, CURLOPT_POSTFIELDS, $data_string);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json','Content-Length: ' . strlen($data_string)));
  $result = curl_exec($ch);
  $res_array = json_decode($result);
  //print_r($res_array);
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
 <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>Print Documents</title>
<link rel="stylesheet" type="text/css" href="css/print.css">
<link rel="stylesheet" type="text/css" href="css/bootstrap/css/bootstrap.css"> 

<script type="text/javascript">
<!--
function printContent(id){
str=document.getElementById(id).innerHTML
newwin=window.open('','printwin','left=20,top=20,width= 900,height=2000')
newwin.document.write('<HTML>\n<HEAD>\n')
newwin.document.write('<TITLE>Anambra Market Digitalisation</TITLE>\n')
newwin.document.write('<script>\n')
newwin.document.write('function chkstate(){\n')
newwin.document.write('if(document.readyState=="complete"){\n')
newwin.document.write('window.close()\n')
newwin.document.write('}\n')
newwin.document.write('else{\n')
newwin.document.write('setTimeout("chkstate()",2000)\n')
newwin.document.write('}\n')
newwin.document.write('}\n')
newwin.document.write('function print_win(){\n')
newwin.document.write('window.print();\n')
newwin.document.write('chkstate();\n')
newwin.document.write('}\n')
newwin.document.write('<\/script>\n')
newwin.document.write('</HEAD>\n')
newwin.document.write('<BODY onload="print_win()">\n')
newwin.document.write(str)
newwin.document.write('</BODY>\n')
newwin.document.write('</HTML>\n')
newwin.document.close()
}
//-->
</script>
 
</head>

<body>
<div class="main-page">
<div class="sub-page">
<div id="printTable" class="bd" >
<form action="" method="post" name="form" >
<center>
<img src="images/printhd.png" width="600" />
</center>
<table width="100%" border="0" class="table" style="background-image:url(images/catax.png); background-position:center; background-repeat:no-repeat;">
  <tbody>
    <tr>
      <td><strong>MARKET NAME</strong></td>
      <td colspan="2"><?php if(isset($mname)) echo $mname ; ?></td>
      <td rowspan="2" align="center"><img src="documents/<?php echo $image ; ?>" width="100" height="100" /></td>
    </tr>
    <tr>
      <td><strong>ALLOTEE REGISTRATION NO</strong></td>
      <td><?php if(isset($regno)) echo $regno ; ?></td>
      <td>&nbsp;</td>
      </tr>
    <tr>
      <td><strong>Allotee Names</strong></td>
      <td colspan="3"><?php if(isset($custodian)) echo $custodian ; ?></td>
      </tr>
    <tr>
      <td><strong>Identity Means</strong></td>
      <td><?php if(isset($mid)) echo $mid ; ?></td>
      <td><strong>ID No</strong></td>
      <td><?php if(isset($idno)) echo $idno ; ?></td>
    </tr>
    <tr>
      <td><strong>Form/En No</strong></td>
      <td><?php if(isset($fmen)) echo $fmen; ?></td>
      <td><strong>Phone  No</strong></td>
      <td><?php if(isset($phone)) echo $phone ; ?></td>
    </tr>
    <tr>
    <td colspan="4"><strong>Ansid No</strong> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; <?php if(isset($ansid)) echo $ansid ; ?></td>
      </tr>
    <tr>
      <td><strong>Nationality</strong></td>
      <td><?php if(isset($nation)) echo $nation ; ?></td>
      <td><strong>State Origin</strong></td>
      <td><?php if(isset($astate)) echo $astate ; ?></td>
    </tr>
    <tr>
      <td><strong>L.G.A</strong></td>
      <td><?php if(isset($lga)) echo $lga ; ?></td>
      <td><strong>Office Address</strong></td>
      <td><?php if(isset($office)) echo $office ; ?></td>
    </tr>
   
    <tr>
      <td colspan="4"><strong>STALL DETAILS:</strong></td>
      </tr>
    <tr>
      <td><strong>Market Section</strong></td>
      <td><?php if(isset($msection)) echo $msection ; ?></td>
      <td><strong>L.G.A</strong></td>
      <td><?php if(isset($mlga)) echo $mlga ; ?></td>
    </tr>
    <tr>
      <td><strong>Zone</strong></td>
      <td><?php if(isset($zone)) echo $zone ; ?></td>
      <td><strong>Line No</strong></td>
      <td><?php if(isset($lineno)) echo $lineno ; ?></td>
    </tr>
    <tr>
      <td><strong>Stall No</strong></td>
      <td><?php if(isset($stallno)) echo $stallno ; ?></td>
      <td><strong>Stall Type</strong></td>
      <td><?php if(isset($stype)) echo $stype ; ?></td>
    </tr>
    <tr>
      <td><strong>Allocation Certificate No</strong></td>
      <td><?php if(isset($certno)) echo $certno ; ?></td>
      <td><strong>Basis of Occupation</strong></td>
      <td><?php if(isset($basis)) echo $basis ; ?></td>
    </tr>
    <tr>
      <td colspan="4"><strong>NEXT OF KIN DATA</strong></td>
      </tr>
    <tr>
      <td><strong>Names</strong></td>
      <td colspan="3"><?php if(isset($nkn)) echo $nkn ; ?></td>
      </tr>
    <tr>
      <td><strong>Phone No</strong></td>
      <td><?php if(isset($nphone)) echo $nphone ; ?></td>
      <td><strong>RelationShip</strong></td>
      <td><?php if(isset($relation)) echo $relation ; ?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td colspan="4"><strong>Note : </strong>
        <p>You can use this<strong> Registration No</strong> :<strong> (<?php if(isset($regno)) echo $regno ; ?>) </strong> to login to your Personal profile on the site or the app, to perform   necessary action. <br/> 
        Thanks Prepared by (<?php if(isset($adm)) echo $adm; ?>)  	  </p></td>
      </tr>
    
  </tbody>
</table>


</form>
      
</div>
<div align="center">
<a href="#null" onclick="printContent('printTable')" class="btn btn-danger">Click to Print Sample</a>||||
<?php

if(isset($_GET['reg']))
{
?>
<a href="viewstalls" class="btn btn-success">Go Back</a><br />
<?php
}
else
{
	?>
    <a href="comp.php" class="btn btn-primary">Complete Operation</a><br />
    <?php
}


?>

</div>	      
  </div>
      </div>
</body>
</html>