-
Notifications
You must be signed in to change notification settings - Fork 0
/
link-publishers.php
119 lines (108 loc) · 4.17 KB
/
link-publishers.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
include ("include/config.php");
$msg = "";
$userId = intval($_SESSION[uid]);
if($userId<=0) {echo 'Not exit, please login first'; exit();}
$order_id = isset($_GET[order_id])?intval($_GET[order_id]):0;
$adv_id = isset($_GET[adv_id])?intval($_GET[adv_id]):0;
$export_cls = isset($_GET[type])?$_GET[type]:'';
if($order_id<=0 && $adv_id>0) $order_id = $adv_id;
require('classes/class_advertisersinfo.php'); $cls_advertisersinfo = new Advertisersinfo();
if(isset($order_id) && $order_id>0){ $where = 'adv_id = '.$order_id; } else $where = 'is_paid="Y"';
if(isset($_POST[update]) && $_POST[link_text] && ($_POST[order_id]>0)){
$key = $_POST[order_id];
$value = "ad_des='".stripslashes($_POST['link_text'])."'";
if($_POST['link_url'])
$value .= ",ad_url='".stripslashes($_POST['link_url'])."'";
$value .= ",update_time='".time()."'";
//$value .= ",ad_url='".$val['ad_url']."'";
$advertiser_info = $cls_advertisersinfo->getOne($key);
if(date('m') == date("m", $advertiser_info[update_time])){ $msg = '<span style="color:red">You cannot update advertise link two times per month.</span>' ;}
else{
$cls_advertisersinfo->updateOne($key, $value);
$msg = '<span style="color:geen">Update successful.</span>' ;
}
}
$all = getListOrder($order_id, $userId);
if($export_cls) export_excel($all[all]);
$where .= ' and uid = '.$userId;
function getListOrder($adv_id=0, $userId){
$list_arr = array();
$list_order = mysql_query("select publishersinfo.pid, publishersinfo.url, publishersinfo.websitename, publishersinfo.google_page_rank, publishersinfo.is_manual, publishersinfo.description, publishersinfo.approval_method, advertisersinfo.set_price, advertisersinfo.adv_id, advertisersinfo.ad_des, advertisersinfo.buying_date,advertisersinfo.end_date, advertisersinfo.approved,advertisersinfo.is_auth, advertisersinfo.ad_url from publishersinfo LEFT JOIN (advertisersinfo) ON (advertisersinfo.pid=publishersinfo.pid) where publishersinfo.status = 2 and publishersinfo.uid =".$userId." and advertisersinfo.is_paid='Y' order by advertisersinfo.adv_id DESC ");
while($r = @mysql_fetch_assoc($list_order)) {
$r[cancel] = 0;
if(date("Y-m-d")==$r[buying_date])
$r[cancel]=1;
$list_arr[ids][] = $r;
$list_arr[all][] = $r;
}
return $list_arr;
}
//$all = $cls_advertisersinfo->getAll($where);
$smarty->assign('msg', $msg);
$smarty->assign('order_id', $order_id);
$smarty->assign('ids', $all[ids]);
$smarty->assign('all', $all[all]);
if($_SERVER['REQUEST_METHOD']=='POST' && $_POST['action']=="submit"){
}
$content = $smarty->fetch('link-publishers.tpl');
$smarty->assign('content',$content);
$smarty->display('master_page.tpl');
function export_excel($arr_adv){
$result = array();
$filename ="links.xls";
//$result=mysql_query("select * from tbl_name");
function xlsBOF()
{
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
return;
}
function xlsEOF()
{
echo pack("ss", 0x0A, 0x00);
return;
}
function xlsWriteNumber($Row, $Col, $Value)
{
echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
echo pack("d", $Value);
return;
}
function xlsWriteLabel($Row, $Col, $Value )
{
$L = strlen($Value);
echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
echo $Value;
return;
}
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
xlsBOF();
xlsWriteLabel(0,0,"Website URL");
xlsWriteLabel(0,1,"Website Title");
xlsWriteLabel(0,2,"Order");
xlsWriteLabel(0,3,"Status");
xlsWriteLabel(0,4,"Start Date");
xlsWriteLabel(0,5,"Stop Date");
xlsWriteLabel(0,6,"Pagerank");
xlsWriteLabel(0,7,"Link Text");
xlsWriteLabel(0,8,"Link URL");
xlsWriteLabel(0,9,"Price/mo");
$xlsRow = 2;
foreach($arr_adv as $key =>$val){
xlsWriteLabel($xlsRow,0,'dantri.com.vn');
xlsWriteLabel($xlsRow,1,'dan tri');
xlsWriteLabel($xlsRow,2,'123');
xlsWriteLabel($xlsRow,3,'accepted');
xlsWriteLabel($xlsRow,4,'dan tri');
xlsWriteLabel($xlsRow,5,'21/3');
xlsWriteLabel($xlsRow,6,'1');
xlsWriteLabel($xlsRow,7,'dan tri');
xlsWriteLabel($xlsRow,8,'http://tinmoi.vn');
xlsWriteLabel($xlsRow,9,'10');
echo $xlsRow;
}
$xlsRow++;
xlsEOF();
}
?>