登录  /  注册
首页 > 运维 > linux运维 > 正文

Linux中自动生成数据详解

小云云
发布： 2018-03-31 10:38:12
原创
1478人浏览过

本文主要和大家分享linux中自动生成数据详解，主要以代码的方法和大家分享，希望能帮助到大家。

/*
 * 自动任务跑数据
 * 订单组日工作量报表数据写入
 * 
 * $start_date     0000-00-00 00:00:00                 开始时间
 * $email_start_date    0000-00-00 00:00:00                 开始时间
 * $end_dates           0000-00-00 00:00:00                 结束时间
 */
require_once( "config.php" );
$flagFile = dirname(__FILE__) . "/order-day-workload";
if (@file_exists($flagFile)) {
    Common_Service_Common::autoRunFlag($flagFile, __FILE__, 2);
    die("程序正在运行！");
}
ini_set("memory_limit", "-1");
set_time_limit(0);
define("RUNTIME", "[ " . date("Y-m-d H:i:s") . " ] ");
echo RUNTIME . "Starting!\n";
$reRun = false;
$start_date = date("Y-m-d 08:30:00", strtotime("-1 day"));
$end_dates = date("Y-m-d 08:30:00");
$Object = new Order_Service_OrderWorkload();
for (; $start_date < $end_dates;) {
    $end_date = date("Y-m-d 08:30:00", strtotime("+1 day", strtotime($start_date)));
    $date = $start_date;
    echo $start_date . "\n";
    $start_date = date("Y-m-d H:i:s", strtotime($start_date) + 24 * 3600);
}
$email_start_date = date("Y-m-d 08:30:00", strtotime("-1 day"));
//休眠 5 秒后等待数据同步
sleep(5);
$Object->orderDayWorkload($email_start_date, $end_dates);
echo "[ " . date(&#39;Y-m-d H:i:s&#39;) . " ] 结束运行\r\n";
@unlink($flagFile);


//Services
//配置标准时间
public static $StandardConfigurationTime = array(
    //配货员
    "STANDARD_CONFIGURATION_PEIHUO",
    //打包员
    "STANDARD_CONFIGURATION_PACKING",
    //分拣员
    "STANDARD_CONFIGURATION_SORTER",
);

public static function getAdapter() {
    $model = new Order_Model_OrderWorkload();
    return $model->getAdapter();
}

/*
 * $row        array()             条件
 */

public static function add($row) {
    $object = new Order_Model_OrderWorkload();
    return $object->add($row);
}

/*
* 订单组日工作量数据写入
*
* $email_start_date   0000-00-00 00:00:00              开始时间
* $end_dates          0000-00-00 00:00:00              结束时间
*/

public static function orderDayWorkload($email_start_date, $end_dates) {
   $orderWorkload = new Order_Model_OrderWorkload();
   $dbAdapter = $orderWorkload->getAdapter();
   $dbAdapter->beginTransaction();
   try {
       //配货时间
       $peihuo_time = "";
       //打包时间
       $packing_time = "";
       //分拣时间
       $sorter_time = "";
       //配货员超时票数
       $count_peihuo = "";
       //打包员超时票数
       $count_packing = "";
       //分拣员超时票数
       $count_sorter = "";
       $row = array();

       //根据条件获取对应数据
       $combination = array(
           "op_create_date_gt" => $email_start_date,
           "op_create_date_lt" => $end_dates,
           "op_status" => 1,
       );
       $opIds = Product_Service_Pickup::getByCondition($combination, "*");
       if (!$opIds) {
           echo "未获取到该时间段  [ " . $email_start_date . " ] ~ [ " . $end_dates . " ] 的信息";
       }
       foreach ($opIds as $value) {
           $opOrdersType = $value[&#39;op_orders_type&#39;];
           $warehouseId = $value[&#39;warehouse_id&#39;];

           /*
            * 配货员数据
            */
           $pickupUserId = $value[&#39;pickup_user_id&#39;];
           //配货员时间
           if ($value[&#39;op_end_time&#39;] != &#39;0000-00-00 00:00:00&#39; && $value[&#39;op_start_time&#39;] != &#39;0000-00-00 00:00:00&#39;) {
               $peihuo_time = round((strtotime($value[&#39;op_end_time&#39;]) - strtotime($value[&#39;op_start_time&#39;])) / 60, 0);
           } else {
               $peihuo_time = 0;
           }
           //根据配货员账号开通时间和订单类型分别计算超时票数
           $userInfo = User_Service_User::getByUserId($pickupUserId);
           $configId = Common_Service_Config::getByAttribute(Order_Service_OrderWorkload::$StandardConfigurationTime[&#39;0&#39;], $warehouseId);
           $configValueInfo = unserialize($configId[&#39;config_value&#39;]);
           //培训期
           $trainDate = date("Y-m-d H:i:s", strtotime("+10 day", strtotime($userInfo[&#39;create_date&#39;])));
           //试岗期
           $try_hillockDate = date("Y-m-d H:i:s", strtotime("+20 day", strtotime($userInfo[&#39;create_date&#39;])));
           //上岗期
           $postsDate = date("Y-m-d H:i:s", strtotime("+30 day", strtotime($userInfo[&#39;create_date&#39;])));
           $count_peihuo = 0;
           if ($value[&#39;op_start_time&#39;] <= $trainDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;trainA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;trainB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;trainC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           } else if ($value[&#39;op_start_time&#39;] > $trainDate && $value[&#39;op_start_time&#39;] <= $try_hillockDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;try_hillockA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;try_hillockB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;try_hillockC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           } else if ($value[&#39;op_start_time&#39;] > $try_hillockDate && $value[&#39;op_start_time&#39;] <= $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;postsA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;postsB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;postsC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           } else if ($value[&#39;op_start_time&#39;] > $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;matureA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;matureB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;matureC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           }
           //根据配货员和订单类型仓库作为键、组成四维数组，如果有相同的键，就把对应值相加
           if (!isset($row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId])) {
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] = $count_peihuo;
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_more&#39;] = $value[&#39;op_more&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] = $value[&#39;op_wrong&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] = $value[&#39;op_leakage&#39;];
           } else {
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] += $count_peihuo;
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_more&#39;] += $value[&#39;op_more&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] += $value[&#39;op_wrong&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] += $value[&#39;op_leakage&#39;];
           }
           $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_total_pickup&#39;] += 1;
           $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;total_time&#39;][] = $peihuo_time;                   


           /*
            * 打包员数据
            */    
           $packageUserId = $value[&#39;package_user_id&#39;];
           //打包员时间
           if ($value[&#39;op_pack_end&#39;] != &#39;0000-00-00 00:00:00&#39; && $value[&#39;op_pack_start&#39;] != &#39;0000-00-00 00:00:00&#39;) {
               $packing_time = ceil((strtotime($value[&#39;op_pack_end&#39;]) - strtotime($value[&#39;op_pack_start&#39;])) / 60);
           } else {
               $packing_time = 0;
           }
           //根据打包员账号开通时间和订单类型分别计算超时票数
           $userInfo = User_Service_User::getByUserId($packageUserId);
           $configId = Common_Service_Config::getByAttribute(Order_Service_OrderWorkload::$StandardConfigurationTime[&#39;1&#39;], $warehouseId);
           $configValueInfo = unserialize($configId[&#39;config_value&#39;]);
           //培训期
           $trainDate = date("Y-m-d H:i:s", strtotime("+10 day", strtotime($userInfo[&#39;create_date&#39;])));
           //试岗期
           $try_hillockDate = date("Y-m-d H:i:s", strtotime("+20 day", strtotime($userInfo[&#39;create_date&#39;])));
           //上岗期
           $postsDate = date("Y-m-d H:i:s", strtotime("+30 day", strtotime($userInfo[&#39;create_date&#39;])));
           $count_packing = 0;
           if ($value[&#39;op_pack_start&#39;] <= $trainDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;trainA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;trainB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;trainC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           } else if ($value[&#39;op_pack_start&#39;] > $trainDate && $value[&#39;op_pack_start&#39;] <= $try_hillockDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;try_hillockA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;try_hillockB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;try_hillockC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           } else if ($value[&#39;op_pack_start&#39;] > $try_hillockDate && $value[&#39;op_pack_start&#39;] <= $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;postsA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;postsB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;postsC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           } else if ($value[&#39;op_pack_start&#39;] > $postsDate) {
              if ((($opOrdersType == 0 && $configValueInfo[&#39;matureA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;matureB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;matureC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           }
           //根据打包员和订单类型仓库作为键、组成四维数组，如果有相同的键，就把对应值相加
           if (!isset($row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId])) {
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] = $count_packing;
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_more&#39;] = $value[&#39;op_more&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] = $value[&#39;op_wrong&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] = $value[&#39;op_leakage&#39;];
           } else {
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] += $count_packing;
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_more&#39;] += $value[&#39;op_more&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] += $value[&#39;op_wrong&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] += $value[&#39;op_leakage&#39;];
           }
           $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_total_pickup&#39;] += 1;
           $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;total_time&#39;][] = $packing_time;


           /*
            * 分拣员数据
            */
           $opSortingUser = $value[&#39;op_sorting_user&#39;];
           //分拣员时间
           if ($value[&#39;op_sorting_end&#39;] != &#39;0000-00-00 00:00:00&#39; && $value[&#39;op_sorting_start&#39;] != &#39;0000-00-00 00:00:00&#39;) {
               $sorter_time = ceil((strtotime($value[&#39;op_sorting_end&#39;]) - strtotime($value[&#39;op_sorting_start&#39;])) / 60);
           } else {
               $sorter_time = 0;
           }
           //根据分拣员账号开通时间和订单类型分别计算超时票数
           $userInfo = User_Service_User::getByUserId($opSortingUser);
           $configId = Common_Service_Config::getByAttribute(Order_Service_OrderWorkload::$StandardConfigurationTime[&#39;2&#39;], $warehouseId);
           $configValueInfo = unserialize($configId[&#39;config_value&#39;]);
           //培训期
           $trainDate = date("Y-m-d H:i:s", strtotime("+10 day", strtotime($userInfo[&#39;create_date&#39;])));
           //试岗期
           $try_hillockDate = date("Y-m-d H:i:s", strtotime("+20 day", strtotime($userInfo[&#39;create_date&#39;])));
           //上岗期
           $postsDate = date("Y-m-d H:i:s", strtotime("+30 day", strtotime($userInfo[&#39;create_date&#39;])));
           $count_sorter = 0;
           if ($value[&#39;op_sorting_start&#39;] <= $trainDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;trainA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;trainB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;trainC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           } else if ($value[&#39;op_sorting_start&#39;] > $trainDate && $value[&#39;op_sorting_start&#39;] <= $try_hillockDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;try_hillockA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;try_hillockB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;try_hillockC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           } else if ($value[&#39;op_sorting_start&#39;] > $try_hillockDate && $value[&#39;op_sorting_start&#39;] <= $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;postsA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;postsB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;postsC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           } else if ($value[&#39;op_sorting_start&#39;] > $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;matureA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;matureB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;matureC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           }
           //根据分拣员和订单类型仓库作为键、组成四维数组，如果有相同的键，就把对应值相加
           if (!isset($row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId])) {
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] = $count_sorter;
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_more&#39;] = $value[&#39;op_more&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] = $value[&#39;op_wrong&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] = $value[&#39;op_leakage&#39;];
           } else {
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] += $count_sorter;
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_more&#39;] += $value[&#39;op_more&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] += $value[&#39;op_wrong&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] += $value[&#39;op_leakage&#39;];
           }
           $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_total_pickup&#39;] += 1;
           $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;total_time&#39;][] = $sorter_time;
       }

       //分解数组写入数据库
       foreach ($row as $key => $val) {
           $substr = substr($key, -1);
           if ($key != 0) {
               foreach ($val as $ke => $va) {
                   foreach ($va as $k => $v) {
                       $combition = array(
                           "user_id" => $key,
                           "warehouse_id" => $k,
                           "ow_date" => $email_start_date,
                           "ow_total_pickup" => $v[&#39;ow_total_pickup&#39;],
                           "ow_type" => $ke,
                           "ow_fast" => min($v[&#39;total_time&#39;]),
                           "ow_avg" => round(array_sum($v[&#39;total_time&#39;]) / $v[&#39;ow_total_pickup&#39;]),
                           "ow_slow" => max($v[&#39;total_time&#39;]),
                           "ow_orders" => $v[&#39;ow_total_pickup&#39;],
                           "ow_overtime_qty" => $v[&#39;ow_overtime_qty&#39;],
                           "ow_more" => $v[&#39;ow_more&#39;],
                           "ow_wrong" => $v[&#39;ow_wrong&#39;],
                           "ow_leakage" => $v[&#39;ow_leakage&#39;],
                           "ow_create_time" => date("Y-m-d H:i:s"),
                           "ow_post" => $substr,
                       );
                       if (!Order_Service_OrderWorkload::add($combition)) {
                           echo "写入数据失败";
                       }
                   }
               }
           }
       }
       $dbAdapter->commit();
   } catch (Exception $e) {
       $dbAdapter->rollback();
       echo "[ " . date("Y-m-d H:is") . " ] 出现异常,异常信息为：" . $e->getMessage();
   }
}


//Models
private $_table;

public function __construct() {
    $this->_table = new Order_Model_DbTable_OrderWorkload();
}

public function getAdapter() {
    return $this->_table->getAdapter();
}

/*
 * $row        array()             条件
 */

public function add($row) {
    return $this->_table->insert($row);
}


//Models/DbTable
class Order_Model_DbTable_OrderWorkload extends Zend_Db_Table_Abstract {

    //数据表名称
    protected $_name = "order_workload";
    //主键
    protected $_primary = "ow_id";
    protected $_sequence = true;

}
登录后复制
登录后复制

/*
 * 自动任务跑数据
 * 订单组日工作量报表数据写入
 * 
 * $start_date     0000-00-00 00:00:00                 开始时间
 * $email_start_date    0000-00-00 00:00:00                 开始时间
 * $end_dates           0000-00-00 00:00:00                 结束时间
 */
require_once( "config.php" );
$flagFile = dirname(__FILE__) . "/order-day-workload";
if (@file_exists($flagFile)) {
    Common_Service_Common::autoRunFlag($flagFile, __FILE__, 2);
    die("程序正在运行！");
}
ini_set("memory_limit", "-1");
set_time_limit(0);
define("RUNTIME", "[ " . date("Y-m-d H:i:s") . " ] ");
echo RUNTIME . "Starting!\n";
$reRun = false;
$start_date = date("Y-m-d 08:30:00", strtotime("-1 day"));
$end_dates = date("Y-m-d 08:30:00");
$Object = new Order_Service_OrderWorkload();
for (; $start_date < $end_dates;) {
    $end_date = date("Y-m-d 08:30:00", strtotime("+1 day", strtotime($start_date)));
    $date = $start_date;
    echo $start_date . "\n";
    $start_date = date("Y-m-d H:i:s", strtotime($start_date) + 24 * 3600);
}
$email_start_date = date("Y-m-d 08:30:00", strtotime("-1 day"));
//休眠 5 秒后等待数据同步
sleep(5);
$Object->orderDayWorkload($email_start_date, $end_dates);
echo "[ " . date(&#39;Y-m-d H:i:s&#39;) . " ] 结束运行\r\n";
@unlink($flagFile);


//Services
//配置标准时间
public static $StandardConfigurationTime = array(
    //配货员
    "STANDARD_CONFIGURATION_PEIHUO",
    //打包员
    "STANDARD_CONFIGURATION_PACKING",
    //分拣员
    "STANDARD_CONFIGURATION_SORTER",
);

public static function getAdapter() {
    $model = new Order_Model_OrderWorkload();
    return $model->getAdapter();
}

/*
 * $row        array()             条件
 */

public static function add($row) {
    $object = new Order_Model_OrderWorkload();
    return $object->add($row);
}

/*
* 订单组日工作量数据写入
*
* $email_start_date   0000-00-00 00:00:00              开始时间
* $end_dates          0000-00-00 00:00:00              结束时间
*/

public static function orderDayWorkload($email_start_date, $end_dates) {
   $orderWorkload = new Order_Model_OrderWorkload();
   $dbAdapter = $orderWorkload->getAdapter();
   $dbAdapter->beginTransaction();
   try {
       //配货时间
       $peihuo_time = "";
       //打包时间
       $packing_time = "";
       //分拣时间
       $sorter_time = "";
       //配货员超时票数
       $count_peihuo = "";
       //打包员超时票数
       $count_packing = "";
       //分拣员超时票数
       $count_sorter = "";
       $row = array();

       //根据条件获取对应数据
       $combination = array(
           "op_create_date_gt" => $email_start_date,
           "op_create_date_lt" => $end_dates,
           "op_status" => 1,
       );
       $opIds = Product_Service_Pickup::getByCondition($combination, "*");
       if (!$opIds) {
           echo "未获取到该时间段  [ " . $email_start_date . " ] ~ [ " . $end_dates . " ] 的信息";
       }
       foreach ($opIds as $value) {
           $opOrdersType = $value[&#39;op_orders_type&#39;];
           $warehouseId = $value[&#39;warehouse_id&#39;];

           /*
            * 配货员数据
            */
           $pickupUserId = $value[&#39;pickup_user_id&#39;];
           //配货员时间
           if ($value[&#39;op_end_time&#39;] != &#39;0000-00-00 00:00:00&#39; && $value[&#39;op_start_time&#39;] != &#39;0000-00-00 00:00:00&#39;) {
               $peihuo_time = round((strtotime($value[&#39;op_end_time&#39;]) - strtotime($value[&#39;op_start_time&#39;])) / 60, 0);
           } else {
               $peihuo_time = 0;
           }
           //根据配货员账号开通时间和订单类型分别计算超时票数
           $userInfo = User_Service_User::getByUserId($pickupUserId);
           $configId = Common_Service_Config::getByAttribute(Order_Service_OrderWorkload::$StandardConfigurationTime[&#39;0&#39;], $warehouseId);
           $configValueInfo = unserialize($configId[&#39;config_value&#39;]);
           //培训期
           $trainDate = date("Y-m-d H:i:s", strtotime("+10 day", strtotime($userInfo[&#39;create_date&#39;])));
           //试岗期
           $try_hillockDate = date("Y-m-d H:i:s", strtotime("+20 day", strtotime($userInfo[&#39;create_date&#39;])));
           //上岗期
           $postsDate = date("Y-m-d H:i:s", strtotime("+30 day", strtotime($userInfo[&#39;create_date&#39;])));
           $count_peihuo = 0;
           if ($value[&#39;op_start_time&#39;] <= $trainDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;trainA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;trainB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;trainC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           } else if ($value[&#39;op_start_time&#39;] > $trainDate && $value[&#39;op_start_time&#39;] <= $try_hillockDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;try_hillockA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;try_hillockB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;try_hillockC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           } else if ($value[&#39;op_start_time&#39;] > $try_hillockDate && $value[&#39;op_start_time&#39;] <= $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;postsA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;postsB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;postsC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           } else if ($value[&#39;op_start_time&#39;] > $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;matureA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;matureB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;matureC&#39;])) <= $peihuo_time) {
                   $count_peihuo = 1;
               }
           }
           //根据配货员和订单类型仓库作为键、组成四维数组，如果有相同的键，就把对应值相加
           if (!isset($row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId])) {
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] = $count_peihuo;
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_more&#39;] = $value[&#39;op_more&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] = $value[&#39;op_wrong&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] = $value[&#39;op_leakage&#39;];
           } else {
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] += $count_peihuo;
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_more&#39;] += $value[&#39;op_more&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] += $value[&#39;op_wrong&#39;];
               $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] += $value[&#39;op_leakage&#39;];
           }
           $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;ow_total_pickup&#39;] += 1;
           $row[$pickupUserId . &#39;-&#39; . 0][$opOrdersType][$warehouseId][&#39;total_time&#39;][] = $peihuo_time;                   


           /*
            * 打包员数据
            */    
           $packageUserId = $value[&#39;package_user_id&#39;];
           //打包员时间
           if ($value[&#39;op_pack_end&#39;] != &#39;0000-00-00 00:00:00&#39; && $value[&#39;op_pack_start&#39;] != &#39;0000-00-00 00:00:00&#39;) {
               $packing_time = ceil((strtotime($value[&#39;op_pack_end&#39;]) - strtotime($value[&#39;op_pack_start&#39;])) / 60);
           } else {
               $packing_time = 0;
           }
           //根据打包员账号开通时间和订单类型分别计算超时票数
           $userInfo = User_Service_User::getByUserId($packageUserId);
           $configId = Common_Service_Config::getByAttribute(Order_Service_OrderWorkload::$StandardConfigurationTime[&#39;1&#39;], $warehouseId);
           $configValueInfo = unserialize($configId[&#39;config_value&#39;]);
           //培训期
           $trainDate = date("Y-m-d H:i:s", strtotime("+10 day", strtotime($userInfo[&#39;create_date&#39;])));
           //试岗期
           $try_hillockDate = date("Y-m-d H:i:s", strtotime("+20 day", strtotime($userInfo[&#39;create_date&#39;])));
           //上岗期
           $postsDate = date("Y-m-d H:i:s", strtotime("+30 day", strtotime($userInfo[&#39;create_date&#39;])));
           $count_packing = 0;
           if ($value[&#39;op_pack_start&#39;] <= $trainDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;trainA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;trainB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;trainC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           } else if ($value[&#39;op_pack_start&#39;] > $trainDate && $value[&#39;op_pack_start&#39;] <= $try_hillockDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;try_hillockA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;try_hillockB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;try_hillockC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           } else if ($value[&#39;op_pack_start&#39;] > $try_hillockDate && $value[&#39;op_pack_start&#39;] <= $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;postsA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;postsB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;postsC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           } else if ($value[&#39;op_pack_start&#39;] > $postsDate) {
              if ((($opOrdersType == 0 && $configValueInfo[&#39;matureA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;matureB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;matureC&#39;])) <= $packing_time) {
                   $count_packing = 1;
               }
           }
           //根据打包员和订单类型仓库作为键、组成四维数组，如果有相同的键，就把对应值相加
           if (!isset($row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId])) {
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] = $count_packing;
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_more&#39;] = $value[&#39;op_more&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] = $value[&#39;op_wrong&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] = $value[&#39;op_leakage&#39;];
           } else {
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] += $count_packing;
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_more&#39;] += $value[&#39;op_more&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] += $value[&#39;op_wrong&#39;];
               $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] += $value[&#39;op_leakage&#39;];
           }
           $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;ow_total_pickup&#39;] += 1;
           $row[$packageUserId . &#39;-&#39; . 1][$opOrdersType][$warehouseId][&#39;total_time&#39;][] = $packing_time;


           /*
            * 分拣员数据
            */
           $opSortingUser = $value[&#39;op_sorting_user&#39;];
           //分拣员时间
           if ($value[&#39;op_sorting_end&#39;] != &#39;0000-00-00 00:00:00&#39; && $value[&#39;op_sorting_start&#39;] != &#39;0000-00-00 00:00:00&#39;) {
               $sorter_time = ceil((strtotime($value[&#39;op_sorting_end&#39;]) - strtotime($value[&#39;op_sorting_start&#39;])) / 60);
           } else {
               $sorter_time = 0;
           }
           //根据分拣员账号开通时间和订单类型分别计算超时票数
           $userInfo = User_Service_User::getByUserId($opSortingUser);
           $configId = Common_Service_Config::getByAttribute(Order_Service_OrderWorkload::$StandardConfigurationTime[&#39;2&#39;], $warehouseId);
           $configValueInfo = unserialize($configId[&#39;config_value&#39;]);
           //培训期
           $trainDate = date("Y-m-d H:i:s", strtotime("+10 day", strtotime($userInfo[&#39;create_date&#39;])));
           //试岗期
           $try_hillockDate = date("Y-m-d H:i:s", strtotime("+20 day", strtotime($userInfo[&#39;create_date&#39;])));
           //上岗期
           $postsDate = date("Y-m-d H:i:s", strtotime("+30 day", strtotime($userInfo[&#39;create_date&#39;])));
           $count_sorter = 0;
           if ($value[&#39;op_sorting_start&#39;] <= $trainDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;trainA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;trainB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;trainC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           } else if ($value[&#39;op_sorting_start&#39;] > $trainDate && $value[&#39;op_sorting_start&#39;] <= $try_hillockDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;try_hillockA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;try_hillockB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;try_hillockC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           } else if ($value[&#39;op_sorting_start&#39;] > $try_hillockDate && $value[&#39;op_sorting_start&#39;] <= $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;postsA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;postsB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;postsC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           } else if ($value[&#39;op_sorting_start&#39;] > $postsDate) {
               if ((($opOrdersType == 0 && $configValueInfo[&#39;matureA&#39;]) || ($opOrdersType == 1 && $configValueInfo[&#39;matureB&#39;]) || ($opOrdersType == 2 && $configValueInfo[&#39;matureC&#39;])) <= $sorter_time) {
                   $count_sorter = 1;
               }
           }
           //根据分拣员和订单类型仓库作为键、组成四维数组，如果有相同的键，就把对应值相加
           if (!isset($row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId])) {
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] = $count_sorter;
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_more&#39;] = $value[&#39;op_more&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] = $value[&#39;op_wrong&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] = $value[&#39;op_leakage&#39;];
           } else {
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_overtime_qty&#39;] += $count_sorter;
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_more&#39;] += $value[&#39;op_more&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_wrong&#39;] += $value[&#39;op_wrong&#39;];
               $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_leakage&#39;] += $value[&#39;op_leakage&#39;];
           }
           $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;ow_total_pickup&#39;] += 1;
           $row[$opSortingUser . &#39;-&#39; . 2][$opOrdersType][$warehouseId][&#39;total_time&#39;][] = $sorter_time;
       }

       //分解数组写入数据库
       foreach ($row as $key => $val) {
           $substr = substr($key, -1);
           if ($key != 0) {
               foreach ($val as $ke => $va) {
                   foreach ($va as $k => $v) {
                       $combition = array(
                           "user_id" => $key,
                           "warehouse_id" => $k,
                           "ow_date" => $email_start_date,
                           "ow_total_pickup" => $v[&#39;ow_total_pickup&#39;],
                           "ow_type" => $ke,
                           "ow_fast" => min($v[&#39;total_time&#39;]),
                           "ow_avg" => round(array_sum($v[&#39;total_time&#39;]) / $v[&#39;ow_total_pickup&#39;]),
                           "ow_slow" => max($v[&#39;total_time&#39;]),
                           "ow_orders" => $v[&#39;ow_total_pickup&#39;],
                           "ow_overtime_qty" => $v[&#39;ow_overtime_qty&#39;],
                           "ow_more" => $v[&#39;ow_more&#39;],
                           "ow_wrong" => $v[&#39;ow_wrong&#39;],
                           "ow_leakage" => $v[&#39;ow_leakage&#39;],
                           "ow_create_time" => date("Y-m-d H:i:s"),
                           "ow_post" => $substr,
                       );
                       if (!Order_Service_OrderWorkload::add($combition)) {
                           echo "写入数据失败";
                       }
                   }
               }
           }
       }
       $dbAdapter->commit();
   } catch (Exception $e) {
       $dbAdapter->rollback();
       echo "[ " . date("Y-m-d H:is") . " ] 出现异常,异常信息为：" . $e->getMessage();
   }
}


//Models
private $_table;

public function __construct() {
    $this->_table = new Order_Model_DbTable_OrderWorkload();
}

public function getAdapter() {
    return $this->_table->getAdapter();
}

/*
 * $row        array()             条件
 */

public function add($row) {
    return $this->_table->insert($row);
}


//Models/DbTable
class Order_Model_DbTable_OrderWorkload extends Zend_Db_Table_Abstract {

    //数据表名称
    protected $_name = "order_workload";
    //主键
    protected $_primary = "ow_id";
    protected $_sequence = true;

}
登录后复制
登录后复制

以上就是Linux中自动生成数据详解的详细内容，更多请关注php中文网其它相关文章！

智能AI问答
PHP中文网智能助手能迅速回答你的编程问题，提供实时的代码和解决方案，帮助你解决各种难题。不仅如此，它还能提供编程资源和学习指导，帮助你快速提升编程技能。无论你是初学者还是专业人士，AI智能助手都能成为你的可靠助手，助力你在编程领域取得更大的成就。
我要提问
相关标签：
linux linux
来源：php中文网
收藏 点赞
上一篇：总结linux环境下的last和lastb的命令 下一篇：Linux数组和关联数组详解
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
作者最新文章
最新问题
子窗口操作父窗口，输出没反应 前两句可执行，最后一句没法应
P粉722478067来自于2024-04-19 15:37:47
0 0 19
父窗口没有输出 document.onclick = function(){ window.opener.document.write('我是子窗口的输出');  &nb...
P粉722478067来自于2024-04-18 23:52:34
0 0 40
关于CSS思维导图的课件在哪？ 课件
凡人来自于2024-04-16 10:10:18
0 0 129
PX自动转换为REM错误  <style>html {   font-size: calc(100vw / 3.75);      }...
凡人来自于2024-04-16 09:34:16
0 0 767
PHP数组从URL参数中获取的行为不如预期 我有一个包含类别ID的URL参数，我想将其视为一个数组，如下所示：http://example.com?cat[]=3,9,13在PHP中，我使用它从URL参数获取数组：$catI...
P粉785905797来自于2024-04-06 22:09:02
0 1 438
通过添加 Width 属性将内容向左移动 我已经为主体提供了边距。主要{左边缘：200px;右边距：200px；文本对齐：居中}由于我想以两行而不是一行显示文本，因此我在样式中添加了width属性。.p{字体大小：12px...
P粉738046172来自于2024-04-06 22:01:35
0 2 317
我应该在 apache 中哪里放置 CustomLog 指令 我正在使用php:7.2-apachedocker。我需要禁用运行状况检查url登录访问日志。基于此链接，他们提到了有关修改Customlog指令的信息。我不是关于需要更改Cust...
P粉573809727来自于2024-04-06 22:03:59
0 1 442
返回值中变量的格式是什么？ 我是php的新学习者。我发现有一段代码：if($x<time()){return[false,'error'];}逻辑或变量并不重要，但我不明白[false,'error']...
P粉757556355来自于2024-04-06 21:55:20
0 1 266
页面突然无法拉动 css 或 bootstrap 所以我正在开发一个页面，我昨天做了一部分，效果很好，今天我继续做剩下的部分，一切都很好。当我尝试将其作为普通html页面打开时，CSS或BOOTSTRAP不起作用，仅显示页面文本，...
P粉771233336来自于2024-04-06 21:58:04
0 1 357
如何在 React 中的排序方法上触发渲染（带有过滤器和分页）？ 这是我的Sort.js样式组件：<SortWrapper><SortText>SortBy</SortText><SortSelecton...
P粉970736384来自于2024-04-06 21:28:37
0 1 1863
相关专题
更多>
热门推荐
热门教程
更多>
相关推荐
热门推荐
最新课程
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网：公益在线php培训，帮助PHP学习者快速成长！
关注服务号 技术交流群
app下载
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2024 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号

  • 精品班

  • 技术支持

  • 技术咨询

  • 学习群

  • 会员优惠

  • 返回顶部