produce_plan_processing.php

Download you own three BR

<?php

        ///////////////////////////////////////////////////////////生产安排////////////////////////////////////////
	    
        //当前各个建筑物的等级
        $query = $db->query("select * from building where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
        $building_grade = $db->fetch_array($query);	
        /*
        $wood_grade = $building_grade[$b_type_name_en[1]];
        $iron_grade = $building_grade[$b_type_name_en[2]];
        $gold_grade = $building_grade[$b_type_name_en[3]];
        $rice_grade = $building_grade[$b_type_name_en[4]];
        */
        $house_grade = $building_grade[$b_type_name_en[5]];
        //基础建筑产量及工作人口
        for($pi=1;$pi<=4;$pi++){
        	$b_attribute_query=$db->query("select b_base,b_workers from building_attribute where `b_type`='".$pi."'");
			$build_base = $db->fetch_array($b_attribute_query);
			//每项建筑的生产安排百分比
			$query = $db->query("select worker_percent from resource_grow where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and `b_type`='".$pi."'");
		    $current_workering = $db->fetch_array($query);

		    $produce[$pi] = add_workers($build_base['b_base'],$building_grade[$b_type_name_en[$pi]]) * ($current_workering['worker_percent']/100);//产量
			$workers[$pi] = add_workers($build_base['b_workers'],$building_grade[$b_type_name_en[$pi]]) * ($current_workering['worker_percent']/100);//人口
		    //echo $workers[$pi]."|";
        }
		
        //军队占用人口
	    //当前城池士兵数/////////
	    $current_city_soldier_num=0;
		$query=$db->query("select * from soldier where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		$current_city_soldier = $db->fetch_array($query);
		if($soldier_type_name_en) foreach ($soldier_type_name_en as $si=>$sm){
		    if(!$current_city_soldier[$sm]) continue; 
			$total_produce_soldier += $current_city_soldier[$sm];
		}
		//当前城市拍卖等待上架士兵数统计
		$query_safe_ls_soldier=$db->query("select sum(s_num) as soldier_num from player_lin where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."' and s_style='1';");
		$list_safe_ls_soldier=$db->fetch_array($query_safe_ls_soldier);
		$total_produce_soldier+=$list_safe_ls_soldier['soldier_num'];
		
		//当前城市拍卖巳上架士兵数统计
		$query_safe_soldier=$db->query("select sum(s_num) as soldier_num from player_safe where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."' and s_style='1';");
		$list_safe_soldier=$db->fetch_array($query_safe_soldier);
		$total_produce_soldier+=$list_safe_soldier['soldier_num'];
		
		//当前出征士兵数
		$query_war_soldier=$db->query("select * from war_task where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		while ($list_war_soldier=$db->fetch_array($query_war_soldier)){
			$soldier_n_a=explode("|",$list_war_soldier['w_soldier_num']);
			$count_n=count($soldier_n_a);
			for ($i=0;$i<$count_n;$i++){
				$total_produce_soldier+=$soldier_n_a[$i];
			}
		}
		
		
	    $arm_workers = ceil($total_produce_soldier / 5);
	    $total_need_worker = $workers[1] + $workers[2] + $workers[3] + $workers[4] + $arm_workers;
	    //echo $arm_workers."<br />";
	    //生产总比率 = 总人口 / 当前需求人口
		//$query=$db->query("select * from resource where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		//$total_resource=$db->fetch_array($query);
		
	    $b_attribute_query=$db->query("select b_base,b_workers from building_attribute where `b_type`='5'");
		$build_base_total = $db->fetch_array($b_attribute_query);
		
	    $total_house = add_workers($build_base_total['b_base'],$house_grade);
	    //echo $total_house;exit;
	    if($total_need_worker) $total_percent = $total_house / $total_need_worker;
	    $total_percent = ($total_percent>=1) ? 1 : $total_percent;
	    $total_percent = substr($total_percent,0,4);
	    //echo $total_house."/".$total_need_worker."=".$total_percent;exit;
	    //研究科技表
	    $query=$db->query("select * from study where `u_id`='".$_COOKIE['UserId']."' ");
		$study_result=$db->fetch_array($query);
        
		//更新总百分比率
		$db->query("update resource set `grow_percent`='".$total_percent."' where  `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		
		
		//查询是否有使用增产物品
		$query_use_if_goods=$db->query("select * from add_goods_info where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."' and type='1';");
		$io_use=$db->fetch_array($query_use_if_goods);
		if ($io_use['golds_add']) $re_use_good_add[3]=$io_use['golds_add'];else $re_use_good_add[3]=0;
		if ($io_use['rices_add']) $re_use_good_add[4]=$io_use['rices_add'];else $re_use_good_add[4]=0;
		if ($io_use['woods_add']) $re_use_good_add[1]=$io_use['woods_add'];else $re_use_good_add[1]=0;
		if ($io_use['ores_add']) $re_use_good_add[2]=$io_use['ores_add'];else $re_use_good_add[2]=0;
	    
		//算出最后的实际产量和工作人口
	    for($i=1;$i<=4;$i++){
	    	$truegrow[$i] = $produce[$i] * $total_percent;//产量
			$true_workers[$i] = $workers[$i];//人口
			
			//如果当前等级
			if($building_grade[$b_type_name_en[$i]]){
		       $query=$db->query("update resource_grow set `last_grow_time`='".time()."' where `b_type`='".$i."' and `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");      	
		    } 
		                switch ($i){
		                	case 1:{
		                		$truegrow[$i] = $truegrow[$i] + $truegrow[$i] * $study_result['s_cutting'] * 0.01;
		                		break;
		                	}
		                	case 2:{
		                		$truegrow[$i] = $truegrow[$i] + $truegrow[$i] * $study_result['s_mining'] * 0.01; 
		                		break;
		                	}
		                	case 3:{
		                		$truegrow[$i] = $truegrow[$i] + $truegrow[$i] * $study_result['s_golds'] * 0.01; 
		                		break;
		                	}
		                	case 4:{
		                		$truegrow[$i] = $truegrow[$i] + $truegrow[$i] * $study_result['s_flooding'] * 0.01; 
		                		break;
		                	}
		                }
		     			$truegrow[$i]=$truegrow[$i]+$re_use_good_add[$i];
			$query=$db->query("update resource_grow set `true_workers`='".$true_workers[$i]."',`total_grow`='".round($truegrow[$i],0)."' where `b_type`='".$i."' and `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");  
		}
		
		
?>