/
index.php
120 lines (98 loc) · 3.63 KB
/
index.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
120
<?php
session_start();
ini_set('max_execution_time', 1200); //300 seconds = 5 minutes
ini_set('memory_limit ', '521M');
error_reporting(E_ALL);
ini_set('display_errors', 1);
require_once 'vendor/autoload.php';
require_once __DIR__ . '/Config.php';
require_once __DIR__ . '/GoogleSheet.php';
use Lib\Common;
use Google\Spreadsheet\DefaultServiceRequest;
use Google\Spreadsheet\ServiceRequestFactory;
$serviceRequest = new DefaultServiceRequest(Common::getGoogleTokenFromKeyFile());
ServiceRequestFactory::setInstance($serviceRequest);
$spreadsheetFeed = GoogleSheet::getAllSpreadSheetFeed();
/*
* Facebook Area
*/
$fbApp = new Facebook\FacebookApp(FACEBOOK_API_KEY, FACEBOOK_API_SECRET);
$fb = new Facebook\Facebook([
'app_id' => FACEBOOK_API_KEY,
'app_secret' => FACEBOOK_API_SECRET,
'default_graph_version' => 'v2.5',
]);
if (isset($_SESSION['facebook_access_token']) && $_SESSION['facebook_access_token']) {
$fb_user_id = \Lib\FacebookApi::getMe()['id'];
//\Lib\FacebookApi::getUserGroup($fb_user_id);
} else {
$fb_user_id = '';
$helper = $fb->getRedirectLoginHelper();
$permissions = ['email', 'user_posts']; // optional
$callback = FACEBOOK_CALLBACK;
$loginUrl = $helper->getLoginUrl($callback, $permissions);
}
?>
<!DOCTYPE html>
<html lang="">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Title Page</title>
<!-- Bootstrap CSS -->
<link href="//netdna.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" rel="stylesheet">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<h1 class="text-center">Facebook Feed Into GoogleSheet</h1>
<?php if (!isset($_SESSION['facebook_access_token'])) : ?>
<p class="text-center">
<a href="<?=$loginUrl?>">Log in with Facebook!</a>
</p>
<?php endif ?>
<div class="container">
<div class="row">
<div class="col-sm-6 col-sm-offset-3">
<form action="" method="post" id="frm">
<div class="form-group">
<label for="">Facebook User ID</label>
<input type="text" name="facebook_user_id" id="facebook_user_id" class="form-control" value="<?=$fb_user_id?>">
</div>
<div class="form-group">
<label for="">SpreadSheet</label>
<select name="spreadsheet" id="spreadsheet" class="form-control">
<option value="">Select SpreadSheet</option>
<?php foreach ($spreadsheetFeed as $key => $value) : ?>
<option value="<?=$spreadsheetFeed[$key]->getTitle()?>"><?=$spreadsheetFeed[$key]->getTitle()?></option>
<?php endforeach ?>
</select>
</div>
<div class="form-group">
<label for="">WorkSheet</label>
<select name="worksheet" id="worksheet" class="form-control">
<option value="">Select WorkSheet</option>
</select>
</div>
<!--<input type="submit" value="Export" name="submit" class="btn btn-primary"/>-->
<button type="button" id="exportingButton" data-loading-text="Exporting..." class="btn btn-primary" autocomplete="off">
Click to Export
</button>
</form>
</div>
</div>
</div>
<!-- jQuery -->
<script src="//code.jquery.com/jquery.js"></script>
<!-- Bootstrap JavaScript -->
<script src="//netdna.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
<script type="text/javascript" src="js/main.js"></script>
<script type="text/javascript">
</script>
</body>
</html>