<?php
class ControllerTransferTransfer extends Controller
{
//单纯跑产品
public function index()
{
$this->load->model('transfer/transfer');
//默认get方式
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, "http://118.24.209.125/appApi/opencart_wx45_transfer.php");
// CURLOPT_RETURNTRANSFER 设置是否有返回值
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
//执行完以后的返回值
$response = curl_exec($curl);
//释放curl
curl_close($curl);
$rjson = json_decode($response, true);
$data = $rjson['data'];
$this->model_transfer_transfer->updata($data);
$this->response->addHeader('Content-Type: application/json');
$this->response->setOutput(json_encode(array(
'result' => 1,
'msg' => 'successful',
'data' => '数据迁入成功',
)));
}
//如果产品有更新,可以更新产品
public function timing()
{
// ignore_user_abort(false);//当用户关闭页面时服务停止
// set_time_limit(0); //设置执行时间,单位是秒。0表示不限制。
// date_default_timezone_set('Asia/Shanghai');//设置时区
// $interval = 86400;//多长时间执行一次
// do {
$this->load->model('transfer/transfer');
//默认get方式
// 得到yixiu的goods_id
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, "http://118.24.209.125/appApi/opencart_wx45_getId.php");// CURLOPT_RETURNTRANSFER 设置是否有返回值
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);//执行完以后的返回值
$response = curl_exec($curl);//释放curl
curl_close($curl);
$rjson = json_decode($response, true);
$one = $rjson['data'];
//得到opencart-wx45的goods_id
$query1 = $this->db->query(" SELECT product_id AS goods_id FROM oc_product");
$two = $query1->rows;
// 看相差那些id
foreach ($one as $key => $val) {
$bool = false;
foreach ($two as $k => $v) {
if ($bool = ($val == $v)) {
break;
}
}
if (!$bool) {
$diff[$key] = $val;
}
}
if (!empty($diff)) {
$different = $diff;
} else {
$different = '';
}
$differentt = array_column($different,"goods_id");
$ids = implode(",",$differentt);
// 把相差的id拿到yixiu这张表 去查
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, "http://118.24.209.125/appApi/opencart_wx45_all.php?datas=$ids");// CURLOPT_RETURNTRANSFER 设置是否有返回值
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);//执行完以后的返回值
$response = curl_exec($curl);//释放curl
curl_close($curl);
$rjson = json_decode($response, true);
$finish = $rjson['data'];
//将查出来的数据插入opencart-wx45这个数据库中
$this->model_transfer_transfer->updata($finish);
$this->response->addHeader('Content-Type: application/json');
$this->response->setOutput(json_encode(array(
'result' => 1,
'msg' => 'successful',
'data' => '数据迁入成功',
)));
// sleep($interval);//等待时间,进行下一次操作。
// } while (true);
}
}