<?php
			ini_set('display_errors',0);

			//include 'debug.php';
			
			include 'config-mysql-php7.php';
			

    	//date_default_timezone_set("Asia/Bangkok");
			//define('RATE_DB_NAME', 'rate_uploader');

			/** MySQL database username */
			//define('RATE_DB_USER', 'root');

			/** MySQL database password */
			//define('RATE_DB_PASSWORD', 'veok0w,h');

			/** MySQL hostname */

			//define('RATE_DB_HOST', 'localhost');    	
			//$conn = mysql_connect( RATE_DB_HOST , RATE_DB_USER , RATE_DB_PASSWORD);
			//$conn = mysqli_connect( RATE_DB_HOST , RATE_DB_USER , RATE_DB_PASSWORD);
			
			//if (!$conn) {
    	//			die('Could not connect: ' . mysqli_error());
			//} else {
	 		//		mysqli_select_db($conn , RATE_DB_NAME); 
	 		//		mysqli_query($conn , "SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
	 				//mysqli_query($conn,"SET NAMES 'tis620' COLLATE 'tis620_thai_ci';");
	 				//mysqli_query($conn,"SET NAMES 'latin1' COLLATE 'latin1_swedish_ci';");
			//}
			
		
		$country_id = trim($_POST [ 'country_id' ]);
		$weight   = trim($_POST [ 'weight' ]);
		//settype ($weight,'Integer');
		$w  = trim($_POST [ 'w' ]);
		settype ($w,'Integer');
		$l  = trim($_POST [ 'l' ]);
		settype ($l,'Integer');
		$h	= trim($_POST [ 'h' ]);
		settype ($h,'Integer');
		
		
		/*
		$country_id  = 'AF';
		$weight			= 500;
		$w=0;
		$l=0;
		$h=0;
		*/
		
		//$dimension = ($w * $l * $h) / 5000 / 1000;
		$dimension = ($w * $l * $h) / 5000;

		$dimension = number_format($dimension, 2, '.', '');
		
		//$new_weight = number_format( ( $weight / 1000 ), 2, '.', ''); // To Kg
		
		SaveLog2('ddd.txt','new_weight 1 : '.$weight );
		
		$new_weight = number_format( ( $weight ), 3, '.', ''); // To Kg
		
		
		//SaveLog2('ddd.txt','dimension : '.$dimension );
		//SaveLog2('ddd.txt','new_weight : '.$new_weight );
		
		/************ doFloat ***********/
		/* Split xxx.yyy to xxx and yyy */
		/********************************/
		
		//$value 	= 100001.529901;
		//$value 	= 12.99;
		
		if ($dimension > $new_weight ) {
			$value 	= $dimension;
		} else {
			$value 	= $new_weight;
		}
		
		
		//SaveLog2('ddd.txt','value : '.$value );
		//$lvalue = number_format($value, 2, '.', '');	// 100g
		$lvalue = number_format($value, 3, '.', '');	// 10g
		$actual_weight = $lvalue;
		
		//SaveLog2('ddd.txt','lvaluex : '.$lvalue );

		// Step 10 G

		if ( ($lvalue > 0.000) And ($lvalue <= 1.000) ) {

			$arr 	=  explode(".", ($lvalue * 100) );
			$hi 	=	$arr[0];
			settype($hi,'integer');
			$lo		= $arr[1];
			settype($lo,'integer');

			//$intdiv = 	intdiv($hi, 10);	// หาส่วน
			//$fmod	=	fmod($hi, 10);		// หาเศษ

			//SaveLog2('ddd.txt','hi a : : '.$hi );
			//SaveLog2('ddd.txt','lo a : : '.$lo );

			if ($lo == 0) {
				$hia = $hi * 0.01;
				$loa =  ($hi - 1) * 0.01 + 0.001;
				//SaveLog2('ddd.txt','AAAAAAAAAAAAAAAA');
			} else {
				$hia = ($hi + 1) * 0.01;
				$loa = $hi * 0.01 + 0.001;
				//SaveLog2('ddd.txt','BBBBBBBBBBBBBBBB');
			}

			//SaveLog2('ddd.txt','hia : '.$hia );
			//SaveLog2('ddd.txt','loa : '.$loa );

			// 0.001-0.0010

			$_fromA 	= $loa;
			$_toA		= $hia;

		}
		// *** End 10g *** //


		// Step 100 G
		/*

		if ( ($lvalue > 0.00) And ($lvalue <= 1.00) ) {

			$arr 	=  explode(".", ($lvalue * 100) );
			$hi 	=	$arr[0];
			settype($hi,'integer');
			$lo		= $arr[1];
			settype($lo,'integer');

			$intdiv = 	intdiv($hi, 10);
			$fmod	=	fmod($hi, 10);

			//SaveLog2('ddd.txt','hi a : : '.$hi );
			//SaveLog2('ddd.txt','lo a : : '.$lo );
			//SaveLog2('ddd.txt','intdiv a : : '.$intdiv );
			//SaveLog2('ddd.txt','fmod a : : '.$fmod );


			if ($fmod == 0) {
				$hia = $intdiv * 0.1;
				$loa = ( ($intdiv-1) * 0.1 ) + 0.01;
			} else {

				$hia = ($intdiv + 1) * 0.1;
				$loa = ($intdiv * 0.1 ) + 0.01;

			}
			//SaveLog2('ddd.txt','hia : '.$hia );
			//SaveLog2('ddd.txt','loa : '.$loa );

			// 0.01-0.90

			$_fromA 	= $loa;
			$_toA		= $hia;

		}

		*/

		// *** End 100g ***

		
		if ( ($lvalue > 0.000) And ($lvalue <= 30.000) ) {
			$arr 	=  explode(".",$lvalue);
			$hi 	=	$arr[0];
			settype($hi,'integer');
			$lo		= $arr[1];
			settype($lo,'integer');

			if ($hi==0) {

				if ( ($lo > 0) And ($lo <= 500) ) {		// 0.01-0.50
					$_from 	= 0.01;
					$_to	 	= 0.50;
				}
				elseif ($lo > 500) {		// 0.51-1.00
					$_from 	= 0.51;
					$_to	 	= 1.00;
				}
			}
			elseif ( ($hi > 0) and ($hi <=30) ) {
				
					if (($hi>0) And ($lo==0)){
						$_from 	= $hi - 0.50 + 0.01;
						$_to 		= $hi;
					}
					elseif ( ($lo > 0) And ($lo <= 500) ) {		// x.01-x.50
						$_from 	= $hi+.01;
						$_to	 	= $hi+0.50;
					}
					elseif (($lo > 500) And ($lo <= 999) ) {		// x.51-x.00
						$_from 	= $hi+.51;
						$_to	 	= $hi+1.00;
					}
					
			}
			
		}
		elseif ($lvalue > 30.00) {
			$arr 	=  explode(".",$lvalue);
			$hi 	=	$arr[0];
			$lo		= $arr[1];
			
			settype($hi,'integer');
			$lo		= $arr[1];
			settype($lo,'integer');
			
			if (($hi>0) And ($lo==0))	{	// 30.01-31.00
				$_from 	= $hi - 1 + 0.01;
				$_to 		= $hi;
			}
			elseif ( ($lo > 0) And ($lo <= 999) ) {		// x.01-x.99
				$_from 	= $hi + 0.01;
				$_to 		= $hi + 1.00;
			}
			
			
		}
		elseif ($lvalue <= 0.00) {
			$_from 	= 0;
			$_to 	= 0;
		}
		

		/*

		SaveLog2('ddd.txt','value : '.$lvalue );
		SaveLog2('ddd.txt','hi : '.$hi );
		SaveLog2('ddd.txt','lo : '.$lo );
		
		SaveLog2('ddd.txt','from : '.$_from );
		SaveLog2('ddd.txt','to   : '.$_to );
		

		SaveLog2('ddd.txt',$arr_lvalue[0] );
		SaveLog2('ddd.txt',$arr_lvalue[1] );
		SaveLog2('ddd.txt','-----------------------------');
		
		*/

		
		//100001.53
		
		/************ End Float *********/

		$query_zone_id = ' SELECT c.* , zc.`zone_id` FROM `countries` c , `zone_countries` zc ';
		$query_zone_id.= ' WHERE c.`code` = \''.$country_id.'\' and c.`deleted_at` is null ';
		$query_zone_id.= ' AND zc.`country_id` = c.`id` ';
		
		SaveLog2('ddd.txt',$query_zone_id );
		
		$result  = mysqli_query ($conn,$query_zone_id);
		if (mysqli_num_rows($result) > 0) {
			$q_zone = '';
			$country_name = '';
			while ( $row_zone_id = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
				$zone_id = $row_zone_id ['zone_id' ];
				$country_name = $row_zone_id ['name' ];
				if ($q_zone == '') {
					$q_zone = ' sr.`zone_id` = '.$zone_id;
				} else {
					$q_zone .= ' OR sr.`zone_id` = '.$zone_id;
				}

			}
			//SaveLog2('ddd.txt',$q_zone );
			//SaveLog2('ddd.txt',$country_name );

			if ( ($lvalue > 0.00) And ($lvalue <= 1.00) ) {

					// Price 100 G Step
					$query_priceA = ' SELECT sr.* , c.`name` , c.`logo_file` , s.`code` as service_code , s.`name` as service_name , s.`name_eng` FROM `service_rates` sr , `companies` c , `services` s  WHERE sr.`min_weight` =  '.$_fromA.'  AND sr.`max_weight` = '.$_toA;
					if ($q_zone <> '') {
						$query_priceA .= ' AND ('.$q_zone.')';
					}
					$query_priceA .= ' AND sr.`company_id` = c.`id` ';
					$query_priceA .= ' AND sr.`service_id` = s.`id` ';
					$query_priceA .= ' Order By sr.`price` ';			
					SaveLog2('ddd.txt','query_priceA : '.$query_priceA);

					$result_priceA  = mysqli_query ($conn,$query_priceA);
					if (mysqli_num_rows($result_priceA) > 0) {
						while ( $row_price = mysqli_fetch_array($result_priceA,MYSQLI_ASSOC)) {

							$company_id = $row_price [ 'company_id' ];
							$zone_id		= $row_price [ 'zone_id' ];
							$service_id	= $row_price [ 'service_id' ];
							$min_weight	=	$row_price [ 'min_weight' ];
							$max_weight	=	$row_price [ 'max_weight' ];
							//$price	=	$row_price [ 'price' ];
							$price			=	number_format($row_price [ 'price' ], 2, '.', ',');
							
							//$discounted_price	=	$row_price [ 'discounted_price' ];
							$discounted_price	=	number_format($row_price [ 'discounted_price' ], 2, '.', ',');
							
							$company_name = $row_price [ 'name' ];
							$service_code = $row_price [ 'service_code' ];
							$service_name = $row_price [ 'service_name' ];
							$service_name_eng = $row_price [ 'name_eng' ];
							$logo_file = $row_price [ 'logo_file' ];

							$arr_price[] = array (
								company_id	=> $company_id,
								zone_id	=> $zone_id,
								service_id	=> $service_id,
								min_weight	=> $min_weight,
								max_weight	=> $max_weight,
								price	=> $price,
								discounted_price	=> $discounted_price,
								company_name	=> $company_name,
								service_code	=> $service_code,
								service_name	=> $service_name,
								service_name_eng	=> $service_name_eng,
								logo_file	=> $logo_file
							);							
	

						}
					}

			}
			// ************************* END STEP 100 *******************************

			// Price 500 G Step
			$query_price = ' SELECT sr.* , c.`name` , c.`logo_file` , s.`code` as service_code , s.`name` as service_name , s.`name_eng` FROM `service_rates` sr , `companies` c , `services` s  WHERE sr.`min_weight` =  '.$_from.'  AND sr.`max_weight` = '.$_to;
			if ($q_zone <> '') {
				$query_price .= ' AND ('.$q_zone.')';
			}
			$query_price .= ' AND sr.`company_id` = c.`id` ';
			$query_price .= ' AND sr.`service_id` = s.`id` ';
			$query_price .= ' Order By sr.`price` ';
			SaveLog2('ddd.txt','query_price : '.$query_price);

			$result_price  = mysqli_query ($conn,$query_price);
			
			if (mysqli_num_rows($result_price) > 0) {
				
				
					while ( $row_price = mysqli_fetch_array($result_price,MYSQLI_ASSOC)) {
						
						$company_id = $row_price [ 'company_id' ];
						$zone_id		= $row_price [ 'zone_id' ];
						$service_id	= $row_price [ 'service_id' ];
						$min_weight	=	$row_price [ 'min_weight' ];
						$max_weight	=	$row_price [ 'max_weight' ];
						//$price	=	$row_price [ 'price' ];
						$price			=	number_format($row_price [ 'price' ], 2, '.', ',');
						
						//$discounted_price	=	$row_price [ 'discounted_price' ];
						$discounted_price	=	number_format($row_price [ 'discounted_price' ], 2, '.', ',');
						
						$company_name = $row_price [ 'name' ];
						$service_code = $row_price [ 'service_code' ];
						$service_name = $row_price [ 'service_name' ];
						$service_name_eng = $row_price [ 'name_eng' ];
						$logo_file = $row_price [ 'logo_file' ];


						$arr_price[] = array (
							company_id	=> $company_id,
							zone_id	=> $zone_id,
							service_id	=> $service_id,
							min_weight	=> $min_weight,
							max_weight	=> $max_weight,
							price	=> $price,
							discounted_price	=> $discounted_price,
							company_name	=> $company_name,
							service_code	=> $service_code,
							service_name	=> $service_name,
							service_name_eng	=> $service_name_eng,
							logo_file	=> $logo_file
						);

					}
					
					$new_array = array (
						msg_id => 1,
						country_name => $country_name,
						actual_weight => $actual_weight,
						data => $arr_price
					);
					
					$data = json_encode($new_array);
					echo $data;
					//SaveLog2('ddd.txt',$data);
					
			} else {
				$new_array = array (
						msg_id	=> -1,
						country_name => "",	
						actual_weight => 0.00,
						data => ""
				);
				$data = json_encode($new_array);
				echo $data;
				//SaveLog2('ddd.txt',$data);
			}
		}
?>