<?php
/**
	* 
	* Start 
	* Create Date: 17 Jun, 2016
	* This module file using for commmonly used method in all controller.
	* Created saravana kumar.
	* @see no link
	* Last Updated: 23 Jun, 2016
	* End
	* 
*/
	namespace App\Models;
	use CodeIgniter\Model;
	use Binance;
	use Lin\Okex\OkexV5;
    use Lin\Ftx\Ftx;
	// $api = new Binance\API($key,$secret,true);
	Class Strategythird extends Model {

		public function __construct(){
			$this->db = \Config\Database::connect();
			$this->common_model = model('CommonModel');
		}

		public function index()
		{
			
		}


		public function third_strategy(){

			$third_strategy_users = $this->db->table('trade_process')->select('uusersid')->where('strategy_mode','3')->distinct()->where('trade_status','1')->get()->getResult();
			
		
            $userid = array();
			if ($third_strategy_users) {
				
				$i=0;
				foreach ($third_strategy_users as $key => $value) {
					$userid[$i] = $value->uusersid;
					$i++;
				}
                $db = db_connect();
				$admin_settings = $db->table('adminsettings')->orderBy('id','DESC')->get()->getRow();
			    $fuel_fee_percent = $admin_settings->min_fuel_fee;
				if(empty($userid)) return false;
                $data_binance=getpairs(1);

				for ($i=0; $i < count($userid); $i++) 
				{ 

			    	$trade_process_array = $this->db->query("Select * from trade_process where uusersid = $userid[$i] AND trade_status = 1 AND strategy_mode = 3  order by created_time desc")->getResult();

    				for($j=0;  $j < count($trade_process_array); $j++) 
    				{
    					$trade_process = $trade_process_array[$j];
    					if($trade_process->exchange == 1)
    					{
					        $userid_bind_process = $this->db->table('bind_process')->where('uusersid',$userid[$i])->get()->getRow();
				        }
				    
				    
    				    else if($trade_process->exchange=='5')
    					{
    						$userid_bind_process = $this->db->table('bind_process')->where('uusersid',$userid[$i])->where('type','5')->get()->getRow();
    						
    						$check_sells=$this->bybit_sells($userid[$i]);
    						
    						
    				    }
				    
				        $key = $userid_bind_process->api_key;
						$secret = $userid_bind_process->secret_key;
	                if ($userid_bind_process && $trade_process && $trade_process->trade_status == '1') {
						$key = $userid_bind_process->api_key;
						$secret = $userid_bind_process->secret_key;
						if($trade_process->exchange == 2)
							$passphrase = $userid_bind_process->pass_phrase;
			        
			        if($trade_process->exchange == 1)
				    {
				        $live_price=getliveprice($trade_process->pair);
                        $live_price=number_format($live_price,9);
                        $live_price=str_replace(',','',$live_price);
					    $previous_high_price=candleprice($key,$secret,$trade_process->pair);
					}
					else if($trade_process->exchange ==5)
					{
					    $account = $userid_bind_process->account;
                	    $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
                	   $bybitApi = new BybitApi($key, $secret);
                	   $tickers = $bybitApi->ticker(['category' => 'spot', 'symbol' => $trade_process->pair]); 
                       $live_price = $tickers['lastPrice'];
					    
					}
					
					$trade_where = array(
						'uuserid' => $userid[$i],
						'type !=' => '3',
						'trade_process_id' => $trade_process->id,
					);

					$last_buy = $this->db->table('api_trade_history')->where($trade_where)->orderBy('id','DESC')->get()->getRow();

					$last_buy_live_price = $last_buy->live_price;
				
					
					// $live_price = '398';
					print_r("last buy ".$last_buy_live_price);
					echo "<br>";
					print_r("current live ".$live_price);
					// exit();

					if ($last_buy_live_price > $live_price) 
					{

								// normal margin call drop buy function
               if($last_buy->type == 1)  {  
                    $trade_where_new = array(
						'uuserid' => $userid[$i],
						'type' => '1',
						'status' => 0,
						'trade_process_id' => $trade_process->id,
					);


      $last_buy_recheck = $this->db->table('api_trade_history')->where($trade_where_new)->orderBy('margin_call_drops','DESC')->get()->getRow();
       $last_margin_call_drop = $last_buy_recheck->margin_call_drops;
       if($last_margin_call_drop == 0){
       	 $number_of_margincall = 1;
       }else{
       	$number_of_margincall = $last_margin_call_drop;
       }


		$margin_call_drop = $trade_process->margincall_drop;
		$explode_margin_call_drop = explode(',', $margin_call_drop);
		$exploded = array_combine(range(1, count($explode_margin_call_drop)), $explode_margin_call_drop);
		$old_price = '';

		echo"<pre>";
		print_r($exploded);
		echo"</pre>";
					
         
						for ($k=1; $k<=count($exploded); $k++) {

					        $last_buy = $this->db->table('api_trade_history')->where($trade_where)->orderBy('id','DESC')->get()->getRow();
							if ($old_price == '') {
								$old_price = $last_buy->live_price;
							}

							$call_drop_where = array(
								'trade_process_id' => $trade_process->id,
								'uuserid' => $userid[$i],
								'margin_call_drops' => $k,
								'type' => 1,
								'status' => 0
							);

							$call_drop_where1 = array(
								'trade_process_id' => $trade_process->id,
								'uuserid' => $userid[$i],
								'type' => 2,
								'margin_call_drops' => $k,
								'status' => 0
							);


							$call_drop = $this->db->table('api_trade_history')->where($call_drop_where)->get()->getRow();
						
							

							if($k > 5){
								if($call_drop != ""){
                                      $call_drop_new = $this->db->table('api_trade_history')->where($call_drop_where1)->get()->getRow();
                                      if($call_drop_new){
                                      	$call_drop = "";
                                      }else{
                                      	$call_drop = true;
                                      }
                                     
                            echo"<pre>";
							echo "second<br>";
							print_r($k." ".$call_drop);
							echo"</pre>";
								}
							}
							
							
                 			if (!$call_drop) {
								$check_percentage = ($old_price - $live_price) / $old_price * 100;
								echo"<pre>";
								print_r("Old price".$old_price);
								print_r("Current Down".$check_percentage);
								print_r("Next call percentage".$k." :".$exploded[$k]);
								echo"</pre>";

								if ($check_percentage >= $exploded[$k]) 
								{

									$explode_buyin_ratio_times = explode(',', $trade_process->buyin_ratio_times);
									$exploded_buy_ratio = array_combine(range(1, count($explode_buyin_ratio_times)), $explode_buyin_ratio_times);

									if($trade_process->open_position_doubled != 'on' || $trade_process->open_position_doubled == '')
										$quantity = 1;
									else
										$quantity = 2;
									
									if($exploded_buy_ratio[$k] > 0)
									{
									    
									    $price = $trade_process->first_buy_amount;
                                        $quantity = $price * $exploded_buy_ratio[$k];
									}
                                    else
                                    {
                                        $price = $trade_process->first_buy_amount * $quantity;
                                        $quantity=$price;
                                    }
                                    if($trade_process->exchange == 1) 
                                    { 
								        $total_asset='0';
									    $balances=binance_balance($key,$secret);
                                        if($balances)
                                        {
                                            $total_asset=$balances;
                                        }
								    }
								    
								    else if($trade_process->exchange=='5')
    							    {
    							        $send_pair=substr($trade->pair,0,-4);
    							        $account = $userid_bind_process->account;
                                	    $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
                                	    $bybitApi = new BybitApi($key, $secret);
                                	    $total_asset = $bybitApi->getBalance('USDT',$acc_type);
                                	}
								   
									if ($trade_process->margin_call == '1' && $total_asset > $quantity) 
									{
							
									    $buy_done = $this->marketbuy($userid[$i],$trade_process->id,$quantity,$k,$api,$trade_process->pair);
										$call_drop_where1 = array(
										'trade_process_id' => $trade_process->id,
										'uuserid' => $userid[$i],
										// 'margin_call_drops' => $k
										);
								
								        $call_drop = $this->db->table('api_trade_history')->where($call_drop_where1)->orderBy('id','DESC')->get()->getRow();
								        $old_price = $call_drop->live_price;
					                }
					                 else
    								{
    								    	$message="Margin call stopped on order execution..";
    										$this->notify($userid[$i],$trade_process->id,$message);
    								}
								}
                            break;
							}else{

								$call_drop_where1 = array(
									'trade_process_id' => $trade_process->id,
									'uuserid' => $userid[$i],
									// 'margin_call_drops' => $k
								);
								
								$call_drop = $this->db->table('api_trade_history')->where($call_drop_where1)->orderBy('id','DESC')->get()->getRow();

								$old_price = $call_drop->live_price;
							}
						if($buy_done)
						break;
						}

					}
				    else if($last_buy->type == 2 && $last_buy->description != 'manual_sell')
				    {
				

						if($trade_process->open_position_doubled != 'on' || $trade_process->open_position_doubled == ''){
								$quantity = 1;
						}
						else
						{
								$quantity = 2;
						}
						
				                //$quantity=1;
								$price = $trade_process->first_buy_amount * $quantity;
								$quantity = $price ;

								echo"<pre>";
								print_r($exploded_buy_ratio[$k]);
								echo "\n";
								print_r($quantity);
								echo "\n";
								print_r($trade_process->margin_call);
								echo"</pre>";
								// exit();
								if($trade_process->exchange == 1) 
								{ 
    								$total_asset='0';
									  $balances=binance_balance($key,$secret);
                                      if($balances)
                                      {
                                            $total_asset=$balances;
                                      }
								}
								
								else if($trade_process->exchange=='5')
							    {
							        $send_pair=substr($trade->pair,0,-4);
							        $account = $userid_bind_process->account;
                            	    $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
                            	    $bybitApi = new BybitApi($key, $secret);
                            	    $total_asset = $bybitApi->getBalance('USDT',$acc_type);
                            	    
							    }
							
								    $k = "";
								    $description='';
									$total_asset = str_replace(",",'',$total_asset);

    								if($total_asset >= $quantity)
    								{
    									$gas_balance = gas_wallet_bal($userid[$i]);
    									if($gas_balance>=$min_gas_required)
    									{
    										$buy_result = $this->marketbuy($userid[$i],$trade_process->id,$quantity,$k,$api,$trade_process->pair,$description);
    									}
    									else
    									{
    										$message="Gas wallet fuel insufficent for order buy";
    									
    										$this->notify1($userid[$i],$trade_process->id,$message);
    									}
    								}
    								else
    								{
    								    $api_trade_data_update = array('trade_log' => '3','trade_status' => '0');
								        $this->db->table('trade_process')->set($api_trade_datas)->where("id",$trade_process->id)->update();
                                        $message="Insufficent USDT Balance low on quantity buy for quantity:".$quantity."asset only balance for".$total_asset;
                                        
    								    //$message="Binance API Balance Retrive Down for maintance..revert back shortly";
    									$this->notify($userid[$i],$trade_process->id,$message);
    								}
								
										$call_drop_where1 = array(
										'trade_process_id' => $trade_process->id,
										'uuserid' => $userid[$i],
										// 'margin_call_drops' => $k
										);
								
								$call_drop = $this->db->table('api_trade_history')->where($call_drop_where1)->orderBy('id','DESC')->get()->getRow();

								$old_price = $call_drop->live_price;
								
					            // }
                 //  	}
				}
					}

					else{


					if($last_buy->type == 2 && $last_buy->description != 'manual_sell')
					{  //after take profit call market up buyincallback call
		        
						if($trade_process->open_position_doubled != 'on' || $trade_process->open_position_doubled == '')
								$quantity = 1;
						else
								$quantity = 2;
								
								//$quantity='1';
								$price = $trade_process->first_buy_amount * $quantity;
								$quantity = $price ;

								echo"<pre>";
								print_r($exploded_buy_ratio[$k]);
								echo "\n";
								print_r($quantity);
								echo "\n";
								print_r($trade_process->margin_call);
								echo"</pre>";
								// exit();

								if($trade_process->exchange == 1)
								{ 
								    $total_asset='0';
								    $balances=binance_balance($key,$secret);
                                    if($balances)
                                    {
                                        $total_asset=$balances;
                                    }
								    
								}
								else if($trade_process->exchange=='5')
							    {
							        $send_pair=substr($trade->pair,0,-4);
							        $account = $userid_bind_process->account;
                            	    $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
                            	    $bybitApi = new BybitApi($key, $secret);
                            	    $total_asset = $bybitApi->getBalance('USDT',$acc_type);
                            	}

								echo"<pre>";
								print_r("profit buy");
								echo"</pre>";

								$k = "";
								

									$total_asset = str_replace(",",'',$total_asset);
								$k = "";
								$description = "";
								if($total_asset >= $quantity)
								{

									$gas_balance = gas_wallet_bal($userid[$i]);
									if($gas_balance>=$min_gas_required)
									{
										$buy_result = $this->marketbuy($userid[$i],$trade_process->id,$quantity,$k,$api,$trade_process->pair,$description);
									}
									else
									{
										$message="Gas wallet fuel insufficent for order buy";
									    //$message="Binance API Balance Retrive Down for maintance..revert back shortly";
										$this->notify1($userid[$i],$trade_process->id,$message);
									}
								}
								else 
								{
									//$message="Insufficent USDT Balance low on quantity buy";
									//$message="Binance API Balance Retrive Down for maintance..revert back shortly";
									$api_trade_data_update = array('trade_log' => '3','trade_status' => '0');
							        $this->db->table('trade_process')->set($api_trade_datas)->where("id",$trade_process->id)->update();
                                    $message="Insufficent USDT Balance low on quantity buy for quantity:".$quantity."asset only balance for".$total_asset;
										
									$this->notify($userid[$i],$trade_process->id,$message);
								}
								
								
										$call_drop_where1 = array(
										'trade_process_id' => $trade_process->id,
										'uuserid' => $userid[$i],
										// 'margin_call_drops' => $k
										);
								
								$call_drop = $this->db->table('api_trade_history')->where($call_drop_where1)->orderBy('id','DESC')->get()->getRow();

								$old_price = $call_drop->live_price;
								
								
					            // }

				}
						else { 

						$trade_where = array(
							'uuserid' => $userid[$i],
							'type' => '1',
							'trade_close' => 0,
							'trade_process_id ' => $trade_process->id,
							'margin_call_drops >= ' => '5'
						);

						$explode = explode(',', $trade_process->sub_position);


						$buy_records = $this->db->table('api_trade_history')->where($trade_where)->orderBy('id','DESC')->get()->getResult();

						$explode = array_reverse($explode);
						$m=0;
						foreach ($buy_records as $key => $value) {
						     $buy_records[$m] = $value;
						     $count1 = $value->margin_call_drops;
						     $count = $trade_process->margin_column_limit - $count1;
						     $buy_records[$m]->exploded = $explode[$count];
						     $m++;
						}

						echo"<pre>";
						print_r("sub position pending");
						print_r("<br>");
						print_r($buy_records);
						echo"</pre>";
                     // Subbin split (Margin call > 5)
                        if($buy_records) { 
						$l = 0;
						foreach ($buy_records as $key => $value) {
							
							if ($value->live_price > 0) {
								
								$avg_price = $value->live_price * $value->exploded / 100;

								$max_increase_price = $value->live_price + $avg_price ;

								$max_increase_price = round($max_increase_price,8);
								$max_increase_price = sprintf('%.8f', floatval($max_increase_price));

								$max_down_percentage = $max_increase_price * $trade_process->sub_position_callback / 100;

								$max_down_price = $max_increase_price - $max_down_percentage;

								$max_down_price = round($max_down_price,8);
								$max_down_price = sprintf('%.8f', floatval($max_down_price));

								// $avg_price = $live_price - $value->live_price;

								$avg_price = $value->quantity;

                      
                                $trade = $this->db->table('trade_process')->where("id",$trade_process->id)->get()->getRow();

                                echo"<pre>";
                                print_r("Sub position buyed live price".$value->live_price);
                                print_r("Max INcrease".$max_increase_price);
                                echo"</pre>";

                            
                            if ($live_price >= $max_increase_price && $trade->flag != 1) {
                            	$sell_record_update = $this->db->table('trade_process')->set('flag','1')->where("id",$trade_process->id)->update();
                            	$sell_record_update1 = $this->db->table('trade_process')->set('sell_limit',$max_increase_price)->where("id",$trade_process->id)->update();
                            } 
                        $trade = $this->db->table('trade_process')->where("id",$trade_process->id)->get()->getRow();


                        echo"<pre>";
                        print_r($trade);
                        echo"</pre>";

                      
                     

							if ($trade->flag == 1) {

								$trade_where = array(
									'uuserid' => $userid[$i],
									'type' => '1',
									'status' => 0,
									'trade_process_id' => $trade_process->id,
								);


		                        $buyed_quantity = $this->db->table('api_trade_history')->selectSum('received_amount')->where($trade_where)->orderBy('id','DESC')->get()->getRow();

								
								
								$quantity = number_format($value->received_amount,8);
								$price = $max_increase_price; // Try to sell it for 0.5 btc
								$stopPrice = $trade->sell_limit; // Sell immediately if price goes below 0.4 btc
								// $quantity = 0.07;

								echo"<pre>";
								print_r("MAX ".$max_increase_price);
								print_r("LIVE PRICE ".$live_price);
								print_r("MAX DOWN  ".$max_down_price);
								echo"</pre>";
								// exit();

								if($trade_process->exchange == 1) 
								{ 
    								$send_pair=substr($trade->pair,0,-4);
									$total_asset='0';
									$balances=binance_balance1($key,$secret,$send_pair);
                                    if($balances)
                                    {
                                        $total_asset=$balances;
                                    }
								}
								else if($trade_process->exchange=='5')
							    {
							        $send_pair=substr($trade->pair,0,-4);
							        $account = $userid_bind_process->account;
                            	    $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
                            	    $bybitApi = new BybitApi($key, $secret);
                            	    $total_asset = $bybitApi->getBalance($send_pair,$acc_type);
                            	    
							        
							    }
							

							    $k = $value->margin_call_drops;
                               $quantity = str_replace(',', '', $quantity);

								$total_asset = str_replace(",",'',$total_asset);
								if($total_asset < $quantity)
								{
									if($trade_process->pair == "BNBUSDT")
										$quantity_fee = $total_asset * ( 0.65 / 100 );
									else
										$quantity_fee = $total_asset * ( 0.1 / 100 );
										
										$quantity_fee=number_format($quantity_fee,8);
										
										
										$quantity_los = $total_asset - $quantity_fee;
										
									
									
									} 

								if($total_asset < $quantity){
									$quantity = $total_asset;
								}
						       
								
									if($trade->sell_limit == $live_price){
									if(!empty($quantity) )
									$result1 = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$avg_price,1,$k);
									else
									$result = 0;
									} else if($live_price > $value->live_price && $trade->sell_limit <= $live_price){
									if(!empty($quantity) )
									$result1 = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$avg_price,1,$k);
									else
									$result = 0;
									} else if(!empty($trade_process->oneshot_limit) && $trade_process->oneshot_limit != 0){   // one shot hit new feature
                                    if($trade_process->oneshot_limit >= $live_price){
									if(!empty($quantity) && $total_asset >= $quantity)
								           $result_oneshothit = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$avg_price,1);
								    else
								    	$result_oneshothit = 0;

								   if($result_oneshothit){
								    	$buy_record_update = $this->db->table('api_trade_history')->set('status','1')->where($trade_where)->update();
								      $this->db->table('trade_process')->set('trade_status','2')->where('id',$trade_process->id)->update();
								      break;
								    }
								}
                        }else{

                        	if($live_price > $trade_process->sell_limit && $previous_high_price > $live_price){
                                 if(!empty($quantity) && $total_asset >= $quantity)
								           $result1 = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$avg_price,1,$k);
								    else
								    	$result = 0;
                        	}

                        }
                        if($result1)
                        $buy_record_update = $this->db->table('api_trade_history')->set('status','1')->where('id',$value->id)->update();
									// $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$stopPrice,$api,$trade_process->pair,$avg_price);
						if($result){
							
									$buy_record_update = $this->db->table('api_trade_history')->set('status','1')->where('id',$value->id)->update();

									$margin_call_drop = $trade_process->margincall_drop;

									$explode_margin_call_drop = explode(',', $margin_call_drop);
									$exploded = array_combine(range(1, count($explode_margin_call_drop)), $explode_margin_call_drop);

									$last_call_drop = array_key_last($exploded);

									$call_drop_where = array(
										'trade_process_id' => $trade_process->id,
										'uuserid' => $userid[$i],
										'margin_call_drops' => $last_call_drop
									);

									$call_drop_check = $this->db->table('api_trade_history')->where($call_drop_where)->get()->getRow();

									// if ($call_drop_check != '') {
									// 	$this->db->table('trade_process')->set('trade_status','2')->where('id',$trade_process->id)->update();	
									// }
									}
								}

							}

							$l++;

						}
					}else{
						// Full warehouse part split (Margin call 1 to 4)
						$margins = ['NULL','1','2','3','4'];
						
						$trade_where = array(
							'uuserid' => $userid[$i],
							'type' => '1',
							'status' => 0,
							'trade_process_id' => $trade_process->id,
							'margin_call_drops <=' => 4 
						);

						$buy_records1 = $this->db->table('api_trade_history')->selectSum('quantity')->where($trade_where)->orderBy('id','DESC')->get()->getRow();
						$buy_records2 = $this->db->table('api_trade_history')->selectSum('received_amount')->where($trade_where)->orderBy('id','DESC')->get()->getRow();

							    $trade_where2 = array(
									'trade_process_id' => $trade_process->id,
									'uuserid' => $userid[$i],
									'type' => '2',
									'description' => 'manual_sell',
									'status' => 0
								);

				

		$total_sell_amount = $this->db->table('api_trade_history')->selectSum('received_amount')->where($trade_where2)->get()->getRow();
		if($total_sell_amount->received_amount == "")
			$total_sell_amount->received_amount = 0;

		$total_position_amount = $buy_records2->received_amount - $total_sell_amount->received_amount;

                       

						if(!empty($buy_records1->quantity) && !empty($buy_records2->received_amount)){
						    $buy_records = $buy_records1->quantity / $buy_records2->received_amount;
                        }
					    else
					    	$buy_records = 0;

						if ($buy_records > 0  && $buy_records != '') {

							$avg_price = $buy_records * $trade_process->whole_profit_ratio / 100;
					

							$max_increase_price = $buy_records + $avg_price ;

							$max_increase_price = round($max_increase_price,8);

							$max_down_percentage = $max_increase_price * $trade_process->whole_profit_callback / 100;

							$max_down_price = $max_increase_price - $max_down_percentage;

							$max_down_price = round($max_down_price,8);

							$max_increase_price = sprintf('%.8f', floatval($max_increase_price));

                            $max_down_price = sprintf('%.8f', floatval($max_down_price));

								echo"<pre>";
								print_r("MAX UP".$max_increase_price);
								print_r("MAX DOWN  ".$max_down_price);
								echo"</pre>";
                            
                         $trade = $this->db->table('trade_process')->where("id",$trade_process->id)->get()->getRow();

                            
                            if ($live_price >= $max_increase_price && $trade->flag != 1) {
                            	$sell_record_update = $this->db->table('trade_process')->set('flag','1')->where("id",$trade_process->id)->update();
                            	$sell_record_update1 = $this->db->table('trade_process')->set('sell_limit',$max_increase_price)->where("id",$trade_process->id)->update();
                            } 

                        $trade = $this->db->table('trade_process')->where("id",$trade_process->id)->get()->getRow();


                        echo"<pre>";
                        print_r($trade);
                        echo"</pre>";

                     

							if ($trade->flag == 1) {

								$trade_where = array(
									'uuserid' => $userid[$i],
									'type' => '1',
									'status' => 0,
									'trade_process_id' => $trade_process->id,
								);


		                        $buyed_quantity = $this->db->table('api_trade_history')->selectSum('received_amount')->where($trade_where)->orderBy('id','DESC')->get()->getRow();
         
								
								
								$quantity = number_format($total_position_amount,8);
								$price = $max_increase_price; // Try to sell it for 0.5 btc
								$stopPrice = $trade->sell_limit; // Sell immediately if price goes below 0.4 btc
								// $quantity = 0.07;

								echo"<pre>";
								print_r("MAX ".$max_increase_price);
								print_r("LIVE PRICE ".$live_price);
								print_r("MAX DOWN  ".$max_down_price);
								print_r("AVG PRICE  ".$avg_price);
								echo"</pre>";
								// exit();
				            	if($trade_process->exchange == 1) 
				            	{ 
							    	/*$ticker = $api->prices(); // Make sure you have an updated ticker object for this to work
								    $balances = $api->balances($ticker);
				                    $total_asset = $balances[substr($trade->pair,0,-4)]['available'];*/
				                    
				                    $send_pair=substr($trade->pair,0,-4);
									$total_asset='0';
									$balances=binance_balance1($key,$secret,$send_pair);
                                    if($balances)
                                    {
                                        $total_asset=$balances;
                                    }
								}
								
								else if($trade_process->exchange=='5')
							    {
							        $send_pair=substr($trade->pair,0,-4);
							        $account = $userid_bind_process->account;
                            	    $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
                            	    $bybitApi = new BybitApi($key, $secret);
                            	    $total_asset = $bybitApi->getBalance($send_pair,$acc_type);
                            	    
							        
							    }
							
                                echo"<pre>";
                                print_r("Total Asset ".$total_asset);
                                print_r("Quantity ".$quantity);
                                print_r("Live Price ".$live_price);
                                print_r("Sell Limit ".$trade->sell_limit);
                                echo"</pre>";
                                if($trade_process->exchange == 1) {
                                $quantity = str_replace(',', '', $quantity);
                                if($total_asset < $quantity){
                                  if($trade_process->pair == "BNBUSDT")
                                    $quantity_fee = $quantity * ( 0.65 / 100 );
                                    else
                                    $quantity_fee = $quantity * ( 0.1 / 100 );
                                $quantity = $quantity - $quantity_fee;
                                }
                                } 

                                echo"<pre>";
                                print_r("quanitity with fee deduct ".$quantity);
                                echo"</pre>";

                                if($total_asset < $quantity){
                                	$quantity = $total_asset;
                                }
                            
                      
								
							
								
								if($trade->sell_limit == $live_price )
								{
									if(!empty($quantity))
									{
								           $result = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$buy_records1,0);
								    }
								    else
								    	$result = 0;
								} else if($live_price > $avg_price && $trade->sell_limit <= $live_price){
									if(!empty($quantity)){
                                        $result = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$buy_records1,0);
									}
                                    else
                                    	$result = 0;

                                    echo"<pre>";
                                    print_r($result);
                                    echo"</pre>";
					            } else if(!empty($trade_process->oneshot_limit) && $trade_process->oneshot_limit != 0){   // one shot hit new feature
                                    if($trade_process->oneshot_limit >= $live_price){
									if(!empty($quantity) && $total_asset >= $quantity)
								           $result_oneshothit = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$buy_records1,0);
								    else
								    	$result_oneshothit = 0;

								   if($result_oneshothit){
								    	$buy_record_update = $this->db->table('api_trade_history')->set('status','1')->where($trade_where)->update();
								      $this->db->table('trade_process')->set('trade_status','2')->where('id',$trade_process->id)->update();
								      break;
								    }
								}
                        }else{

                        	if($live_price > $trade_process->sell_limit && $previous_high_price > $live_price){
                        		    echo"<pre>";
									print_r("condition 3 ");
									echo"</pre>";
                                 if(!empty($quantity) && $total_asset >= $quantity)
								           $result = $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$live_price,$api,$trade_process->pair,$buy_records1,0);
								    else
								    	$result = 0;
                        	}

                        }
								

								// $this->take_profit($userid[$i],$trade_process->id,$quantity,$price,$stopPrice,$api,$trade_process->pair,$buy_records);

								if($result){
										$buy_record_update = $this->db->table('api_trade_history')->set('status','1')->where($trade_where)->update();

								// check one shot strategy

								if ($trade_process->strategy_type != 'Cycle Strategy') {
									
									$this->db->table('trade_process')->set('trade_status','2')->where('id',$trade_process->id)->update();
								}

								/// check last call drop 

								$margin_call_drop = $trade_process->margincall_drop;

								$explode_margin_call_drop = explode(',', $margin_call_drop);
								$exploded = array_combine(range(1, count($explode_margin_call_drop)), $explode_margin_call_drop);

								$last_call_drop = array_key_last($exploded);

								$call_drop_where = array(
									'trade_process_id' => $trade_process->id,
									'uuserid' => $userid[$i],
									'margin_call_drops' => $last_call_drop
								);

								$call_drop_check = $this->db->table('api_trade_history')->where($call_drop_where)->get()->getRow();

								if ($call_drop_check != '') {
									$this->db->table('trade_process')->set('trade_status','2')->where('id',$trade_process->id)->update();	
								}
							}

								// return true;
							}
						}
					}
					}
					}
				}
			}
		}
	}

}




// public function marketbuy($userid,$trade_process_id,$quantity,$margin_call_drops,$api,$pair){

// 		// print_r($api);
// 		// exit();

// 	$flags['isQuoteOrder'] = true;
// 				// $order = $api->buy("BNBUSDT", "10",0,"MARKET",$flags);
// 				// $order = $api->marketQuoteSell("BNBUSDT", "100",$flags);
// 	$order = $api->marketQuoteBuy($pair, $quantity,$flags);

// 	$trade_process = $this->db->table('trade_process')->where('uusersid',$userid)->where('trade_status','1')->where('id',$trade_process_id)->get()->getRow();

// 	$order_history = array(
// 		'pair' => $order['symbol'],
// 		'order_id' => $order['orderId'],
// 		'trade_process_id' => $trade_process_id,
// 		'uuserid' => $userid,
// 		'type' => '1',
// 		'quantity' => $order['cummulativeQuoteQty'],
// 		' original_quantity' => $quantity,
// 		'time' => $order['transactTime'],
// 		'received_amount' => $order['executedQty'],
// 		'live_price' => $order['fills'][0]['price'],
// 		'margin_call_drops' => $margin_call_drops,
// 		'strategy_mode' => $trade_process->strategy_mode,
// 		'status' => 0,
// 	);

// 	$this->db->table('api_trade_history')->insert($order_history);

// 	return true;
// }

	public function order_ftx($orderid,$ftx){
		$result = $ftx->orders()->get([
	        'order_id'=>$orderid,
	    ]);
	    if($result['result']['status'] != "new")
	    return $result;
	    else
	    	$this->order_ftx($orderid,$ftx);
	}

	public function marketbuy($userid,$trade_process_id,$quantity,$margin_call_drops,$api,$pair){

	
		$trade_process = $this->db->table('trade_process')->where('uusersid',$userid)->where('trade_status','1')->where('id',$trade_process_id)->get()->getRow();
		if($trade_process->exchange == 1) 
		{ 
		    $flags['isQuoteOrder'] = true;
            $quantity = str_replace(',', '', $quantity);
	        $userid_bind_process = $this->db->table('bind_process')->where('uusersid',$userid)->get()->getRow();
    		$key = $userid_bind_process->api_key;	
    		$secret = $userid_bind_process->secret_key;	
		    //$order=binance_buy($key,$secret,$pair,$quantity,$flags);
            $order=binance_order($key,$secret,"BUY", $pair, $quantity, 0,"MARKET",$flags);
        
    		echo"<pre>";
    		print_r($order);
    		echo"</pre>";

        		$order_history = array(
        			'pair' => $order['symbol'],
        			'order_id' => $order['orderId'],
        			'trade_process_id' => $trade_process_id,
        			'uuserid' => $userid,
        			'type' => '1',
        			'quantity' => $order['cummulativeQuoteQty'],
        			' original_quantity' => $quantity,
        			'time' => $order['transactTime'],
        			'received_amount' => $order['executedQty'],
        			'live_price' => $order['fills'][0]['price'],
        			'margin_call_drops' => $margin_call_drops,
        			'date' => date('Y-m-d',time()),
        			'strategy_mode' => $trade_process->strategy_mode,
        			'strategy_type' => $trade_process->strategy_type,
        			'exchange' => $trade_process->exchange,
        			'status' => 0,
        		);
	}
	
	else if($trade_process->exchange == 5)
	{
	    
	        $get_response=$this->db->query("select * from bybit_orders where type='1' and status='0' and mode!='first_buy'")->getRow();
	        if(empty($get_response))
	        {
    	        echo "margin_call:".$margin_call_drops;
        	    $referral1=$this->db->query("SELECT * FROM bind_process WHERE uusersid='".$userid."' and type='5'");
            	$ref=$referral1->getRow();
            	$key = $ref->api_key;
            	$secret = $ref->secret_key;
            	$account = $ref->account;
            	$acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
            	$bybitApi = new BybitApi($key, $secret);
    	        $quantity = str_replace(',', '', $quantity);
    	    	$orderlinkid = "ByBit_".rand(11111111,99999999);
    			$other = ['orderLinkId' => $orderlinkid]; // User customised order ID. A max of 36 characters. Combinations of numbers, letters (upper and lower cases), dashes, and underscores are supported. it will be returned .
    		
    			$order = $bybitApi->order('spot',$pair,'Buy','Market',"$quantity","0",$other,'1');
    			
    		    $orderid = isset($order['result']['orderId']) ? $order['result']['orderId'] : false;
    		    
            	if($orderid)
    			{
    			   
    			    	$order_det = array(
    					'orderid' => $orderid,
    					'uusersid'=> $userid,
    					'type' => '1',
    					'trade_process_id'  => $trade_process->id,
    					'status' => '0',
    					'mode'=> $margin_call_drops
    			    	);
    				    $this->db->table('bybit_orders')->insert($order_det);
    			}
	        }
	    
	    
	}
	


		if($order)
		{
			if($margin_call_drops >= 5)
			$buy_record_next = $this->db->table('api_trade_history')->set('status','1')->where("id",$trade_process_id)->where("type",2)->where("margin_call_drops",$margin_call_drops)->update();

		    $buy_record_update = $this->db->table('trade_process')->set('flag','0')->where("id",$trade_process_id)->update();
        	$buy_record_update_c1 = $this->db->table('trade_process')->set('flag_buy','0')->where("id",$trade_process_id)->update();
        	$buy_record_update_c2 = $this->db->table('trade_process')->set('sell_limit','')->where("id",$trade_process_id)->update();
        	$buy_record_update_c3 = $this->db->table('trade_process')->set('buy_limit','')->where("id",$trade_process_id)->update();
		}

		$this->db->table('api_trade_history')->insert($order_history);
		if($order){
			return true;
		}
		else{
			$duplicate_check = $this->db->table('notification_table')->where('uusersid',$userid)->like('message','Binance '.$pair)->like('created_date',date('Y-m-d'))->get()->getRow();
	    if(!$duplicate_check) { 
					$notification = array(
						'uusersid' => $userid, 
						'message'  => 'Binance '.$pair.' failed to cover short position due to insufficient exchange balance and has stopped opening short position. if you need to reopen short position, please go to the strategy details page of Open margin call',
						'created_date' => date('Y-m-d H:i:s')
		);
		$this->db->table('notification_table')->insert($notification);
	}
			return false;
		}
	}

public function marketsell($userid,$trade_process_id,$quantity,$margin_call_drops,$api,$pair){

	$flags['isQuoteOrder'] = true;

	$order = $api->marketQuoteSell($trade_process->pair,$quantity);

	$order_history = array(
		'pair' => $order['symbol'],
		'order_id' => $order['orderId'],
		'trade_process_id' => $trade_process_id,
		'uuserid' => $userid,
		'type' => '2',
		'quantity' => $order['cummulativeQuoteQty'],
		' original_quantity' => $quantity,
		'time' => $order['transactTime'],
		'received_amount' => $order['executedQty'],
		'live_price' => $order['fills'][0]['price'],
		'margin_call_drops' => $margin_call_drops
	);
	$this->db->table('api_trade_history')->insert($order_history);
	
if($order)
	return true;
else
	return false;
}

public function notify($userid,$trade_process_id,$message)
{

	$buy_records = $this->db->table('trade_process')->where("id",$trade_process_id)->orderBy('id','DESC')->get()->getRow();
	$pair=$buy_records->pair;

	$api_trade_data = array(
		'trade_log' => '3',
		'trade_status' => '0'
	);

	$trade_update = $this->db->table('trade_process')->set($api_trade_data)->where("id",$trade_process_id)->update();
	
	$notification = array(
		'uusersid' => $userid, 
		'message'  => $message.' for pair:'.$pair,
		'created_date' => date('Y-m-d H:i:s')
	);
	$this->db->table('notification_table')->insert($notification);

}


public function notify1($userid,$trade_process_id,$message)
{

	$buy_records = $this->db->table('trade_process')->where("id",$trade_process_id)->orderBy('id','DESC')->get()->getRow();
	$pair=$buy_records->pair;

	$api_trade_data = array(
		'trade_log' => '2',
		'trade_status' => '0'
		
	  );
	$trade_update = $this->db->table('trade_process')->set($api_trade_data)->where("id",$trade_process_id)->update();

	$notification = array(
		'uusersid' => $userid, 
		'message'  => $message.' for pair:'.$pair,
		'created_date' => date('Y-m-d H:i:s')
	);
	$this->db->table('notification_table')->insert($notification);

}


	public function truncate_number( $number, $precision = 2) {
    // Zero causes issues, and no need to truncate
    // if ( 0 == (int)$number ) {
    // 	echo"<pre>";
    // 	print_r("hi");
    // 	echo"</pre>";
    // 	die;
    //     return $number;
    // }
    // Are we negative?
    $negative = $number / abs($number);
    // Cast the number to a positive to solve rounding
    $number = abs($number);
    // Calculate precision number for dividing / multiplying
    $precision = pow(10, $precision);
    // Run the math, re-applying the negative value to ensure returns correctly negative / positive
  
    return floor( $number * $precision ) / $precision * $negative;
}


public function bybit_sells($userid)
{
     $db = db_connect();
	 $admin_settings = $db->table('adminsettings')->orderBy('id','DESC')->get()->getRow();
	 $fuel_fee_percent = $admin_settings->min_fuel_fee;
	 $uusersid=$userid;
	 $get_order=$this->db->query("select * from bybit_orders where uusersid='".$uusersid."' and status='0'")->getResult();
     if($get_order)
     {
         
         foreach($get_order as $order_info)
         {
             $check_record=$this->db->query("select * from  api_trade_history where order_id='".$order_info->orderid."'")->getRow();
             if(empty($check_record))
             {
                 $type=$order_info->type;
                 $tradeid=$order_info->trade_process_id;
                 $orderid=$order_info->orderid;
                 $referral1=$this->db->query("SELECT * FROM bind_process WHERE uusersid='".$uusersid."' and type='5'");
            	 $ref=$referral1->getRow();
            	 $key = $ref->api_key;
            	 $secret = $ref->secret_key;
            	 $account = $ref->account;
            	 $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
            	 $bybitApi = new BybitApi($key, $secret);
            	 $order_det = $bybitApi->GetOrders(['category' => 'spot','orderId' => $orderid]);
                 $qry_new = $this->db->query("SELECT * FROM trade_process WHERE id='".$tradeid."'")->getRowArray();
                 if($type=='1')
                 {
            
            	    if(isset($order_det['result']['list']) && !empty($order_det['result']['list']))
            	    {
        			    $history = $order_det['result']['list'][0];
            			    $order_history = array(
            				'pair' => $qry_new['pair'],
            				'order_id' => $orderid,
            				'trade_process_id' => $qry_new['id'],
            				'uuserid' => $qry_new['uusersid'],
            				'type' => '1',
            				'strategy_mode' => $qry_new['strategy_mode'],
            				'strategy_type' => $qry_new['strategy_type'],
            				'quantity' => $history['cumExecValue'],
            				'original_quantity' => $history['qty'],
            				'time' => $history['createdTime'],
            				'received_amount' => $history['cumExecQty'],
            				'date' => date('Y-m-d',time()),
            				'description'=>$order_info->mode,
            				'margin_call_drops'=>$order_info->mode,
            				'live_price' => $history['avgPrice'],
            				'exchange'  => $qry_new['exchange'],
            				'status' => 0
            			);
        			
            			$this->db = db_connect();
                		$this->db->table('api_trade_history')->insert($order_history);
            	        $sell_record_update = $this->db->table('bybit_orders')->set('status','1')->where("id",$order_info->id)->update();
             
                    }
                 }
                 else
                 {
                    $order = $order_det['result']['list'][0];
                    $pos_qty = $order['cumExecValue'];
                    $res_qty = $order['cumExecQty'];
                    $time= $order['updatedTime'];
                    $price=$order['avgPrice'];
                    $trade_process = $this->db->query("SELECT * FROM trade_process WHERE id='".$tradeid."'")->getRow();
                    $total_position_amount1 = $this->db->table('api_trade_history')->selectSum('quantity')->where("trade_process_id",$trade_process->id)->where("trade_close",'2')->orderBy('id','DESC')->get()->getRow();
                    $total_position_amount=$total_position_amount1->quantity;
                    $sell_quantity=$pos_qty;
                    
            
                    if($sell_quantity > $total_position_amount)
                	 {
                		$profit=$sell_quantity-$total_position_amount;
                	 }
                	 else
                	 {
                		$profit=$sell_quantity-$total_position_amount;
                	 }
                        $status=1;
                	 
                        if($total_position_amount > 0)
                            $profit_percentage=($profit/$total_position_amount)*100;
                        else
                            $profit_percentage='0';
                    	
                    	$fuel_fee = $profit * ($fuel_fee_percent / 100);
                    
                        
                     
                        $order_history = array(
                        'pair' => $trade_process->pair,
                    	'order_id' => $orderid,
                    	'trade_process_id' => $trade_process->id,
                    	'uuserid' => $trade_process->uusersid,
                    	'type' => '2',
                    	'quantity' => $pos_qty,
                    	'original_quantity' => $pos_qty,
                    	'time' => $time,
                    	'received_amount' => $res_qty,
                    	'description'=>$order_info->mode,
                    	'date' => date('Y-m-d',time()),
                    	'flag' => $status,
                    	'live_price' => $price,
                    	'comm_price' => $profit,
                        'profit_percentage' => $profit_percentage,
                    	'strategy_mode' => $trade_process->strategy_mode,
                        'strategy_type' => $trade_process->strategy_type,
                    	'exchange' => $trade_process->exchange,
                    	'status' => 0
                        );
                        
                        
                        $this->db->table('api_trade_history')->insert($order_history);
                        
                       // echo $this->db->last_query();
                 
                        $sell_record_update = $this->db->table('api_trade_history')->set('trade_close','1')->where('trade_close','2')->where("trade_process_id",$trade_process->id)->update();
                        $sell_record_update = $this->db->table('bybit_orders')->set('status','1')->where("id",$order_info->id)->update();
                 
                        if($order_info->mode=='close_trade')
                        {       
                            $sell_record_update = $this->db->table('trade_process')->set('trade_status','2')->where("id",$trade_process->id)->update();
                        }
                        
                    	if($fuel_fee> 0)
                    	{
                            $deposit_data = array(           // fuel fee deduction
                            'uusersid' => $trade_process->uusersid,
                            'amount'  => $fuel_fee,
                            'depositid' => $this->db->InsertID(),
                            'type'  => 'deducted_gaswallet', 
                            'description'  => 'fuel fee deduction for order no '.$orderid,
                            'date'  => date('Y-m-d H:i:s'),
                            'currency' => 1,
                            'transactionid' => $trade_process->id
                            );
                    		$this->db->table('history')->insert($deposit_data); 
                        
                    	}
     
                 }
                 
                 
             }
         }
     }
	 
    
}



public function take_profit($userid,$trade_process_id,$quantity,$price,$stopPrice,$api,$pair,$avg_price,$subsell_status,$k="")
{
	   $quantity = str_replace(',', '', $quantity);
	   $trade_process = $this->db->table('trade_process')->where('uusersid',$userid)->where('trade_status','1')->where('id',$trade_process_id)->get()->getRow();
	   
	   if($trade_process->exchange=='5')
       {
        
         $userid_bind_process = $this->db->table('bind_process')->where('uusersid',$userid)->where('type',$trade_process->exchange)->get()->getRow();
		 $api_key = $userid_bind_process->api_key;	
		 $api_secret = $userid_bind_process->secret_key;	
         $account = $userid_bind_process->account;
         $acc_type = $account == 1 ? 'CONTRACT' : 'UNIFIED';
         $bybitApi = new BybitApi($api_key, $api_secret);
         $orderlinkid = "ByBit_".rand(11111111,99999999);
         $other = ['orderLinkId' => $orderlinkid]; // User customised order ID. A max of 36 characters. Combinations of numbers, letters (upper and lower cases), dashes, and underscores are supported. it will be returned .
         $params=['category' => 'spot', 'symbol' => $pair];
         $exchange_info=$bybitApi->getMarketInfo($params);
         $lotSizeFilter=$exchange_info['lotSizeFilter'];
         $basePrecision  =$lotSizeFilter['basePrecision'];
         $quotePrecision =$lotSizeFilter['quotePrecision'];
         $minOrderQty    = $lotSizeFilter['minOrderQty'];
         $maxOrderQty    = $lotSizeFilter['maxOrderQty'];
         $minOrderAmt    = $lotSizeFilter['minOrderAmt'];
         $maxOrderAmt   = $lotSizeFilter['maxOrderAmt'];
         $decimal_digits = getDecimalDigits($basePrecision);
         $quantity=number_format($quantity,$decimal_digits);
         $quantity=str_replace(',','',$quantity);
         
         $get_response=$this->db->query("select * from bybit_orders where trade_process_id='".$trade_process->id."' and type='2' and status='0'")->getRow();
        if(empty($get_response))
        {
            $order = $bybitApi->order('spot',$pair,'SELL','Market',"$quantity","0",$other,'2');
            $orderid = isset($order['result']['orderId']) ? $order['result']['orderId'] : false;
        }
         
         if(empty($orderid))
         {
             $ret_msg=$order['retMsg'];
             if($ret_msg=='Insufficient balance.')
             {
                  if($trade_process->pair == "BNBUSDT")
                    $quantity_fee = $quantity * ( 0.65 / 100 );
                  else
                    $quantity_fee = $quantity * ( 0.1 / 100 );
                 
                   $quantity=$quantity-$quantity_fee;
                   $quantity=number_format($quantity,$decimal_digits);
                  $quantity=str_replace(',','',$quantity);
                 
                 $order = $bybitApi->order('spot',$pair,'SELL','Market',"$quantity","0",$other,'2');
         
                 $orderid = isset($order['result']['orderId']) ? $order['result']['orderId'] : false;
             }
             
         }
         
         if($orderid)
         {
         
         	$order_det = array(
					'orderid' => $orderid,
					'uusersid'=> $userid,
					'type' => '2',
					'trade_process_id'  => $trade_process_id,
					'status' => '0'
			    	);
		    $this->db->table('bybit_orders')->insert($order_det);
		    $sell_record_update = $this->db->table('api_trade_history')->set('trade_close','2')->where('trade_close','0')->where("trade_process_id",$trade_process_id)->update();
		     
		    
        }
         
     }
	   else if($trade_process->exchange == 1) 
	   { 

	 	    $userid_bind_process = $this->db->table('bind_process')->where('uusersid',$userid)->get()->getRow();
			$api_key = $userid_bind_process->api_key;	
    		$api_secret = $userid_bind_process->secret_key;	
    				
    		$exchange_info=binance_exchangeinfo($api_key);

            $filters='';
				foreach($exchange_info as $key => $value) 
				{
				   
					if($value['symbol']==$pair)
					{
						 $filters=$value['filters'];
						    break;
					}
				}


		$stepsize1 = fmod($stepsize, 1);
		$total_no = str_replace('.', '', $stepsize1);
		$count = strlen($total_no);

// $stepsize = explode('.', $stepsize)[1];
 if($stepsize == 1.00000000)
 	$current = 0;
 else
 	$current = $count - 1;

    //$order = $api->sell($pair,$quantity,0,"MARKET");
      	$order=binance_order($api_key,$api_secret,"SELL", $pair, $quantity, 0,"MARKET",$flags);
	if($order == "" || !$order){
		$quantity = $this->truncate_number($quantity,$current); 
		$quantity = str_replace(',', '', $quantity);
		//$order = $api->sell($pair,$quantity,0,"MARKET");
		  	$order=binance_order($api_key,$api_secret,"SELL", $pair, $quantity, 0,"MARKET",$flags);
	}
}


		echo"<pre>";
		print_r("stepsize");
		echo "<br>";
		print_r($stepsize);
		echo "<br>";
		print_r("current ");
		print_r($current);
		echo "<br>";
		print_r("quantity ");
		print_r($quantity);
		echo"</pre>";
       
		// $order = $api->marketQuoteSell($pair,$quantity);
		// $quantity = str_replace(',', '', $quantity);
		echo"<pre>";
		print_r("quantity \n");
		print_r($quantity);
		print_r($pair);
		echo"</pre>";
	

		echo "<pre>";
		print_r($order);
		echo "</pre>";

		if($avg_price->quantity != '' || $avg_price->quantity != 0)
		    $avg_price = $avg_price->quantity;

		// $order = $api->sell($pair, $quantity, $price, "TAKE_PROFIT_LIMIT", ["stopPrice"=>$stopPrice]);
		
        if($order) { 
        	$buy_record_update    = $this->db->table('trade_process')->set('flag','0')->where("id",$trade_process_id)->update();
        	$buy_record_update_c1 = $this->db->table('trade_process')->set('flag_buy','0')->where("id",$trade_process_id)->update();
        	$buy_record_update_c2 = $this->db->table('trade_process')->set('sell_limit','')->where("id",$trade_process_id)->update();
        	$buy_record_update_c3 = $this->db->table('trade_process')->set('buy_limit','')->where("id",$trade_process_id)->update();
	
		    $db = db_connect();
			$admin_settings = $db->table('adminsettings')->orderBy('id','DESC')->get()->getRow();
			$fuel_fee_percent = $admin_settings->min_fuel_fee;

			$total_avg_price = $avg_price;
         if($trade_process->exchange == 1){ 
	         if($subsell_status != 1)
		     $avg_price1 = $order['cummulativeQuoteQty'] - $avg_price; 
		     else
		     $avg_price1 = $order['cummulativeQuoteQty'] - $avg_price;

		 $orderid = $order['orderId'];
		 $pos_qty = $order['cummulativeQuoteQty'];
		 $time_order = $order['transactTime'];
	     $res_qty = $order['executedQty'];


	     }else if($trade_process->exchange == 2){
             if($subsell_status != 1)
		     $avg_price1 = $position_quantity - $avg_price; 
		     else
		     $avg_price1 = $position_quantity - $avg_price; 

			 $orderid = $order['ordId'];
			 $pos_qty = $position_quantity;
			 $time_order = $order['fillTime'];
			 $res_qty = $order['sz'];
	     }else{
             if($subsell_status != 1)
		     $avg_price1 = $position_quantity - $avg_price; 
		     else
		     $avg_price1 = $position_quantity - $avg_price; 

		 $orderid = $order['id'];
		 $pos_qty = $position_quantity;
		 $time_order = strtotime($order['createdAt']);
		 $res_qty = $order['size'];
	     }
		 echo"<pre>";
		 print_r("avg_price 1");
		 echo "<br>";
		 print_r($avg_price1);
		 echo"</pre>";
	     $reverse_percent = 100 - $fuel_fee_percent;
	     $avg_price = $avg_price1 * ($reverse_percent / 100);
	     $comm_price = $avg_price1 * ($fuel_fee_percent / 100);
	     echo"<pre>";
	     print_r("avg price : ");
	     print_r($avg_price);
	     echo "<br>";
	     print_r("comm price");
	     print_r($comm_price);
	     echo"</pre>";
	     /*$profit1 = $avg_price1 / $total_avg_price; 
	     $profit = $profit1 * 100;*/
	     
	     
	     $total_position_amount1 = $this->db->table('api_trade_history')->selectSum('quantity')->where("trade_process_id",$trade_process_id)->where("trade_close",'0')->orderBy('id','DESC')->get()->getRow();
    
        $total_position_amount=$total_position_amount1->quantity;
        
        echo "total_position_amount  =>" .$total_position_amount;
        
		$sell_quantity=$pos_qty;
		
		
		echo "Sell Quantity =>" .$sell_quantity;

		if($sell_quantity > $total_position_amount)
		{
			$profit=$sell_quantity-$total_position_amount;
		}
		else
		{
			$profit=$sell_quantity- $total_position_amount;
		}

		$profit_percentage=($profit/$total_position_amount)*100;

		$fuel_fee = $profit * ($fuel_fee_percent / 100);
	     
	     
	     
		 $order_history = array(
			'pair' => $pair,
			'order_id' => $orderid,
			'trade_process_id' => $trade_process_id,
			'uuserid' => $userid,
			'type' => '2',
			'quantity' => $pos_qty,
			'original_quantity' => $pos_qty,
			'time' => $time_order,
			'received_amount' => $res_qty,
			'live_price' => $stopPrice,
			'avg_price' => $avg_price1,
			'comm_price' => $profit,
			'profit_percentage' => $profit_percentage,
			'date' => date('Y-m-d',time()),
			'margin_call_drops' => $k,
			'strategy_mode' => $trade_process->strategy_mode,
			'strategy_type' => $trade_process->strategy_type,
			'subsell_status' => $subsell_status,
			'status' => 0,
			'exchange' => $trade_process->exchange
		);	
		$this->db->table('api_trade_history')->insert($order_history);
		
		if($orderid!='')
		{
		    
		    if($fuel_fee > 0)
    	    {
        		$deposit_data = array(           // fuel fee deduction
                'uusersid' => $userid,
                'amount'  => $fuel_fee,
                'depositid' => $this->db->InsertID(),
                'type'  => 'deducted_gaswallet', 
                'description'  => 'fuel fee deduction for order no '.$orderid,
                'date'  => date('Y-m-d H:i:s'),
                'currency' => 1,
                'transactionid' => $trade_process_id
                );
        		$this->db->table('history')->insert($deposit_data); 
    	    }
    		$sell_record_update = $this->db->table('api_trade_history')->set('trade_close','1')->where('trade_close','0')->where("trade_process_id",$trade_process_id)->update();
		}
		$return = true;
	}else{
		$duplicate_check = $this->db->table('notification_table')->where('uusersid',$userid)->like('message','Binance '.$pair)->like('created_date',date('Y-m-d'))->get()->getRow();
	    if(!$duplicate_check) { 
		$notification = array(
			'uusersid' => $userid, 
			'message'  => 'Binance '.$pair.' failed to cover short position due to insufficient exchange balance and has stopped opening short position. if you need to reopen short position, please go to the strategy details page of Open margin call',
			'created_date' => date('Y-m-d H:i:s')
		);
		$this->db->table('notification_table')->insert($notification);
	    }
		$return = false;
	}

		return $return;
	}


}