
<?php

date_default_timezone_set("America/Panama");
//$connection = new mysqli("db1.solucionesatc.com", "remoto", "1234") or die(mysqli_error());

if (isset($_SERVER['HTTP_ORIGIN'])) {
        header("Access-Control-Allow-Origin: {$_SERVER['HTTP_ORIGIN']}");
        header('Access-Control-Allow-Credentials: true');
        header('Access-Control-Max-Age: 86400');    // cache for 1 day
    }

//$link = mssql_connect('192.168.1.30', 'sa', 'sap123');
$link = mssql_connect('10.0.0.50', 'sa', 'sap123');
$_SESSION['itemcode'] = $_GET['itemcode'];

$_SESSION['itemcode1'] ="";
 
if (!$link)
    die('Unable to connect!');
 
if (!mssql_select_db('sbo_calzashoes_inc', $link))
    die('Unable to select database!');
    
    

  
 
$result = mssql_query("select  itemcode,onhand, CASE 
 WHEN whscode='01' THEN 1
      WHEN whscode='02' THEN 2
      WHEN whscode='03' THEN 3 
       WHEN whscode='04' THEN 4 
  WHEN whscode='05' THEN 5
   WHEN whscode='06' THEN 6
    WHEN whscode='07' THEN 7
     WHEN whscode='08' THEN 8
      WHEN whscode='09' THEN 9
   END as dep
	
	 from oitw where onhand>0 and whscode in ('01','02','03','04','05','06','07','08','09') ");



 $jsonData      = array();
    $jsonTempData  = array();

$total=0; 
while ($r= mssql_fetch_array($result)) {
    
 

  $jsonTempData = array();
          $jsonTempData['itemcode']         = utf8_encode($r['itemcode']);
          
          $jsonTempData['dep']         = $r['dep'];
              $jsonTempData['onhand']         = $r['onhand'];
    
    
          $jsonData[] = $jsonTempData;

$i=$i+1;
};

 	$json->registros     =$i;
 	
 		$json->item     =  $jsonData;
 		
 	echo json_encode( $json);
 	
 	$url1="https://rctechsoftware.com/rest/171_calzashoes/v65/phpsqlserver/existencia.php";
 	
 	//$url1="http://200.115.145.197:3390/rest/171_calzashoes/v65/phpsqlserver/existencia.php";


$json9 = '{"registros":1,"item":[{"itemcode":"101","dep":"1","onhand":"6"}]}';

/*
$parametros_post = 'datos='.json_encode($json);

    $ch = curl_init($url1);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
   curl_setopt ($ch, CURLOPT_POSTFIELDS, $parametros_post); 
   curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
   $result = curl_exec($ch);
    curl_close($ch);


echo   $result;
$data = json_decode($result,TRUE);
*/

$data = json_decode($json,TRUE);




// header('content-type: application/json');
//echo json_encode($return_arr);
//echo $json;
@mysqli_close($connection);
mssql_free_result($result);
 
?>
