logic = $logic;
}
public function keyword_save(Request $request){
$sync_time = strtotime(date('Y-01-01 00:00:00',time()));
$next_sync_time = strtotime(date('Y-01-01 00:00:00',time()));
$id = $request->input('id');
$status = $request->input('status');
if($status=='1'){
/**
*
* UPDATE scn_project_keyword set sync_time='1640966400' where project_id=889;
UPDATE scn_project set sync_time='1640966400' where id=889;
UPDATE scn_project set next_sync_time='1640966400' where id=889;
*/
$rankConnection = DB::connection('rank');
$re=$rankConnection->table('project')->where(['id' => $id])->update([
'sync_time' => $sync_time,
'next_sync_time' => $next_sync_time,
]);
$re1=$rankConnection->table('project_keyword')->where(['project_id' => $id])->update([
'sync_time' => $sync_time,
]);
return response()->json(['message' => '操作成功','code'=>200]);
}else if($status=='2'){
$ids = $request->input('ids');
$rankConnection = DB::connection('rank');
$re=$rankConnection->table('project')->whereIn('id', $ids)->update([
'sync_time' => $sync_time,
'next_sync_time' => $next_sync_time,
]);
$re1=$rankConnection->table('project_keyword')->whereIn('project_id', $ids)->update([
'sync_time' => $sync_time,
]);
return response()->json(['message' => '操作成功','code'=>200]);
}
}
/**
* 关键词列表
* @param Request $request
* @return array|View\Factory|\Illuminate\Foundation\Application|JsonResponse|\Illuminate\View\View|mixed
*/
public function keyword_list(Request $request){
$keyword = $request->input('keyword');
$sortName = $request->input('sortName');
$sortOrder = $request->input('sortOrder');
if($sortName=='time'){
$sortName='sync_time';
}
if($sortName=='next_time'){
$sortName='next_sync_time';
}
if($sortName=='number_title'){
$sortName='number';
}
if($keyword){
$condition1[] = ['domain', 'like', '%' . $keyword . '%'];
$condition[] = ['name', 'like', '%' . $keyword . '%'];
}
if (!$request->ajax()) {
return view('admin/site/keyword_list', [
]);
}
$rankConnection = DB::connection('rank');
$records = $rankConnection->table('project')
->where('allow_googlerank','=','1')
->where('webmaster_domain','!=',' ')
->where($condition ?? [])
->orWhere($condition1 ?? [])
->orderBy($sortName,$sortOrder)
->paginate($request->input('pageSize') ?? TABLE_PAGE_SIZE);
foreach($records as $key => $value){
$site_info = Site::query()->where('old_id','=',$value->id)->first();
if(!empty($site_info->status)){
if($site_info->status=='1'){
$value->project_status_text = '建站期';
}else if($site_info->status=='2'){
$value->project_status_text = '实施期';
}else if($site_info->status=='3'){
$value->project_status_text = '服务期';
}else if($site_info->status=='4'){
$value->project_status_text = '建站期暂停';
}else if($site_info->status=='7'){
$value->project_status_text = '已终止';
}else if($site_info->status=='8'){
$value->project_status_text = '实施期暂停';
}else if($site_info->status=='9'){
$value->project_status_text = '网站续费维护';
}else if($site_info->status=='10'){
$value->project_status_text = '未续费';
}else {
$value->project_status_text = '未知';
}
}else{
$value->project_status_text = '未知';
}
if($value->number=='1'){
$value->number_title = '排名系统【1】';
}else if($value->number=='2'){
$value->number_title = '排名系统【2】';
}else if($value->number=='3'){
$value->number_title = '排名系统【3】';
}else if($value->number=='4'){
$value->number_title = '排名系统【4】';
}else {
$value->number_title = '未知';
}
if($value->next_sync_time!='0' && !empty($value->next_sync_time)){
$value->next_time = date('Y-m-d H:i:s',$value->next_sync_time);
}else{
$value->next_time = '';
}
if($value->sync_time!='0' && !empty($value->sync_time)){
$value->time = date('Y-m-d H:i:s',$value->sync_time);
}else{
$value->time = '';
}
if(!empty($site_info->status)){
$value->site_id=$site_info->id;
}else{
$value->site_id='';
}
}
$items = $records->items();
return response()->json([
'rows' => $items,
'total' => $records->total(),
]);
}
/**
* 关键词
*/
public function keyword(Request $request, $id)
{
if (!$request->ajax()) {
return view('admin/site/keyword', [
'siteId'=>$id
]);
}
$site_info = Site::query()->where('id','=',$id)->first();
$old_id=$site_info->old_id;
$rankConnection = DB::connection('rank');
$records = $rankConnection->table('project_keyword')->where(['project_id' =>$old_id])
->where('allow_googlerank','=','1')
->orderBy('sync_time')
->paginate($request->input('pageSize') ?? TABLE_PAGE_SIZE);
foreach($records as $key => $value){
$project_info = $rankConnection->table('project')->where(['id' =>$old_id])->first();
$value->project_name = $project_info->name;
if($site_info->status=='1'){
$value->project_status_text = '建站期';
}else if($site_info->status=='2'){
$value->project_status_text = '实施期';
}else if($site_info->status=='3'){
$value->project_status_text = '服务期';
}else if($site_info->status=='4'){
$value->project_status_text = '建站期暂停';
}else if($site_info->status=='7'){
$value->project_status_text = '已终止';
}else if($site_info->status=='8'){
$value->project_status_text = '实施期暂停';
}else if($site_info->status=='9'){
$value->project_status_text = '网站续费维护';
}else if($site_info->status=='10'){
$value->project_status_text = '未续费';
}else {
$value->project_status_text = '未知';
}
//$value->project_status_text = $project_info->status_text;
$value->next_time = date('Y-m-d H:i:s',$project_info->next_sync_time);
$value->time = date('Y-m-d H:i:s',$value->sync_time);
if($project_info->number=='1'){
$value->number_title = '排名系统【1】';
}else if($project_info->number=='2'){
$value->number_title = '排名系统【2】';
}else if($project_info->number=='3'){
$value->number_title = '排名系统【3】';
}else if($project_info->number=='4'){
$value->number_title = '排名系统【4】';
}else {
$value->number_title = '未知';
}
}
$items = $records->items();
return response()->json([
'rows' => $items,
'total' => $records->total(),
'siteId'=>$id
]);
}
/**********************上线后检查***************************************/
public function overview_inspect(Request $request, $id,$type)
{
$site = Site::query()->where('id', $id)->first();
$url = 'https://' . $site->domain;
$jump_url = 'https://www.' . $site->domain;
if (!$request->ajax()) {
$site = Site::query()->where('id', $id)->first();
if (!$site) {
return view('admin/site/tips', [
'tips' => '站点信息不存在',
'siteId' => $id
]);
} else if ($site->status != '2') {
return view('admin/site/tips', [
'tips' => '该项目不在实施期',
'siteId' => $id
]);
} else if (empty($site->domain)) {
return view('admin/site/tips', [
'tips' => '未绑定域名',
'siteId' => $id
]);
}
}
if ($type == '1') {
return view('admin/site/overview_inspect', [
'tips' => '在展示信息前请点击下方链接，确认网站能开打，避免因为未翻墙原因造成数据错误。',
'siteId' => $id,
'type' => $type,
'url' => 'https://' . $site->domain,
]);
}else if($type=='2'){
$view = 'admin/site/overview_inspect';
return view($view, [
'siteId' => $id,
'site'=>$site,
'type' => $type,
'jump_url'=>$jump_url
]);
} else if($type=='3'){////获取域名是否做了301跳转
try {
$header_info1 = get_headers($url);
if ($header_info1[0] == 'HTTP/1.1 301 Moved Permanently') {
$jump_status = '跳转成功,做了301跳转';
$jump_status_status = '1';
} else {
$jump_status = '跳转成功,未做301跳转';
$jump_status_status = '2';
}
} catch (\Throwable $throwable) {
$jump_status = '跳转不成功';
$jump_status_status = '3';
}
$data=[
'jump_status'=>$jump_status,
'jump_status_status'=>$jump_status_status
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='4'){//获取robots.txt内容
try {
$result = file_get_contents('https://www.'.$site->domain.'/robots.txt');
$robots_status = [
'robots1'=>$this->rotbots_content($result,'Sitemap: https://www.'.$site->domain.'/sitemap.xml'),
'robots2'=>$this->rotbots_content($result,'User-agent: *'),
'robots3'=>$this->rotbots_content($result,'Disallow: /basic/*'),
'robots4'=>$this->rotbots_content($result,'Disallow: /search-result-products.html'),
'robots5'=>$this->rotbots_content($result,'Disallow: /search-result-others.html'),
'robots6'=>$this->rotbots_content($result,'Disallow: /404.html'),
'robots7'=>$this->rotbots_content($result,'Disallow: /submission-successful.html'),
'robots8'=>$this->rotbots_content($result,'Disallow: /taggg.html')
];
} catch (\Throwable $throwable) {
$robots_status = [
'robots1'=>1,
'robots2'=>1,
'robots3'=>1,
'robots4'=>1,
'robots5'=>1,
'robots6'=>1,
'robots7'=>1,
'robots8'=>1
];
}
return response()->json(['message' => '查询成功','data'=>$robots_status], 200);
}else if($type=='5'){ //sitemap.xml管理
$url_list = '';
$is_no_https='1';
$is_repeat = '1';
$is_130='1';
$is_basic ='1';
$basic_text='';
try {
$xml = simplexml_load_file('https://www.'.$site->domain.'/sitemap.xml');
foreach ($xml->children() as $child){
//echo $child->loc."
";
//把所有链接放到一个逗号分割字符串里，用于判断是否重复
$url_list.=$child->loc.',';
//是否包含HTTP
if(strpos($child->loc,'http://') !== false){
$is_no_https='1';
}else{
$is_no_https='2';
}
if(strlen($child->loc)>130){
$is_130='2';
}
}
//判断是否有重复链接
$url_list_array = explode(',', $url_list);
if (count($url_list_array) != count(array_unique($url_list_array))) {
$is_repeat='2';
}
} catch (\Throwable $throwable) {
}
//sitemap.xml中是否有basic页面
/********************************/
$config = [
'connection_name' => sprintf('connection_name_%s', $id),
'host' => $site->server->server_ip,
'port' => '3306',
'database' => $site->database,
'username' => $site->server->mysql_user_name,
'password' => $site->server->mysql_passwd,
];
config_connection($config);
$connection = DB::connection($config['connection_name']);
$cacheKey = 'socialPublish_' . $site->id;
try {
if (!Cache::has($cacheKey)) {
$orders = $connection
->table('content')
->whereIn('tpl_id', [32, 95])
->get();
foreach ($orders as $value) {
if ($value->childs_num == 0) {
$value->url = '/' . $value->uri . '.html';
} else {
$value->url = '/' . $value->uri . '/';
}
if (strpos($url_list, $value->url) !== false) {
$is_basic = '2';
$basic_text.=''.$url.$value->url.'
';
}
}
}
}catch (\Throwable $throwable) {
}
/********************************/
$data=[
'is_no_https'=>$is_no_https,
'is_repeat'=>$is_repeat,
'is_130'=>$is_130,
'is_basic'=>$is_basic,
'basic_text'=>$basic_text
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='6'){
//引擎力后台域名，建站后台站点域名是否一致
$server = $site->server;
try {
Ssh::factory($server->server_ip, $server->server_user_name, $server->server_passwd);
} catch (\Throwable $throwable) {
return response()->json(['message' => '用户名密码验证失败'], 400);
}
$targetBaseDir = $site->code_dir ? sprintf('%s/wwwroot/', $site->code_dir)
: sprintf('/repo/%s/wwwroot/', $site->domain);
if (!Ssh::dir_exists($targetBaseDir)) {
return response()->json(['message' => '站点服务器目录不存在'], 400);
}
//查询建站后台域名
$is_domain='1';
$targetBaseDir1 = $site->code_dir ? sprintf('%s/appdata/conf/', $site->code_dir)
: sprintf('/repo/%s/appdata/conf/', $site->domain);
if (!Ssh::dir_exists($targetBaseDir1)) {
return response()->json(['message' => '站点服务器目录不存在'], 400);
}
$dir_msg = 'cat '.$targetBaseDir1.'setting.conf.php';
$domain_content = Ssh::exec($dir_msg);
$domain_content=str_replace(' ','',$domain_content);
//拼接字符串
$domain_url = '\'domain\'=>\''.$site->domain.'\'';
if(strpos($domain_content,$domain_url) !== false){
$is_domain='2';
}else{
$is_domain='1';
}
$data=[
'is_domain'=>$is_domain,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='7'){
//根目录中是否有最新的google和bing文件
$server = $site->server;
try {
Ssh::factory($server->server_ip, $server->server_user_name, $server->server_passwd);
} catch (\Throwable $throwable) {
return response()->json(['message' => '用户名密码验证失败'], 400);
}
$targetBaseDir = $site->code_dir ? sprintf('%s/wwwroot/', $site->code_dir)
: sprintf('/repo/%s/wwwroot/', $site->domain);
if (!Ssh::dir_exists($targetBaseDir)) {
return response()->json(['message' => '站点服务器目录不存在'], 400);
}
$is_google='1';
$is_bing='1';
$result_host_list = Ssh::exec('ls -l '.$targetBaseDir);
if(strpos($result_host_list,'google') !== false){
$is_google ='2';
}
if(strpos($result_host_list,'BingSiteAuth.xml') !== false){
$is_bing ='2';
}
$data=[
'is_google'=>$is_google,
'is_bing'=>$is_bing,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='8'){
//引擎力后台服务器所在地，api地址和webmaster域名是否已填写
$is_webmaster_domain='1';
$is_api_url='1';
$is_server_id='1';
if(!empty($site->webmaster_domain)){
$is_webmaster_domain='2';
}
if(!empty($site->api_url)){
$is_api_url='2';
}
if(!empty($site->server_id)){
$is_server_id='2';
}
$data=[
'is_webmaster_domain'=>$is_webmaster_domain,
'is_api_url'=>$is_api_url,
'is_server_id'=>$is_server_id,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='9'){
$is_keyword ='1';
$rankConnection = DB::connection('rank');
$old = $rankConnection->table('project')->where(['id' => $site->old_id])->select(['allow_googlerank', 'number', 'interval_time'])->first();
$keywordCount = $rankConnection->table('project_keyword')->where(['project_id' => $site->old_id])->count();
if($keywordCount >'0'){
$is_keyword='2';
}
$data=[
'is_keyword'=>$is_keyword,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='10'){
//"项目概况-重点优化"中是否上传，是否全部已优化
$is_key_optimization='1';
$optimizePageIds = SiteOptimizePage::query()->where(['site_id' => $id])->pluck('id')->count();
$optimizePagelist = SiteOptimizePage::query()->where(['site_id' => $id])->pluck('is_optimize')->toArray();
if($optimizePageIds >'0'){
$is_key_optimization='2';
}
//是否全部优化
$is_optimization='1';
if(isset($optimizePagelist)){
foreach($optimizePagelist as $key=>$value){
if ($value=='0') {
$is_optimization='1';
break;
}else{
$is_optimization='2';
}
}
}
$data=[
'is_key_optimization'=>$is_key_optimization,
'is_optimization'=>$is_optimization
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}
else if($type=='11'){
//“建站流程-建站流程2.0”是否已填写完成
$optimizePagelist = SiteOptimizePage::query()->where(['site_id' => $id])->pluck('is_optimize')->toArray();
$is_web_status='1';
$is_web_status_list = ProjectFlowMemo::query()->where(['site_id' => $id])->pluck('status')->toArray();
if(isset($is_web_status_list)){
foreach($is_web_status_list as $key=>$value){
if ($value=='0') {
$is_web_status='1';
break;
}else{
$is_web_status='2';
}
}
}
$data=[
'is_web_status'=>$is_web_status,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='12'){
//--------------------------源代码中是否为-----------------------------------------------------------------
//--------------------------源代码中是否每个页面都有 -----------------------------------------------------------------
$meta_value = '';
$link_value = '';
$meta_value1 = '';
$link_value1 = '';
$is_meta_value='1';
$is_link_value='1';
$meta_value_new='';
$link_value_new = '';
/********************************/
$config = [
'connection_name' => sprintf('connection_name_%s', $id),
'host' => $site->server->server_ip,
'port' => '3306',
'database' => $site->database,
'username' => $site->server->mysql_user_name,
'password' => $site->server->mysql_passwd,
];
config_connection($config);
$connection = DB::connection($config['connection_name']);
$cacheKey = 'socialPublish_' . $site->id;
try {
if (!Cache::has($cacheKey)) {
$header_count = $connection
->table('content_template_chunk')
->where('name', 'header')
->first();
$header_content = str_replace(' ','',$header_count->html);
if(strpos($header_content,$meta_value_new) !== false){
$is_meta_value='2';
}else{
$is_meta_value='1';
}
if(strpos($header_content,$link_value_new) !== false){
$is_link_value='2';
}else{
$is_link_value='1';
}
}
}catch (\Throwable $throwable) {
}
$data=[
'is_meta_value'=>$is_meta_value,
'is_link_value'=>$is_link_value,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='13'){
//站内，出站是否有404链接
$is_404='1';
$ids = NotFound::get404List(4);
if(!isset($ids)){
$is_404='2';
}
$data=[
'is_404'=>$is_404,
];
return response()->json(['message' => '查询成功','data'=>$data], 200);
}else if($type=='14') {
//--------------------------源代码中是否为-----------------------------------------------------------------
//--------------------------源代码中是否每个页面都有 -----------------------------------------------------------------
$meta_value = '';
$link_value = '';
$meta_value1 = '';
$link_value1 = '';
$is_meta_value = '1';
$is_link_value = '1';
$meta_value_new = '';
$link_value_new = '';
/********************************/
$config = [
'connection_name' => sprintf('connection_name_%s', $id),
'host' => $site->server->server_ip,
'port' => '3306',
'database' => $site->database,
'username' => $site->server->mysql_user_name,
'password' => $site->server->mysql_passwd,
];
config_connection($config);
$connection = DB::connection($config['connection_name']);
$cacheKey = 'socialPublish_' . $site->id;
//try {
if (!Cache::has($cacheKey)) {
$header_count = $connection
->table('content_template_chunk')
->where('name', 'header')
->first();
$header_content = str_replace(' ', '', $header_count->html);
//var_dump($header_content);
if (strpos($header_content, $meta_value_new) !== false) {
$is_meta_value = '2';
} else {
$is_meta_value = '1';
}
if (strpos($header_content, $link_value_new) !== false) {
$is_link_value = '2';
} else {
$is_link_value = '1';
}
}
//} catch (\Throwable $throwable) {
//}
$data = [
'is_meta_value' => $is_meta_value,
'is_link_value' => $is_link_value,
];
return response()->json(['message' => '查询成功', 'data' => $data], 200);
}
}
//查询xml里的数据
function link_xml($url,$xmla){
$xmla = rtrim($xmla, ",");
$hello = explode(',',$xmla);
for($index=0;$indexget_html($hello[$index]);
$link_value = '';
if($hello[$index] == 'https://www.'.$url.'/sitemap.html'){
$is_meta_value='2';
}else{
if(strpos($result_info,$link_value) !== false ){
$is_meta_value='2';
}else{
$is_meta_value='1';
//var_dump($hello[$index]);
return $is_meta_value;
}
}
}
return $is_meta_value;
}
function link_xml1($url,$xmla){
$xmla = rtrim($xmla, ",");
$hello = explode(',',$xmla);
for($index=0;$indexget_html($hello[$index]);
$link_value = '';
$link_value = '';
if($hello[$index] == 'https://www.'.$url.'/sitemap.html'){
$is_meta_value='2';
}else{
if(strpos($result_info,$link_value) !== false ){
$is_meta_value='2';
}else{
$is_meta_value='1';
//var_dump($hello[$index]);
return $is_meta_value;
}
}
}
return $is_meta_value;
}
function get_html($url){
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true );
curl_setopt($ch, CURLOPT_HTTPHEADER,
array(
'pragma: no-cache',
'cache-control: no-cache',
'sec-ch-ua: " Not A;Brand";v="99", "Chromium";v="96", "Google Chrome";v="96"',
'accept: application/json, text/plain, */*',
'content-type: application/json',
'sec-ch-ua-mobile: ?0',
'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.93 Safari/537.36',
'sec-ch-ua-platform: "Windows"',
'sec-fetch-site: same-origin',
'sec-fetch-mode: cors',
'sec-fetch-dest: empty',
'accept-language: zh-CN,zh;q=0.9',
));
// This is what solved the issue (Accepting gzip encoding)
curl_setopt($ch, CURLOPT_ENCODING, "gzip,deflate");
$response = curl_exec($ch);
curl_close($ch);
return $response;
}
function rotbots_content($result,$key){
if(strpos($result,$key) !== false){
return 2;
}else{
return 1;
}
}
function link_list($config,$url,$text){
$ordersa = DB::connection($config['connection_name'])
->table('content')
->WhereNotIn('alias', ['home','sitemap','404'])
->get();
foreach ($ordersa as $value) {
if ($value->childs_num == 0) {
$value->url = 'https://www.'.$url.'/' . $value->uri . '.html';
} else {
$value->url = 'https://www.'.$url.'/' . $value->uri . '/';
}
$meta_value = '';
$result_info = file_get_contents($value->url);
if(strpos($result_info,$meta_value) !== false){
$is_meta_value='2';
}else{
$is_meta_value='1';
//var_dump($value->id);
//var_dump($value->title);
return $is_meta_value;
}
}
return $is_meta_value;
}
function link_list1($config,$url,$text){
$ordersa = DB::connection($config['connection_name'])
->table('content')
->WhereNotIn('alias', ['home','sitemap','404'])
->get();
foreach ($ordersa as $value) {
if ($value->childs_num == 0) {
$value->url = 'https://www.'.$url.'/' . $value->uri . '.html';
} else {
$value->url = 'https://www.'.$url.'/' . $value->uri . '/';
}
$link_value = '';
$result_info = file_get_contents($value->url);
if(strpos($result_info,$link_value) !== false){
$is_meta_value='2';
}else{
$is_meta_value='1';
var_dump($value->id);
var_dump($value->title);
return $is_meta_value;
}
}
return $is_meta_value;
}
/**********************上线后检查***************************************/
//站点渲染页面及列表
public function index(Request $request)
{
$user = auth()->user();
if (!$request->ajax()) {
$userList = User::query()->where(['status' => 1])
->whereIn('role_id', [14, 27, 34, 32, 29, 15, 7, 6, 25, 26, 2, 1])
->select(['id', 'nickname', 'role_id'])
->get();
$businessList = Business::query()->pluck('title', 'id');
$month = date('m');
$lastMonth = date('m', strtotime('last month'));
return view('admin/site/index', [
'userList' => $userList,
'businessList' => $businessList,
'role_id' => $user->role_id,
'is_propaganda' => 0,//品宣只显示建站期和服务期
'month' => $month,
'lastMonth' => $lastMonth
]);
}
list($sites, $items, $sortName, $sortOrder) = $this->indexBuild($request, $user);
$items = $this->sitePublishList($items);
list($nowListReportMap, $listReportMapResult, $listReportMapResult1) = $this->getInquireList();
list($nowtMonthKeywords, $keywordDropResults, $keywordDropResults1) = $this->getTop10List();
list($nowtMonthFlow, $clicksDropResults, $clicksDropResults1) = $this->getFlowList();
list($pcSpeedMeasurement, $mobileSpeedMeasurement) = $this->getSpeedMeasurementList();
$articleNoteList = ArticleNote::query()
->selectRaw('site_id,count(*) as count')
->groupBy('site_id')
->pluck('count', 'site_id')
->toArray() ?? [];
array_walk($items, function ($item) use (
&$nowtMonthKeywords,
&$nowListReportMap, &$listReportMapResult, &$listReportMapResult1,
&$keywordDropResults, &$keywordDropResults1, &$clicksDropResults,
&$clicksDropResults1, &$masterDropResult, &$pcSpeedMeasurement,
&$mobileSpeedMeasurement, &$articleNoteList
) {
$item->identify = base64_encode($item->id);
$item->managers_title = implode('-', $item->users->where('role_id', Role::TYPE_MANAGER)->pluck('nickname')->toArray());
$item->server_title = implode('-', $item->users->where('role_id', Role::TYPE_SERVER)->pluck('nickname')->toArray());
$item->propaganda = implode('-', $item->users->where('role_id', Role::TYPE_SOFT_TEXT_SEARCH)->pluck('nickname')->toArray());
$item->statusTitle = Site::STATUS_MAP[$item->status] ?? '';
$item->top10 = $item->old_id ? ($nowtMonthKeywords[$item->old_id] ?? '-') : '未关联';
$item->traffic = $item->old_id ? ($nowListReportMap[$item->old_id]->traffic ?? '-') : '未关联';
$item->inquire = $item->old_id ? ($nowListReportMap[$item->old_id]->inquire ?? '-') : '未关联';
$item->is_google_bid = in_array(Contract::GOOGLE_BID, $item->contract_ids ?? []) ? 1 : 0;
$item->listReportMapResult = $listReportMapResult[$item->old_id] ?? '';
$item->listReportMapResult1 = $listReportMapResult1[$item->old_id] ?? '';
$item->keywordDropResults = $keywordDropResults[$item->old_id] ?? '';
$item->keywordDropResults1 = $keywordDropResults1[$item->old_id] ?? '';
$item->clicksDropResults = $clicksDropResults[$item->old_id] ?? '';
$item->clicksDropResults1 = $clicksDropResults1[$item->old_id] ?? '';
//$item->masterDropResult = $masterDropResult[$item->id] ?? '';
$item->pcSpeedMeasurement = $pcSpeedMeasurement[$item->old_id] ?? '-';
$item->mobileSpeedMeasurement = $mobileSpeedMeasurement[$item->old_id] ?? '-';
$item->articleNote = $articleNoteList[$item->id] ?? 0;
$item->order_at = substr($item->order_at, 0, 10);
$item->reach_at = substr($item->reach_at, 0, 10);
$item->online_at = substr($item->online_at, 0, 10);
});
$records = collect($items);
if ($sortName == 'monthOfCompletionNum') {
$sortName = 'monthOfCompletionNumTime';
}
if (in_array($sortName, ['traffic', 'inquire', 'top10', 'pcSpeedMeasurement', 'mobileSpeedMeasurement', 'monthOfCompletionNumTime', 'articleNote'])) {
$descending = strtolower($sortOrder) == 'asc' ? false : true;
$records = $records->sortBy(function ($item, $key) use ($sortName, $descending) {
return intval($item[$sortName]);
}, SORT_REGULAR, $descending)->values();
}
return response()->json([
'rows' => $records,
'total' => $sites->total()
]);
}
public function indexBuild($request, $user, $isExport = false)
{
$site = Site::query();
$keyword = $request->input('keyword');
$coreProduct = $request->input('coreProduct');
$isPropaganda = $request->input('is_propaganda');
$projectType = $request->input('projectType');
if ($projectType) {
$site->where('site_type', $projectType);
}
if ($status = $request->input('status')) {
$site->where('status', $status);
} else {
if (in_array($user->role_id, [15, 17]) && !$keyword) {
//查找任务管理[只显示建站期和服务期]==项目列表[品宣只显示建站期和服务期]
$site->whereIn('status', [2, 3]);
}
if ($isPropaganda == 1 && !$keyword) {
//查找任务管理[只显示建站期和服务期]==项目列表[品宣只显示建站期和服务期]
$site->whereIn('status', [2, 3]);
}
if (!in_array($user->role_id, [15, 17]) && !$keyword) {
$site->whereIn('status', [1, 2, 3, 4, 5, 6, 8, 9, 10]);
}
}
if ($request->input('bid_status') == 'on') {
$site->where('bid_status', 1);
}
if ($request->input('feedback_status') == 'on') {
$feedbackSiteList = Article::query()->select('site_id')
->where('be_applicable', 0)
->groupBy('site_id')->pluck('site_id')
->toArray() ?? [];
$site->whereIn('id', $feedbackSiteList);
}
if ($request->input('customer_review') == 'on') {
$feedbackSiteList = SiteInfo::query()->select('site_id')
->where('article_custom_audit', 1)
->pluck('site_id');
$site->whereIn('id', $feedbackSiteList);
}
$layoutKeyword = $request->input('layoutKeyword');
if (!empty($layoutKeyword)) {
$sites = SiteOptimizePage::query()->where('keyword', 'like', $layoutKeyword . '%')->pluck('site_id');
$site->whereIn('id', $sites);
}
$businessId = $request->input('businessId');
$builder = $site->withCount(['articles' => function (Builder $query) {
$query->where([
['publish_at', '>', date('Y-m-01 00:00:00')],
['publish_at', '<', date('Y-m-d 00:00:00', strtotime('first day of next month'))],
]);
}, 'articles as articles_sum' => function (Builder $query) {
$query->where('be_applicable', 1);
}, 'articles as pendingUpgrade' => function (Builder $query) {
$query->whereNull('publish_at');
}, 'articles as published' => function (Builder $query) {
$query->whereNotNull('publish_at');
}, 'articles as thisMonthUpgrade' => function (Builder $query) {
$query->whereBetween('publish_at', [date('Y-m-01 00:00:00'), date('Y-m-t 23:59:59')]);
}, 'linkDetails' => function (Builder $query) {
$query->where([
['enable', '=', 1],
['status', '=', 5],
['created_at', '>', date('Y-m-01 00:00:00')],
['created_at', '<', date('Y-m-d 00:00:00', strtotime('first day of next month'))],
]);
}])->with(['users'])->scopes(['user'])->where(function (Builder $builder) use ($keyword, $businessId, $coreProduct) {
if ($keyword) {
$builder->whereIn('status', [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]);
$builder->where('domain', 'like', '%' . $keyword . '%')
->orWhere('cn_title', 'like', '%' . $keyword . '%');
}
if ($businessId) {
$builder->where('business_id', $businessId);
}
if ($coreProduct) {
$builder->where('core_product', 'like', '%' . $coreProduct . '%');
}
});
$sortName = $request->input('sortName');
$sortOrder = $request->input('sortOrder');
if ($sortName == 'statusTitle') {
$builder->orderBy('status', $sortOrder);
}
if ($sortName == 'order_at') {
$builder->orderBy('order_at', $sortOrder);
}
if ($sortName == 'online_date') {
$builder->orderBy('online_at', $sortOrder);
}
if ($sortName == 'reach_at') {
$builder->orderBy('reach_at', $sortOrder);
}
if ($isExport) {
$sites = '';
$items = $builder->orderByDesc('id')->get();
} else {
$sites = $builder->orderByDesc('id')->paginate($request->input('pageSize') ?? TABLE_PAGE_SIZE);
$items = $sites->items();
}
return [$sites, $items, $sortName, $sortOrder];
}
public function sitePublishList($items)
{
foreach ($items as $key => $item) {
if (!empty($item->enterprise_nature)) {
$list = explode(',', $item->enterprise_nature);
foreach ($list as $value) {
if ($value == 1) {
$items[$key]->the500Strongest = 1;
}
if ($value == 2) {
$items[$key]->listedCompany = 1;
}
if ($value == 3) {
$items[$key]->stateEnterprises = 1;
}
if ($value == 4) {
$items[$key]->leadingEnterprise = 1;
}
}
}
if (empty($item->article_goal)) {
$item->article_goal = 0;
}
$c = false;
if ($item->published > 0) {
/*年月日Y-M-D，假设, 待更新数=A，每月更新数=B，完成月份至显示为y-m
最新显示发布月：Y-M（如上图最新发布月 Y-M为2021-2）
A>= B时, A/B=C（C只取整数，如2.5取2），则m=M+C，完成月份至显示为 Y-(M+C)
如果M+C>12，则 显示为 (Y+1)- [(M+C)-12] , 例如 最新发布月：2021-11，M+C=2，则完成月份至 显示为 2022-1*/
$m = Article::query()->where('site_id', $item->id)
->whereNotNull('publish_at')
->orderBy('publish_at', 'desc')
->value('publish_at');
if ($item->pendingUpgrade > $item->articles_updates_per_month) {
if ($item->pendingUpgrade > 0 && $item->articles_updates_per_month > 0) {
$c = floor($item->pendingUpgrade / $item->articles_updates_per_month);
if (!empty($m)) {
$c = date("Y-m", strtotime("first day of +{$c} month", strtotime($m)));
}
}
}
// 0<=Aarticles_updates_per_month > $item->pendingUpgrade && $item->articles_updates_per_month >= 0) {
if (!empty($m)) {
$c = date('Y-m', strtotime($m));
} else {
$c = date('Y-m');
}
}
} else {
/*年月日Y-M-D，假设, 待更新数=A，每月更新数=B，完成月份至显示为y-m
A>=B时, A/B=C（C只取整数，如2.5取2），则m=本月份-1+C
0<=ApendingUpgrade > $item->articles_updates_per_month) {
if ($item->pendingUpgrade > 0 && $item->articles_updates_per_month > 0) {
$c = date('Y-m', strtotime("last day of -1 month", strtotime(date("Y-m"))));
$dateNum = floor($item->pendingUpgrade / $item->articles_updates_per_month);
$c = date("Y-m", strtotime("first day of +{$dateNum} month", strtotime($c)));
}
}
if ($item->articles_updates_per_month > $item->pendingUpgrade && $item->articles_updates_per_month >= 0) {
$c = false;
}
}
if (!$c) {
$item->monthOfCompletionNum = '-';
$item->monthOfCompletionNumTime = '-';
} else {
$item->monthOfCompletionNum = $c;
$item->monthOfCompletionNumTime = strtotime($c);
}
$item->articles_updates_per_month = $item->articles_updates_per_month + 1;
$item->over = $item->article_goal - $item->articles_sum;
}
return $items;
}
public function getInquireList()
{
if (!Cache::has(CacheConstant::NOW_MONTH_INQUIRE_CACHE_KEY)) {
$nowListReportMap = DB::connection('rank')
->table('project_listreport')
->where(['ym' => date('Ym', strtotime('first day of -1 month'))])
->get()->keyBy('project_id')
->toArray();
Cache::put(CacheConstant::NOW_MONTH_INQUIRE_CACHE_KEY, $nowListReportMap, mt_rand(54000, 57600));
}
$nowListReportMap = Cache::get(CacheConstant::NOW_MONTH_INQUIRE_CACHE_KEY) ?? [];
if (!Cache::has(CacheConstant::LAST_MONTH_INQUIRE_CACHE_KEY)) {
$lastListReportMap = DB::connection('rank')
->table('project_listreport')
->where(['ym' => date('Ym', strtotime('first day of -2 month'))])
->get()->keyBy('project_id')
->toArray();
Cache::put(CacheConstant::LAST_MONTH_INQUIRE_CACHE_KEY, $lastListReportMap, mt_rand(54000, 57600));
}
$lastListReportMap = Cache::get(CacheConstant::LAST_MONTH_INQUIRE_CACHE_KEY) ?? [];
$listReportMapResult = [];
$listReportMapResult1 = [];
foreach ($lastListReportMap as $inx => $val) {
$lastOne = $nowListReportMap[$inx] ?? null;
if (empty($lastOne)) {
continue;
}
$lessVal = $val->inquire - $lastOne->inquire;
if ($lessVal > 0) {
$listReportMapResult[$inx] = $lessVal;
} else {
$listReportMapResult1[$inx] = abs($lessVal);
}
}
return [$nowListReportMap, $listReportMapResult, $listReportMapResult1];
}
public function getTop10List()
{
if (!Cache::has(CacheConstant::NOW_MONTH_KEY_WORDS_CACHE_KEY)) {
$maxIdList = DB::connection('rank')
->table('project_history')
->selectRaw('max(id) as max_id')->where([
['create_time', '>', strtotime(date('Y-m-01'))],
['create_time', '<', strtotime(date('Y-m-t 23:59:59'))],
])->groupBy('project_id')->pluck('max_id')->toArray();
$nowtMonthKeywords = DB::connection('rank')
->table('project_history')
->select('top10', 'project_id')->whereIn('id', $maxIdList)
->pluck('top10', 'project_id')->toArray();
Cache::put(CacheConstant::NOW_MONTH_KEY_WORDS_CACHE_KEY, $nowtMonthKeywords, mt_rand(54000, 57600));
}
$nowtMonthKeywords = Cache::get(CacheConstant::NOW_MONTH_KEY_WORDS_CACHE_KEY) ?? [];
if (!Cache::has(CacheConstant::LAST_MONTH_KEY_WORDS_CACHE_KEY)) {
$maxIdList = DB::connection('rank')
->table('project_history')
->selectRaw('max(id) as max_id')->where([
['create_time', '>', strtotime(date('Y-m-01', strtotime('first day of -1 month')))],
['create_time', '<', strtotime(date('Y-m-t 23:59:59', strtotime('first day of -1 month')))],
])->groupBy('project_id')->pluck('max_id')->toArray();
$lastMonthKeywords = DB::connection('rank')
->table('project_history')
->select('top10', 'project_id')->whereIn('id', $maxIdList)
->pluck('top10', 'project_id')->toArray();
Cache::put(CacheConstant::LAST_MONTH_KEY_WORDS_CACHE_KEY, $lastMonthKeywords, mt_rand(54000, 57600));
}
$lastMonthKeywords = Cache::get(CacheConstant::LAST_MONTH_KEY_WORDS_CACHE_KEY) ?? [];
$keywordDropResults = [];
$keywordDropResults1 = [];
foreach ($nowtMonthKeywords as $inx => $val) {
$nowTop10 = $lastMonthKeywords[$inx] ?? 0;
if ($nowTop10 > 0) {
$lessVal = $val - $nowTop10;
if ($lessVal > 0) {
$keywordDropResults1[$inx] = $lessVal;
} else {
$keywordDropResults[$inx] = abs($lessVal);
}
}
}
return [$nowtMonthKeywords, $keywordDropResults, $keywordDropResults1];
}
public function getFlowList()
{
if (!Cache::has(CacheConstant::NOW_MONTH_FLOW_CACHE_KEY)) {
$nowtMonthFlow = DB::connection('rank')
->table('webmaster_effect')
->selectRaw('SUM(clicks) as clicks,project_id')
->where(['ym' => date('Ym', strtotime('first day of -1 month'))])
->groupBy('project_id')
->get()->keyBy('project_id')->toArray();
Cache::put(CacheConstant::NOW_MONTH_FLOW_CACHE_KEY, $nowtMonthFlow, mt_rand(54000, 57600));
}
$nowtMonthFlow = Cache::get(CacheConstant::NOW_MONTH_FLOW_CACHE_KEY);
if (!Cache::has(CacheConstant::LAST_MONTH_FLOW_CACHE_KEY)) {
$lastMonthFlow = DB::connection('rank')
->table('webmaster_effect')
->selectRaw('SUM(clicks) as clicks,project_id')
->where(['ym' => date('Ym', strtotime('first day of -2 month'))])
->groupBy('project_id')
->get()->keyBy('project_id')->toArray();
Cache::put(CacheConstant::LAST_MONTH_FLOW_CACHE_KEY, $lastMonthFlow, mt_rand(54000, 57600));
}
$lastMonthFlow = Cache::get(CacheConstant::LAST_MONTH_FLOW_CACHE_KEY);
$clicksDropResults = [];
$clicksDropResults1 = [];
foreach ($lastMonthFlow as $inx => $val) {
$lastOne = $nowtMonthFlow[$inx] ?? null;
if (empty($lastOne)) {
continue;
}
$lessVal = $val->clicks - $lastOne->clicks;
if ($lessVal > 0) {
$clicksDropResults[$inx] = $lessVal;
} else {
$clicksDropResults1[$inx] = abs($lessVal);
}
}
return [$nowtMonthFlow, $clicksDropResults, $clicksDropResults1];
}
public function getSpeedMeasurementList()
{
$pcSpeedMeasurement = [];
$mobileSpeedMeasurement = [];
$speedMeasurementList = DB::table('app_speed_measurement_cache')->get();
foreach ($speedMeasurementList as $key => $value) {
$array = json_decode($value->cache, true);
if (!empty($array)) {
$pcSpeedMeasurementResult = $array['pc'];
$mobileSpeedMeasurementResult = $array['mobile'];
$oldId = str_replace('cache:app/Http/Controllers/SpeedMeasurementController/index:', '', $value->key);
$pcSpeedMeasurement[$oldId] = $pcSpeedMeasurementResult;
$mobileSpeedMeasurement[$oldId] = $mobileSpeedMeasurementResult;
}
}
return [$pcSpeedMeasurement, $mobileSpeedMeasurement];
}
public function indexExport(Request $request)
{
$user = auth()->user();
list($sites, $items, $sortName, $sortOrder) = $this->indexBuild($request, $user, true);
$items = $this->sitePublishList($items);
list($nowListReportMap, $listReportMapResult, $listReportMapResult1) = $this->getInquireList();
list($nowtMonthKeywords, $keywordDropResults, $keywordDropResults1) = $this->getTop10List();
list($pcSpeedMeasurement, $mobileSpeedMeasurement) = $this->getSpeedMeasurementList();
$list = [];
foreach ($items as $site) {
$list[] = [
'statusTitle' => Site::STATUS_MAP[$site->status] ?? '',
'cn_title' => $site->cn_title ?? '',
'domain' => $site->domain ?? '',
'pcSpeedMeasurement' => $pcSpeedMeasurement[$site->old_id] ?? '',
'mobileSpeedMeasurement' => $mobileSpeedMeasurement[$site->old_id] ?? '',
'traffic' => $nowListReportMap[$site->old_id]->traffic ?? '',
'top10' => $nowtMonthKeywords[$site->old_id] ?? '',
'inquire' => $nowListReportMap[$site->old_id]->inquire ?? '',
'articles_count' => $site->articles_count ?? '',
'link_details_count' => $site->link_details_count ?? '',
'order_at' => $site->order_at ?? '',
'server_title' => implode('-', $site->users->where('role_id', Role::TYPE_SERVER)->pluck('nickname')->toArray()),
'online_date' => $site->online_at ?? '',
'reach_at' => $site->reach_at ?? '',
];
}
array_unshift($list, ['项目状态', '项目过名称', '域名', 'pc端分数', '移动端分数', '月流量', '月排名', '询盘', '月软文', '月外链', '下单时间', '客服人员', '上线时间', '达标时间']);
return (new BasicExport($list))->download(sprintf('项目汇总%s.xls', date('YmdHis')));
}
//站点添加和修改
public function save(SiteSaveRequest $request, $id)
{
if (!$request->ajax()) {
if ($id > 0) {
$site = Site::query()->where(['id' => $id])->first();
$payment = SitePayment::query()->where(['site_id' => $id])->first();
}
$businesses = Business::query()->get();
return view('admin/site/save', [
'data' => $site ?? null,
'payment' => $payment ?? null,
'businesses' => $businesses,
'natures' => Site::NATURE_TYPE,
'contracts' => Contract::all()
]);
}
return $this->logic->updateOrCreate($request->validated(), $id);
}
//客户完善信息
public function customer(CustomerRequest $request, $id)
{
if (!$request->ajax()) {
$condition = ['site_id' => $id];
$view = 'admin/site/customer';
return view($view, [
'siteId' => $id,
'additionData' => SiteAddition::query()->where($condition)->first(),
'keywordData' => SiteInfo::query()->where($condition)->first(),
'stationData' => SiteStation::query()->where($condition)->first(),
'enterpriseData' => SiteEnterprise::query()->where($condition)->first(),
'marketerData' => SiteMarketer::query()->where($condition)->first(),
'snsData' => SiteSns::query()->where($condition)->first(),
'businesses' => Business::all(),
'natures' => Site::NATURE_TYPE
]);
}
return $this->logic->customerHandle($request->validated(), $request->input('act'), $request->input('source'), $id);
}
//针对客户界面 没有左边侧栏的
public function customerNoSide(CustomerRequest $request)
{
$siteId = $request->input('siteId');
if (!$siteId) {
$site = $this->hasUserOneSite();
if (!$site) {
return view('admin/errors/tips');
}
$siteId = $site->id;
}
if (!$request->ajax()) {
$condition = ['site_id' => $siteId];
$view = 'admin/site/customer_no_side';
return view($view, [
'siteId' => $siteId,
'additionData' => SiteAddition::query()->where($condition)->first(),
'keywordData' => SiteInfo::query()->where($condition)->first(),
'stationData' => SiteStation::query()->where($condition)->first(),
'enterpriseData' => SiteEnterprise::query()->where($condition)->first(),
'marketerData' => SiteMarketer::query()->where($condition)->first(),
'snsData' => SiteSns::query()->where($condition)->first(),
'businesses' => Business::all(),
'natures' => Site::NATURE_TYPE
]);
}
}
public function customerIdentify(Request $request)
{
$siteId = $request->input('siteId');
$str = $this->encrypt($siteId);
return response()->json(['data' => $str]);
}
//加密
protected function encrypt($siteId)
{
$info = [
'site_id' => $siteId,
'expire_time' => strtotime('+1 week')
];
$str = encodeStr(json_encode($info));
return $str . "." . md5($str . "customer_salt");
}
//解密
protected function decrypt($str)
{
$arr = explode('.', $str);
if (count($arr) != 2) {
return '失效链接';
}
if (md5($arr[0] . "customer_salt") != $arr[1]) {
return '失败链接';
}
return json_decode(decodeStr($arr[0]), true);
}
//客户信息中的连接
public function customerAlone(CustomerRequest $request)
{
$identify = $request->input('identify');
$info = $this->decrypt($identify);
if (!is_array($info)) {
return view('admin/site/customer_error', [
'message' => $info
]);
}
$siteId = $info['site_id'];
$expired_time = $info['expire_time'];
if ($expired_time < time()) {
return view('admin/site/customer_error', [
'message' => '链接失效'
]);
}
if (!$request->ajax()) {
$condition = ['site_id' => $siteId];
$view = 'admin/site/customer_alone';
return view($view, [
'siteId' => $siteId,
'additionData' => SiteAddition::query()->where($condition)->first(),
'keywordData' => SiteInfo::query()->where($condition)->first(),
'stationData' => SiteStation::query()->where($condition)->first(),
'enterpriseData' => SiteEnterprise::query()->where($condition)->first(),
'marketerData' => SiteMarketer::query()->where($condition)->first(),
'snsData' => SiteSns::query()->where($condition)->first(),
'businesses' => Business::all(),
'natures' => Site::NATURE_TYPE,
'identify' => $identify
]);
}
return $this->logic->customerHandle($request->validated(), $request->input('act'), $request->input('source'), $siteId);
}
//导出 SNS 社交资料
public function snsExport(Request $request)
{
$data = SiteSns::query()->where(['site_id' => $request->input('siteId')])->first();
if ($data) {
$records = [
[
'youtube',
'展示url地址',
$data->youtube_url
], [
'youtube',
'用户名（登入邮箱）',
$data->youtube_account
], [
'youtube',
'密码：',
$data->youtube_password
], [
'Facebook',
'个人页面展示url地址：',
$data->facebook_my_url,
], [
'Facebook',
'企业page展示url地址',
$data->facebook_url,
], [
'Facebook',
'用户名（登入邮箱）',
$data->facebook_account,
], [
'Facebook',
'密码：',
$data->facebook_password,
], [
'Twitter',
'展示url地址:',
$data->twitter_url,
], [
'Twitter',
'用户名（登入邮箱）',
$data->twitter_account,
], [
'Twitter',
'密码',
$data->twitter_password,
], [
'Linkedin',
'个人页面展示url地址',
$data->linkedin_my_url,
], [
'Linkedin',
'企业page展示url地址',
$data->linkedin_url,
], [
'Linkedin',
'用户名（登入邮箱）',
$data->linkedin_account，
], [
'Linkedin',
'密码',
$data->linkedin_password,
], [
'Pinterst',
'展示url地址:',
$data->pinterst_url,
], [
'Pinterst',
'用户名（登入邮箱',
$data->pinterst_account,
], [
'Pinterst',
'密码',
$data->pinterst_password,
]
];
} else {
$records = [];
}
array_unshift($records, ['社交类型', '概览', '详细']);
return (new BasicExport($records))->download(sprintf('sns信息%s.xls', date('YmdHis')));
}
//批量删除
public function batchDestroy(Request $request)
{
$ids = $request->input('ids');
$oldSiteIds = Site::query()->whereIn('id', $ids)->pluck('old_id')->filter()->toArray();
Site::destroy($ids);
//同步老rank平台的数据
$siteSync = new SiteSyncLogic();
$siteSync->delete($oldSiteIds);
return response()->json(['message' => '操作成功']);
}
//填写款项节点
public function payment(PaymentRequest $request, $id)
{
if (!$request->ajax()) {
$payment = SitePayment::query()->where(['site_id' => $id])->first();
return view('admin/site/payment', [
'data' => $payment ?? null,
'siteId' => $id
]);
}
SitePayment::query()->updateOrCreate([
'site_id' => $id
], $request->validated());
return response()->json(['message' => '操作成功']);
}
/**
* 项目概况--查看套餐
*/
public function overview_set_meal(SiteOverviewRequest $request, $id)
{
$data = Site::query()->where('id',$id)->first();
if(empty($data->package_type) || $data->package_type=='0'){
$data->package_type='未选择套餐';
}else{
if($data->package_type=='1'){
$data->package_type='老套餐';
}else if($data->package_type=='2'){
$data->package_type='2019标准版';
}else if($data->package_type=='3'){
$data->package_type='2019升级版';
}else if($data->package_type=='4'){
$data->package_type='2019高级版';
}else if($data->package_type=='5'){
$data->package_type='2020标准版';
}else if($data->package_type=='6'){
$data->package_type='2020升级版';
}else if($data->package_type=='7'){
$data->package_type='2020高级版';
}else if($data->package_type=='8'){
$data->package_type='定制版';
}else{
$data->package_type='暂无套餐名称';
}
}
var_dump($data->package_type);
die;
}
/**
* 项目概况--详细信息
*/
public function overview_view(SiteOverviewRequest $request, $id)
{
if (!$request->ajax()) {
$site = Site::query()->with(['users'])->where('id', $id)->first();
if (!$site) {
return view('admin/site/tips', [
'tips' => '站点信息不存在',
'siteId' => $id
]);
}
if ($site) {
$single['hasServerIds'] = $site->users->where('role_id', Role::TYPE_SERVER)->pluck('id')->toArray();
$single['hasEditorIds'] = $site->users->where('role_id', Role::TYPE_AE)->pluck('id')->toArray();
$single['hasMangerIds'] = $site->users->where('role_id', Role::TYPE_MANAGER)->pluck('id')->toArray();
$single['hasBidIds'] = $site->users->whereIn('role_id', [Role::TYPE_BID, Role::TYPE_BIDDING_MANAGER])->pluck('id')->toArray();
$single['hasSellerIds'] = $site->users->where('role_id', Role::TYPE_SELLER)->pluck('id')->toArray();
$single['hasMangeHelpIds'] = $site->users->where('role_id', Role::TYPE_MANAGE_HELPER)->pluck('id')->toArray();
$single['hasOptimizerIds'] = $site->users->where('role_id', Role::TYPE_OPTIMIZER)->pluck('id')->toArray();
$single['hasWebIds'] = $site->users->where('role_id', Role::TYPE_WEB)->pluck('id')->toArray();
$single['hasDesignerIds'] = $site->users->where('role_id', Role::TYPE_DESIGNER)->pluck('id')->toArray();
$single['hasPropagandaIds'] = $site->users->where('role_id', Role::TYPE_SOFT_TEXT_SEARCH)->pluck('id')->toArray();
/*$single['hasPlannerIds'] = $site->users->where('role_id', Role::TYPE_PLANNER)->pluck('id')->toArray();*/
$single['hasExternalLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK)->pluck('id')->toArray();
$single['hasChongqingLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK_PART_CHONGQING)->pluck('id')->toArray();
$single['hasArticleIds'] = $site->users->where('role_id', Role::TYPE_ARTICLE)->pluck('id')->toArray();
$single['hasOptimizationEditing'] = $site->users->where('role_id', Role::TYPE_OPTIMIZATION_EDITING)->pluck('id')->toArray();
}
return view('admin/site/overview_view', [
'roles' => $user = auth()->user(),
'siteInfo' => SiteInfo::query()->where(['site_id' => $id])->first(),
'siteId' => $id,
'data' => $site ?? null,
'enterpriseNature' => explode(',', $site->enterprise_nature) ?? [],
'case_ids' => explode(',', $site->case_ids) ?? [],
'businesses' => Business::query()->orderBy('sort')->get(),
'natures' => Site::NATURE_TYPE,
'contracts' => Contract::all(),
'servers' => Server::all(), //服务器
'article' => Role::getUsers(Role::TYPE_ARTICLE), //软文
'services' => Role::getUsers(Role::TYPE_SERVER), //服务人员
'editors' => Role::getUsers(Role::TYPE_AE),
'managers' => Role::getUsers(Role::TYPE_MANAGER),
'managerHelpers' => Role::getUsers(Role::TYPE_MANAGE_HELPER),
'planner' => Role::getUsers(Role::TYPE_PLANNER),
'propaganda' => Role::getUsers(Role::TYPE_SOFT_TEXT_SEARCH),//软文查找人员
'optimizers' => Role::getUsers(Role::TYPE_OPTIMIZER),
'bidUsers' => User::query()->whereIn('role_id', [Role::TYPE_BIDDING_MANAGER, Role::TYPE_BID])->get(),
'sellerUsers' => Role::getUsers(Role::TYPE_SELLER),
'webUsers' => Role::getUsers(Role::TYPE_WEB),
'designers' => Role::getUsers(Role::TYPE_DESIGNER),
'externalLink' => Role::getUsers(Role::TYPE_LINK),
'chongqingLink' => Role::getUsers(Role::TYPE_LINK_PART_CHONGQING),//重庆外链兼职
'optimizationEditing' => Role::getUsers(Role::TYPE_OPTIMIZATION_EDITING),
'payment' => SitePayment::query()->where(['site_id' => $id])->first(),
'facebookSocial' => Social::query()->where(['type' => Social::FACEBOOK])->first()
] + ($single ?? ['hasServerIds' => [], 'hasEditorIds' => [], 'hasMangerIds' => []]) +
Social::query()->where(['site_id' => $id])->get()->keyBy('type')->toArray() + // 社交信息
['linkedBaseInfo' => Social::query()->where(['site_id' => 0, 'type' => Social::LINKED])->first()] +
['optimizePage' => SiteOptimizePage::query()->where(['site_id' => $id])->get()->toArray()]
);
}
return $this->logic->overview($id, $request->validated(), $request->input('type'));
}
/**
* 项目概况--竞价
*/
public function overview_bidding(SiteOverviewRequest $request, $id)
{
if (!$request->ajax()) {
$site = Site::query()->with(['users'])->where('id', $id)->first();
if (!$site) {
return view('admin/site/tips', [
'tips' => '站点信息不存在',
'siteId' => $id
]);
}
if ($site) {
$single['hasServerIds'] = $site->users->where('role_id', Role::TYPE_SERVER)->pluck('id')->toArray();
$single['hasEditorIds'] = $site->users->where('role_id', Role::TYPE_AE)->pluck('id')->toArray();
$single['hasMangerIds'] = $site->users->where('role_id', Role::TYPE_MANAGER)->pluck('id')->toArray();
$single['hasBidIds'] = $site->users->whereIn('role_id', [Role::TYPE_BID, Role::TYPE_BIDDING_MANAGER])->pluck('id')->toArray();
$single['hasSellerIds'] = $site->users->where('role_id', Role::TYPE_SELLER)->pluck('id')->toArray();
$single['hasMangeHelpIds'] = $site->users->where('role_id', Role::TYPE_MANAGE_HELPER)->pluck('id')->toArray();
$single['hasOptimizerIds'] = $site->users->where('role_id', Role::TYPE_OPTIMIZER)->pluck('id')->toArray();
$single['hasWebIds'] = $site->users->where('role_id', Role::TYPE_WEB)->pluck('id')->toArray();
$single['hasDesignerIds'] = $site->users->where('role_id', Role::TYPE_DESIGNER)->pluck('id')->toArray();
$single['hasPropagandaIds'] = $site->users->where('role_id', Role::TYPE_SOFT_TEXT_SEARCH)->pluck('id')->toArray();
/*$single['hasPlannerIds'] = $site->users->where('role_id', Role::TYPE_PLANNER)->pluck('id')->toArray();*/
$single['hasExternalLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK)->pluck('id')->toArray();
$single['hasChongqingLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK_PART_CHONGQING)->pluck('id')->toArray();
$single['hasArticleIds'] = $site->users->where('role_id', Role::TYPE_ARTICLE)->pluck('id')->toArray();
$single['hasOptimizationEditing'] = $site->users->where('role_id', Role::TYPE_OPTIMIZATION_EDITING)->pluck('id')->toArray();
}
return view('admin/site/overview_bidding', [
'roles' => $user = auth()->user(),
'siteInfo' => SiteInfo::query()->where(['site_id' => $id])->first(),
'siteId' => $id,
'data' => $site ?? null,
'enterpriseNature' => explode(',', $site->enterprise_nature) ?? [],
'case_ids' => explode(',', $site->case_ids) ?? [],
'businesses' => Business::query()->orderBy('sort')->get(),
'natures' => Site::NATURE_TYPE,
'contracts' => Contract::all(),
'servers' => Server::all(), //服务器
'article' => Role::getUsers(Role::TYPE_ARTICLE), //软文
'services' => Role::getUsers(Role::TYPE_SERVER), //服务人员
'editors' => Role::getUsers(Role::TYPE_AE),
'managers' => Role::getUsers(Role::TYPE_MANAGER),
'managerHelpers' => Role::getUsers(Role::TYPE_MANAGE_HELPER),
'planner' => Role::getUsers(Role::TYPE_PLANNER),
'propaganda' => Role::getUsers(Role::TYPE_SOFT_TEXT_SEARCH),//软文查找人员
'optimizers' => Role::getUsers(Role::TYPE_OPTIMIZER),
'bidUsers' => User::query()->whereIn('role_id', [Role::TYPE_BIDDING_MANAGER, Role::TYPE_BID])->get(),
'sellerUsers' => Role::getUsers(Role::TYPE_SELLER),
'webUsers' => Role::getUsers(Role::TYPE_WEB),
'designers' => Role::getUsers(Role::TYPE_DESIGNER),
'externalLink' => Role::getUsers(Role::TYPE_LINK),
'chongqingLink' => Role::getUsers(Role::TYPE_LINK_PART_CHONGQING),//重庆外链兼职
'optimizationEditing' => Role::getUsers(Role::TYPE_OPTIMIZATION_EDITING),
'payment' => SitePayment::query()->where(['site_id' => $id])->first(),
'facebookSocial' => Social::query()->where(['type' => Social::FACEBOOK])->first()
] + ($single ?? ['hasServerIds' => [], 'hasEditorIds' => [], 'hasMangerIds' => []]) +
Social::query()->where(['site_id' => $id])->get()->keyBy('type')->toArray() + // 社交信息
['linkedBaseInfo' => Social::query()->where(['site_id' => 0, 'type' => Social::LINKED])->first()] +
['optimizePage' => SiteOptimizePage::query()->where(['site_id' => $id])->get()->toArray()]
);
}
return $this->logic->overview($id, $request->validated(), $request->input('type'));
}
/**
* 项目概览
* @param SiteOverviewRequest $request
* @param $id
* @return View\Factory|JsonResponse|\Illuminate\View\View
*/
public function overview(SiteOverviewRequest $request, $id)
{
if (!$request->ajax()) {
$site = Site::query()->with(['users'])->where('id', $id)->first();
if (!$site) {
return view('admin/site/tips', [
'tips' => '站点信息不存在',
'siteId' => $id
]);
}
if ($site) {
$single['hasServerIds'] = $site->users->where('role_id', Role::TYPE_SERVER)->pluck('id')->toArray();
$single['hasEditorIds'] = $site->users->where('role_id', Role::TYPE_AE)->pluck('id')->toArray();
$single['hasMangerIds'] = $site->users->where('role_id', Role::TYPE_MANAGER)->pluck('id')->toArray();
$single['hasBidIds'] = $site->users->whereIn('role_id', [Role::TYPE_BID, Role::TYPE_BIDDING_MANAGER])->pluck('id')->toArray();
$single['hasSellerIds'] = $site->users->where('role_id', Role::TYPE_SELLER)->pluck('id')->toArray();
$single['hasMangeHelpIds'] = $site->users->where('role_id', Role::TYPE_MANAGE_HELPER)->pluck('id')->toArray();
$single['hasOptimizerIds'] = $site->users->where('role_id', Role::TYPE_OPTIMIZER)->pluck('id')->toArray();
$single['hasWebIds'] = $site->users->where('role_id', Role::TYPE_WEB)->pluck('id')->toArray();
$single['hasDesignerIds'] = $site->users->where('role_id', Role::TYPE_DESIGNER)->pluck('id')->toArray();
$single['hasPropagandaIds'] = $site->users->where('role_id', Role::TYPE_SOFT_TEXT_SEARCH)->pluck('id')->toArray();
/*$single['hasPlannerIds'] = $site->users->where('role_id', Role::TYPE_PLANNER)->pluck('id')->toArray();*/
$single['hasExternalLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK)->pluck('id')->toArray();
$single['hasChongqingLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK_PART_CHONGQING)->pluck('id')->toArray();
$single['hasArticleIds'] = $site->users->where('role_id', Role::TYPE_ARTICLE)->pluck('id')->toArray();
$single['hasOptimizationEditing'] = $site->users->where('role_id', Role::TYPE_OPTIMIZATION_EDITING)->pluck('id')->toArray();
}
return view('admin/site/overview', [
'roles' => $user = auth()->user(),
'siteInfo' => SiteInfo::query()->where(['site_id' => $id])->first(),
'siteId' => $id,
'data' => $site ?? null,
'enterpriseNature' => explode(',', $site->enterprise_nature) ?? [],
'case_ids' => explode(',', $site->case_ids) ?? [],
'businesses' => Business::query()->orderBy('sort')->get(),
'natures' => Site::NATURE_TYPE,
'contracts' => Contract::all(),
'servers' => Server::all(), //服务器
'article' => Role::getUsers(Role::TYPE_ARTICLE), //软文
'services' => Role::getUsers(Role::TYPE_SERVER), //服务人员
'editors' => Role::getUsers(Role::TYPE_AE),
'managers' => Role::getUsers(Role::TYPE_MANAGER),
'managerHelpers' => Role::getUsers(Role::TYPE_MANAGE_HELPER),
'planner' => Role::getUsers(Role::TYPE_PLANNER),
'propaganda' => Role::getUsers(Role::TYPE_SOFT_TEXT_SEARCH),//软文查找人员
'optimizers' => Role::getUsers(Role::TYPE_OPTIMIZER),
'bidUsers' => User::query()->whereIn('role_id', [Role::TYPE_BIDDING_MANAGER, Role::TYPE_BID])->get(),
'sellerUsers' => Role::getUsers(Role::TYPE_SELLER),
'webUsers' => Role::getUsers(Role::TYPE_WEB),
'designers' => Role::getUsers(Role::TYPE_DESIGNER),
'externalLink' => Role::getUsers(Role::TYPE_LINK),
'chongqingLink' => Role::getUsers(Role::TYPE_LINK_PART_CHONGQING),//重庆外链兼职
'optimizationEditing' => Role::getUsers(Role::TYPE_OPTIMIZATION_EDITING),
'payment' => SitePayment::query()->where(['site_id' => $id])->first(),
'facebookSocial' => Social::query()->where(['type' => Social::FACEBOOK])->first()
] + ($single ?? ['hasServerIds' => [], 'hasEditorIds' => [], 'hasMangerIds' => []]) +
Social::query()->where(['site_id' => $id])->get()->keyBy('type')->toArray() + // 社交信息
['linkedBaseInfo' => Social::query()->where(['site_id' => 0, 'type' => Social::LINKED])->first()] +
['optimizePage' => SiteOptimizePage::query()->where(['site_id' => $id])->get()->toArray()]
);
}
return $this->logic->overview($id, $request->validated(), $request->input('type'));
}
//账号保存
public function accountSave(Request $request, $siteId)
{
$adminAccount = $request->input('adminAccount');
$adminPass = $request->input('adminPass');
$userAccount = $request->input('userAccount');
$userPass = $request->input('userPass');
$appAccount = $request->input('appAccount');
$appPass = $request->input('appPass');
if (SiteInfo::query()->where(['site_id' => $siteId])->exists()) {
SiteInfo::query()->where(['site_id' => $siteId])->update([
'admin_account' => $adminAccount,
'admin_pass' => $adminPass,
'user_account' => $userAccount,
'user_pass' => $userPass,
'app_account' => $appAccount,
'app_pass' => $appPass,
]);
} else {
SiteInfo::query()->create([
'site_id' => $siteId,
'admin_account' => $adminAccount,
'admin_pass' => $adminPass,
'user_account' => $userAccount,
'user_pass' => $userPass,
'app_account' => $appAccount,
'app_pass' => $appPass,
]);
}
return response()->json(['message' => '操作成功']);
}
//优化页保存
public function optimizePageSave(Request $request, $siteId)
{
$groupData = $request->input('groupData');
if (!is_array($groupData)) {
$groupData = [];
}
$optimizePageIds = SiteOptimizePage::query()->where(['site_id' => $siteId])->pluck('id')->toArray();
$newIds = array_filter(array_column($groupData, 'id'));
foreach ($groupData as $item) {
if (!isset($item['id'])) {
continue;
}
if (!$item['id']) {
SiteOptimizePage::query()->create([
'site_id' => $siteId,
'keyword' => $item['keyword'] ?? '',
'url' => $item['url'] ?? '',
'is_optimize' => !$item['is_optimize'] ? 0 : 1
]);
} else {
SiteOptimizePage::query()->where(['id' => $item['id']])->update([
'keyword' => $item['keyword'] ?? '',
'url' => $item['url'] ?? '',
'is_optimize' => !$item['is_optimize'] ? 0 : 1
]);
}
}
$diffIds = array_diff($optimizePageIds, $newIds);
if ($diffIds) {
SiteOptimizePage::query()->whereIn('id', $diffIds)->delete();
}
return response()->json(['message' => '操作成功']);
}
//导入优化页
public function importOptimizePage(Request $request)
{
set_time_limit(0);
$siteId = $request->input('siteId');
if (!$request->input('excel_path') || !$siteId) {
return response()->json(['message' => '请先上传excel文件'], 422);
}
try {
Excel::import(new OptimizePageImport($siteId), $request->input('excel_path'), 'public');
} catch (\Throwable $throwable) {
Log::error(var_export($throwable->getMessage(), 1));
return response()->json(['message' => '导入失败'], 400);
}
return response()->json(['message' => '操作成功']);
}
//导出优化页
public function exportOptimizePage(Request $request)
{
$siteId = $request->input('siteId');
$results = SiteOptimizePage::query()->select(['keyword', 'url', 'is_optimize'])->where(['site_id' => $siteId])->get()->toArray();
foreach ($results as &$result) {
if (!empty($result['is_optimize'])) {
$result['is_optimize'] = '是';
} else {
$result['is_optimize'] = '否';
}
}
array_unshift($results, ['关键词', 'url地址', '是否优化']);
return (new BasicExport($results))->download(sprintf('重点优化%s.xls', date('YmdHis')));
}
/**
* 客户界面项目概览
* @param SiteOverviewRequest $request
* @return \Illuminate\Contracts\View\Factory|\Illuminate\Http\JsonResponse|\Illuminate\View\View
*/
public function customerOverview(SiteOverviewRequest $request)
{
$userSite = $this->hasUserOneSite();
if (!$userSite) {
return view('admin/errors/tips', [
'tips' => '站点信息不存在'
]);
}
$id = $userSite->id;
if (!$request->ajax()) {
$site = Site::query()->with(['users'])->where('id', $id)->first();
if (!$site) {
return view('admin/errors/tips', [
'tips' => '站点信息不存在'
]);
}
if ($site) {
$single['hasServerIds'] = $site->users->where('role_id', Role::TYPE_SERVER)->pluck('id')->toArray();
$single['hasEditorIds'] = $site->users->where('role_id', Role::TYPE_AE)->pluck('id')->toArray();
$single['hasMangerIds'] = $site->users->where('role_id', Role::TYPE_MANAGER)->pluck('id')->toArray();
$single['hasBidIds'] = $site->users->whereIn('role_id', [Role::TYPE_BID, Role::TYPE_BIDDING_MANAGER])->pluck('id')->toArray();
$single['hasSellerIds'] = $site->users->where('role_id', Role::TYPE_SELLER)->pluck('id')->toArray();
$single['hasMangeHelpIds'] = $site->users->where('role_id', Role::TYPE_MANAGE_HELPER)->pluck('id')->toArray();
$single['hasOptimizerIds'] = $site->users->where('role_id', Role::TYPE_OPTIMIZER)->pluck('id')->toArray();
$single['hasWebIds'] = $site->users->where('role_id', Role::TYPE_WEB)->pluck('id')->toArray();
$single['hasDesignerIds'] = $site->users->where('role_id', Role::TYPE_DESIGNER)->pluck('id')->toArray();
$single['hasPropagandaIds'] = $site->users->where('role_id', Role::TYPE_SOFT_TEXT_SEARCH)->pluck('id')->toArray();
/*$single['hasPlannerIds'] = $site->users->where('role_id', Role::TYPE_PLANNER)->pluck('id')->toArray();*/
$single['hasExternalLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK)->pluck('id')->toArray();
$single['hasChongqingLinkIds'] = $site->users->where('role_id', Role::TYPE_LINK_PART_CHONGQING)->pluck('id')->toArray();
$single['hasArticleIds'] = $site->users->where('role_id', Role::TYPE_ARTICLE)->pluck('id')->toArray();
$single['hasOptimizationEditing'] = $site->users->where('role_id', Role::TYPE_OPTIMIZATION_EDITING)->pluck('id')->toArray();
}
return view('admin/site/customer_overview', [
'siteId' => $id,
'data' => $site ?? null,
'businesses' => Business::all(),
'natures' => Site::NATURE_TYPE,
'contracts' => Contract::all(),
'servers' => Server::all(), //服务器
'article' => Role::getUsers(Role::TYPE_ARTICLE), //软文
'services' => Role::getUsers(Role::TYPE_SERVER), //服务人员
'editors' => Role::getUsers(Role::TYPE_AE),
'managers' => Role::getUsers(Role::TYPE_MANAGER),
'managerHelpers' => Role::getUsers(Role::TYPE_MANAGE_HELPER),
'planner' => Role::getUsers(Role::TYPE_PLANNER),
'propaganda' => Role::getUsers(Role::TYPE_SOFT_TEXT_SEARCH),//软文查找人员
'optimizers' => Role::getUsers(Role::TYPE_OPTIMIZER),
'bidUsers' => User::query()->whereIn('role_id', [Role::TYPE_BIDDING_MANAGER, Role::TYPE_BID])->get(),
'sellerUsers' => Role::getUsers(Role::TYPE_SELLER),
'webUsers' => Role::getUsers(Role::TYPE_WEB),
'designers' => Role::getUsers(Role::TYPE_DESIGNER),
'externalLink' => Role::getUsers(Role::TYPE_LINK),
'chongqingLink' => Role::getUsers(Role::TYPE_LINK_PART_CHONGQING),//重庆外链兼职
'optimizationEditing' => Role::getUsers(Role::TYPE_OPTIMIZATION_EDITING),
'payment' => SitePayment::query()->where(['site_id' => $id])->first(),
'facebookSocial' => Social::query()->where(['type' => Social::FACEBOOK])->first()
] + ($single ?? ['hasServerIds' => [], 'hasEditorIds' => [], 'hasMangerIds' => []]) +
Social::query()->where(['site_id' => $id])->get()->keyBy('type')->toArray() // 社交信息
);
}
return $this->logic->overview($id, $request->validated(), $request->input('type'));
}
//项目概况下的 修改bid状态
public function changeBidStatus(Request $request, $id)
{
$bidStatus = $request->input('bidStatus');
Site::query()->where(['id' => $id])->update(['bid_status' => $bidStatus]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 是否特殊软文
public function changeSpecArticle(Request $request, $siteId)
{
$spec_article = $request->input('spec_article');
Site::query()->where(['id' => $siteId])->update(['spec_article' => $spec_article]);
return response()->json(['message' => '操作成功']);
}
///项目概况下的 是否cdn
public function changeCDNStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['is_cdn' => $status]);
return response()->json(['message' => '操作成功']);
}
///项目概况下的 是否退款
public function changeRefundStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['is_refund' => $status]);
return response()->json(['message' => '操作成功']);
}
///项目概况下的 域名是否我们购买
public function changeDomainStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['domain_us_buy' => $status]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 是否网站续费
public function changeRenewStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['is_renew' => $status]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 当月上线目标
public function changeOnlineStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['is_current_month_online' => $status, 'current_month_online_date' => date('Y-m-t 23:59:59')]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 证书是否我们购买
public function changeCertStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['cert_us_buy' => $status]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 是否案例
public function changeCaseStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['is_case' => $status]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 是否百千
public function changeBqStatus(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['is_bq' => $status]);
return response()->json(['message' => '操作成功']);
}
//项目概况下的 软文是否暂停
public function articlePause(Request $request, $id)
{
$status = $request->input('status');
Site::query()->where(['id' => $id])->update(['article_pause' => $status]);
return response()->json(['message' => '操作成功']);
}
//社交授权 没啥用了 hootsuite代替
public function socialSave(SocialSaveRequest $request, $siteId)
{
$type = $request->input('type');
$validated = $request->validated()[$type];
switch ($type) {
case 'facebook':
Site::query()->where(['id' => $siteId])->update([
'facebook_page' => $validated['facebook_page']
]);
break;
case 'linkedIn':
case 'pin':
Social::query()->updateOrCreate(['site_id' => $siteId, 'type' => $type], $validated);
break;
}
return response()->json(['message' => '操作成功']);
}
//社交发布
public function socialPublish(SocialPublishRequest $request, $id)
{
$site = Site::query()->with(['server'])->select(['domain', 'id', 'server_id', 'database', 'webmaster_domain'])->where(['id' => $id])->first();
if (empty($site->database)) {
if ($request->ajax()) {
return response()->json(['message' => '站点数据库信息不存在'], 400);
} else {
return view('admin/site/tips', [
'tips' => '站点数据库信息不存在',
'siteId' => $id,
]);
}
}
if (empty($site->server)) {
if ($request->ajax()) {
return response()->json(['message' => '站点服务器未分配'], 400);
} else {
return view('admin/site/tips', [
'tips' => '站点服务器未分配',
'siteId' => $id,
]);
}
}
try {
$config = [
'connection_name' => sprintf('connection_name_%s', $id),
'host' => $site->server->server_ip,
'port' => '3306',
'database' => $site->database,
'username' => $site->server->mysql_user_name,
'password' => $site->server->mysql_passwd,
];
config_connection($config);
$connection = DB::connection($config['connection_name']);
$publishedMaps = HootsuiteHistory::query()->where(['site_id' => $site->id])->pluck('remote_content_id')->toArray();
if (!$request->ajax()) {
$cacheKey = 'socialPublish_' . $site->id;
if (!Cache::has($cacheKey)) {
$start = 0;
$count = 100;
$list = [];
while (true) {
$orders = $connection->table('content')->where(['lang' => 'en', 'is_hidemenu' => 0])
->selectRaw('id,parent_id,title,thumb,summary,subtitle,uri')
->skip($start)->take($count)->get();
foreach ($orders as $order) {
$data = [
'id' => $order->id,
'parent_id' => $order->parent_id,
'name' => $order->title,
'thumb' => $order->thumb,
'summary' => $order->summary,
'subtitle' => $order->subtitle,
'uri' => $order->uri,
];
$list[] = $data;
}
if (count($orders) < $count) break;
$start += $count;
}
Cache::put($cacheKey, $list, 600);
}
$records = Cache::get($cacheKey);
foreach ($records as &$record) {
if (in_array($record['id'], $publishedMaps)) {
$record['name'] = '【已发布】' . $record['name'];
}
}
$trees = list_to_tree($records, 'id', 'parent_id', 'children');
$hootsuiteUser = HootsuiteUser::query()->where(['site_id' => $id])->first();
if (!$hootsuiteUser) {
return view('admin/site/tips', [
'tips' => '站点hootsuite未指定',
'siteId' => $id,
]);
}
$label = DB::table('social_label')->where('site_id', $id)->pluck('label', 'id');
//账号切换
$number_list = HootsuiteUser::all()->where('site_id', $id);
$hootsuiteUser_count = HootsuiteUser::query()->where(['site_id' => $id])->count();
if($hootsuiteUser_count>'1'){
$hootsuiteUser_style = 'inline';
}else{
$hootsuiteUser_style = 'none';
}
return view('admin/site/social_publish', [
'trees' => $trees,
'siteId' => $id,
'site' => $site,
'socialProfiles' => $hootsuiteUser->social_profiles ?? [],
'labelList' => $label ?? [],
'number_list'=>$number_list,
'hootsuiteUser_style'=>$hootsuiteUser_style,
]);
}
//return $this->logic->socialPublish($request->validated(), $connection, $site);
return $this->logic->socialPublish($request->validated(), $connection, $site,$request->input('hootsuiteUser_id'));
} catch (\Throwable $exception) {
return view('admin/site/tips', [
'tips' => '远端的数据库链接或配置有误！ http://test.build.yinqingli.net/admin',
'siteId' => $id,
]);
}
}
public function AjaxSocialProfiles(Request $request)
{
$HootsuiteUserId = $request->input('HootsuiteUserId');
$hootsuiteUser = HootsuiteUser::query()->where(['id' => $HootsuiteUserId])->first();
//var_dump($hootsuiteUser->social_profiles);
$data = '';
if(!empty($hootsuiteUser->social_profiles)){
foreach ($hootsuiteUser->social_profiles as $value){
$data.="";
}
}
if(empty($data)){
return response()->json(['message' => '操作失败','status'=>100]);
}else{
return response()->json(['message' => '操作成功','data'=>$data,'status'=>200]);
}
}
public function socialUpdate(Request $request, $siteId)
{
pre_dump($request);
pre_dump($siteId);
die;
}
//社交队列 后面被hootsutie 方式代替
public function socialQueue(Request $request, $siteId)
{
if (!$request->ajax()) {
// $client = new Client();
// $url = sprintf('%s/admin/hootsuite/social-list', config('app.wall_url'));
// try {
//
// $response = $client->request('GET', $url);
// $result = json_decode($response->getBody()->getContents(), true);
// $socialList = $result['data']??[];
// } catch (\GuzzleHttp\Exception\GuzzleException $exception) {
// $socialList = [];
// }
return view('admin/site/social_queue', [
'siteId' => $siteId,
'socialList' => $socialList ?? []
]);
}
$records = SocialPublish::query()->where(['site_id' => $siteId])->orderBy('id', 'desc')->paginate($request->input('pageSize') ?? TABLE_PAGE_SIZE);
$items = $records->items();
array_walk($items, function ($item) {
$item->is_published = $item->social_sync_at ? '已发布' : '未发布';
$item->content = str_limit($item->content, 20);
$resultStatus = $item->result_status ?? [];
$item->published_result = sprintf(
'pin:%s twitter:%s facebook:%s',
(SocialPublish::STATUS_TITLE[($resultStatus['pin'] ?? null)] ?? ''),
(SocialPublish::STATUS_TITLE[($resultStatus['twitter'] ?? null)] ?? ''),
(SocialPublish::STATUS_TITLE[($resultStatus['facebook'] ?? null)] ?? '')
);
});
return response()->json([
'rows' => $items,
'total' => $records->total()
]);
}
public function socialMetastasis($siteId)
{
$list = SocialPublish::query()->where('site_id', $siteId)->get();
HootsuiteHistory::query()
->where('site_id', $siteId)
->delete();
$array = [];
foreach ($list as $key => $value) {
$data = [
'site_id' => $value->site_id,
'remote_content_id' => $value->remote_content_id,
'content' => $value->content ?? '',
'url' => $value->url ?? '',
'media' => $value->media ?? '',
'publish_at' => $value->publish_at,
'created_at' => $value->created_at,
];
$array[] = $data;
}
HootsuiteHistory::query()->insert($array);
return response()->json(['message' => '操作成功']);
}
//自定义
public function socialQueueSave(SocialQueueRequest $request, $socialQueueId)
{
$siteId = $request->input('siteId');
if (!$request->ajax()) {
$data = SocialPublish::query()->find($socialQueueId);
$label = DB::table('social_label')->where('site_id', $siteId)->pluck('label', 'id');
//$hootSuiteUser = HootsuiteUser::query()->where(['site_id' => $siteId])->first();
if(!empty($request->input('sid'))){
$hootSuiteUser = HootsuiteUser::query()->where(['id' => $request->input('sid')])->first();
}else{
$hootSuiteUser = HootsuiteUser::query()->where(['site_id' => $siteId])->first();
}
if (!$hootSuiteUser) {
return view('admin/site/tips', [
'tips' => '站点hootsuite未指定',
'siteId' => $siteId,
]);
}
return view('admin/site/social_queue_save', [
'data' => $data ?? null,
'siteId' => $siteId,
'boards' => $boardList ?? [],
'boardsErr' => $boardsErr ?? null,
'labelList' => $label ?? [],
'socialProfiles' => $hootSuiteUser->social_profiles ?? [],
]);
}
$validated = $request->validated();
$publishAt = date('Y-m-d H:i:s', strtotime('+' . $validated['release_interval'] . ' day', strtotime($validated['publish_at'])));
if (strtotime($publishAt) < (time() + 60 * 10)) {
return response()->json(['message' => '发布时间距离当前时间过近或小于当前时间'], 400);
}
$url = sprintf('%s/admin/hootsuite/schedule-message', config('app.wall_url'));
try {
$client = new Client();
$response = $client->request('POST', $url, [
'form_params' => [
'siteId' => $siteId,
'socialIds' => $validated['social_ids'],
'remoteImg' => $validated['media'],
'content' => $validated['content'],
'sendAt' => $validated['publish_at'],
]
]);
if ($response->getStatusCode() != 200) {
return response()->json(['message' => "发送失败"], 400);
}
$result = json_decode($response->getBody()->getContents(), true);
if (!empty($result['errors'])) {
return response()->json(['message' => ($result['errors'][0]['message'] ?? 'schedule error')], 400);
}
$updateData = [
'site_id' => $siteId,
'media' => $validated['media'],
'url' => $validated['url'],
'content' => $validated['content'],
'result' => json_encode($result['data'] ?? []),
'publish_at' => $validated['publish_at'],
'created_at' => date('Y-m-d H:i:s'),
];
SocialPublish::query()->insert($updateData);
$hootSuiteUser = HootsuiteUser::query()->where(['id' => $siteId])->first();
$socialProfiles = $hootSuiteUser->social_profiles ?? [];
$mapSocialProfiles = array_column($socialProfiles, null, 'id');
$tempSocialProfiles = [];
foreach ($mapSocialProfiles as $key => $item) {
if (in_array($key, $validated['social_ids'])) {
$tempSocialProfiles[] = $item;
}
}
$queues = [
'site_id' => $siteId,
'remote_content_id' => 0,
'media' => $validated['media'],
'url' => $validated['url'],
'content' => $validated['content'],
'created_at' => date('Y-m-d H:i:s'),
'updated_at' => date('Y-m-d H:i:s'),
'publish_at' => $validated['publish_at'],
'social_ids' => json_encode($validated['social_ids'] ?? []),
'social_profiles' => json_encode($tempSocialProfiles ?? []),
'result' => json_encode($result['data'] ?? []),
];
HootsuiteHistory::query()->insert($queues);
return response()->json(['message' => '操作成功']);
} catch (\GuzzleHttp\Exception\GuzzleException $exception) {
Log::error(var_export($exception->getMessage(), 1));
return response()->json(['message' => '发布失败'], 400);
}
}
public function socialQueueDel($socialQueueId)
{
SocialPublish::destroy($socialQueueId);
return response()->json(['message' => '操作成功']);
}
//项目管理详情下的 hootsuite记录
public function hootsuiteHistory(Request $request, $siteId)
{
if (!$request->ajax()) {
return view('admin/site/hootsuite_history', [
'siteId' => $siteId,
'socialList' => $socialList ?? []
]);
}
$hUser = HootsuiteUser::query()->where(['site_id' => $siteId])->first();
$records = HootsuiteHistory::query()->where(['site_id' => $siteId])
->orderBy('publish_at', 'desc')
->paginate($request->input('pageSize') ?? TABLE_PAGE_SIZE);
$items = $records->items();
$socialProfiles = $hUser->social_profiles ?? [];
foreach ($items as $item) {
$item->publishStatus = '失败';
$item->content = str_limit($item->content, 30);
/**付饶修改新的**/
$new_hUser = HootsuiteUser::query()->where(['site_id' => $siteId])->select();
$new_hUser = HootsuiteUser::all()->where('site_id', $siteId);
$ids_new = $item->social_ids ?? [];
$type_name = '';
foreach ($new_hUser as $value){
foreach ($value->social_profiles as $val) {
if (in_array($val['id'], $ids_new)) {
$type_name .= $val['type'] . ' ';
}
}
}
$item->profileStr =$type_name;
/**付饶修改新的**/
// $ids = $item->social_ids ?? [];
// $profileStr = '';
// foreach ($socialProfiles as $val) {
// if (in_array($val['id'], $ids)) {
// $profileStr .= $val['type'] . ' ';
// }
// }
//$item->profileStr = $profileStr;
if (!empty($item->result)) {
$item->publishStatus = '成功';
}
}
return response()->json([
'rows' => $items,
'total' => $records->total()
]);
}
public function siteListExport()
{
$siteList = Site::query()->whereIn('status', [1, 2, 3])->select('cn_title', 'old_id', 'domain', 'status')->get()->toJson();
$siteList = \GuzzleHttp\json_decode($siteList, true);
$top10ListMapCacheKey = 'top10ListMap_cache_key';
$top10ListMap = Cache::get($top10ListMapCacheKey);
$listReportMap_cache_key = 'listReportMap_cache_key';
$listReportMap = Cache::get($listReportMap_cache_key);
foreach ($siteList as $key => $value) {
$siteList[$key]['top10'] = '';
$siteList[$key]['traffic'] = '';
$siteList[$key]['inquire'] = '';
foreach ($top10ListMap as $kk => $vv) {
if (!empty($value['old_id'] && $value['old_id'] == $vv->project_id)) {
$siteList[$key]['top10'] = $vv->top10;
}
}
foreach ($listReportMap as $kk => $vv) {
if (!empty($value['old_id'] && $value['old_id'] == $vv->project_id)) {
$siteList[$key]['traffic'] = $vv->traffic;
}
if (!empty($value['old_id'] && $value['old_id'] == $vv->project_id)) {
$siteList[$key]['inquire'] = $vv->inquire;
}
}
if ($value['status'] == 1) {
$siteList[$key]['status'] = '建站期';
}
if ($value['status'] == 2) {
$siteList[$key]['status'] = '实施期';
}
if ($value['status'] == 3) {
$siteList[$key]['status'] = '服务期';
}
}
$dataList = [];
$dataList[] = ['项目名称', '网址', '项目状态', '月排名', '月流量', '询盘'];
foreach ($siteList as $key => $value) {
unset($value['old_id']);
$dataList[] = $value;
}
return (new BasicExport($dataList))->download(sprintf('项目流量统计%s.xls', date('YmdHis')));
}
public function socialTemplateImport(Request $request, $id)
{
set_time_limit(0);
if (!$request->input('excel_path')) {
return response()->json(['message' => '请先上传excel文件'], 422);
}
$site = Site::query()->where(['id' => $id])->first();
if (!$site) {
return response()->json(['message' => '站点信息不存在'], 400);
}
if (!$site->old_id) {
return response()->json(['message' => '请先与rank项目关联'], 400);
}
try {
Excel::import(new SocialImport($site->id), $request->input('excel_path'), 'public');
} catch (\Throwable $throwable) {
Log::error(var_export($throwable->getMessage(), 1));
return response()->json(['message' => '导入失败'], 400);
}
return response()->json(['message' => '操作成功']);
}
public function socialMessageListImport(Request $request)
{
set_time_limit(0);
if (!$request->input('excel_path')) {
return response()->json(['message' => '请先上传excel文件'], 422);
}
try {
Excel::import(new SocialMessageListImport(), $request->input('excel_path'), 'public');
return response()->json(['message' => '操作成功']);
} catch (\Throwable $throwable) {
return response()->json(['message' => $throwable->getMessage()], 400);
}
}
//单个项目测速
public function getSpeedMeasurementCacheResult($siteId)
{
try {
$site = Site::query()->where('id', $siteId)->first();
$pcResult = $this->apiResult(self::PC_SPEED_MEASUREMENT, $site->webmaster_domain);
$data['pc'] = '';
$result = $pcResult['lighthouseResult']['categories']['performance']['score'] ?? '';
if (!empty($result)) {
$data['pc'] = intval(round(floatval($result) * 100));
}
$data['mobile'] = '';
$mobileResult = $this->apiResult(self::MOBILE_SPEED_MEASUREMENT, $site->webmaster_domain);
$result1 = $mobileResult['lighthouseResult']['categories']['performance']['score'] ?? '';
if (!empty($result1)) {
$data['mobile'] = intval(round(floatval($result1) * 100));
}
$key = 'cache:app/Http/Controllers/SpeedMeasurementController/index:' . $site->old_id;
if (!empty($data['pc']) || !empty($data['mobile'])) {
DB::table('app_speed_measurement_cache')->where('key', $key)->delete();
DB::table('app_speed_measurement_cache')->insert(['cache' => \GuzzleHttp\json_encode($data), 'key' => $key]);
}
return response()->json(['code' => 200, 'message' => '操作成功']);
} catch (\Throwable $exception) {
return response()->json(['message' => $exception->getMessage()], 400);
}
}
public function apiResult($api, $url)
{
$client = new Client();
$response = $client->request('GET', $api . $url);
$response = json_decode($response->getBody()->getContents(), true);
return $response;
}
public function isComponent(Request $request, $siteId)
{
$type = $request->input('type') ?? 0;
Site::query()->where('id', $siteId)->update(['is_component' => $type]);
return response()->json(['message' => '操作成功']);
}
public function downloadSiteFile(Request $request)
{
$siteId = $request->input('siteId') ?? '';
$siteInfo = Site::query()->where('id', $siteId)->first();
if (empty($siteInfo->business_license_business_scope)) {
die('暂无文件');
}
$pathInfo = pathinfo($siteInfo->business_license_business_scope);
$dirnamePath = explode('storage', $pathInfo['dirname']);
return response()->download(realpath(base_path('public')) . '/storage' . $dirnamePath[1] . '/' . $pathInfo['basename'], $pathInfo['basename']);
}
}