as well as the Zind GData libraries
This class is best used with a cronjob like this:
0,30 * * * * cd /home/yurukov1/public_html/vote; /usr/local/php5/bin/php proxy.php
If an email is configured for the cronjob, then all addresses in error will be printed out only once.
*********************************************************/
mb_internal_encoding("UTF-8");
$datafile = "data/.data.json.gz";
//the path yo your ZEND libs
set_include_path("/home/yurukov1/libs/");
include_once "Google_Spreadsheet.php";
include "secret.php";
include_once "config.php";
//access settings should be defined in config.php
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet($spreadsh);
$ss->useWorksheet($sheet);
// get the data from the spreadsheet
$rows = $ss->getRows();
if (!$rows) {
exit;
}
$data = array();
for ($i = 0; $i < count($rows); $i++) {
$type = $rows[$i]["искателидапомогнете"];
if ($type == "Ще разпостранявам информация сред познати") {
$type = 1;
} else {
if ($type == "Бих се заел с организиране на секция извън консулствата") {
$type = 2;
<?php
include_once "csp_helper.php";
$u = "*****@*****.**";
$p = "pi314159265";
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("Collaboration Tracking");
$ss->useWorksheet("Sheet1");
$ss2 = new Google_Spreadsheet($u, $p);
$ss2->useSpreadsheet("NRNB Subproject Stages");
$ss2->useWorksheet("Sheet1");
$rowset = 'projectstage!=""';
# only rows with stage info
$rows = $ss->getRows($rowset);
if ($rows) {
foreach ($rows as $row) {
$stage = $row['projectstage'];
$stage2 = array();
## skip if no digits
$stage = str_replace(",", "", $stage);
$len = strlen($stage);
if ($len < 1) {
continue;
} elseif ($len == 1) {
array_push($stage2, $stage . "1");
} elseif ($len > 1) {
array_push($stage2, substr($stage, 0, 1) . "2");
for ($i = 1; $i < $len - 1; $i++) {
array_push($stage2, substr($stage, $i, 1) . "1");
array_push($stage2, substr($stage, $i, 1) . "2");
}
tr:nth-child(odd) {
background-color: white;
}
</style>
</head>
<body>
<table border="0px">
<?php
include_once "csp_helper.php";
$u = "*****@*****.**";
$p = "****";
//NOTE: don't bother, the helper code based on Zend no longer works
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("Collaboration Tracking");
$ss->useWorksheet("Sheet1");
//headers
echo "<tr>";
$head = $ss->getColumnNames();
foreach ($head as $colname) {
echo "<th>{$colname}</th>";
}
echo "</tr>";
//GET admin set
$view = $_GET["view"];
$rowset = "";
//means "show all;
if ($view == "Ongoing" || $view == "Completed" || $view == "Canceled" || $view == "Unknown") {
$rowset = "projectstatus={$view}";
{
border: solid 1px #fff;
background-repeat: repeat-x;
background-position: top;
}
</style>
</head>
<body>
<div id="inputArea" style="float:left;background-color:#fff;">
<?php
include_once "csp_helper.php";
$u = "*****@*****.**";
$p = "pi314159265";
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("Collaboration Tracking");
$ss->useWorksheet("Sheet1");
//GET sub id
if (empty($_GET)) {
echo "This page requires a Subproject ID in order to display data. Please try again. </div></body></html>";
} else {
$subid = $_GET["id"];
$msg = "Please update the following information:";
if ('POST' == $_SERVER['REQUEST_METHOD']) {
$update2 = check_input($_POST['update']);
$feedback2 = check_input($_POST['feedback']);
$pubmed2 = check_input($_POST['pubmed']);
$grant2 = check_input($_POST['grant']);
$status2 = check_input($_POST['status']);
$st1 = check_input($_POST['stage1']);
<?php
// Zend library include path
set_include_path(get_include_path() . PATH_SEPARATOR . "{$_SERVER['DOCUMENT_ROOT']}/ZendGdata-1.8.1/library");
include_once "Google_Spreadsheet.php";
include_once "../../../config/post_spreadsheet_config.php";
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("Mailing List 2015");
$name = Trim(stripslashes($_GET['name']));
$email = Trim(stripslashes($_GET['email']));
$year = Trim(stripslashes($_GET['year']));
$campus = Trim(stripslashes($_GET['campus']));
$interest = Trim(stripslashes($_GET['interest']));
$involvement = Trim(stripslashes($_GET['involvement']));
// if not setting worksheet, "Sheet1" is assumed
// $ss->useWorksheet("worksheetName");
$row = array("Name" => $name, "Email" => $email, "Year of Study" => $year, "College/Campus" => $campus, "Area of interest" => $interest, "Involvement in TEDxUofT" => $involvement);
if ($ss->addRow($row)) {
echo "Form data successfully stored using Google Spreadsheet";
} else {
echo "Error, unable to store spreadsheet data";
}
<?php
// Zend library include path
set_include_path(get_include_path() . PATH_SEPARATOR . "{$_SERVER['DOCUMENT_ROOT']}/ZendGdata-1.8.1/library");
include_once "Google_Spreadsheet.php";
include_once "../../../config/post_spreadsheet_config.php";
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("2015 Delegate Application");
$Name = Trim(stripslashes($_GET['Name']));
$Email = Trim(stripslashes($_GET['Email']));
$Year = Trim(stripslashes($_GET['Year']));
$Phone = Trim(stripslashes($_GET['Phone']));
$Status = Trim(stripslashes($_GET['Status']));
$Occupation = Trim(stripslashes($_GET['Occupation']));
$Program = Trim(stripslashes($_GET['Program']));
$Campus = Trim(stripslashes($_GET['Campus']));
$Dietary = Trim(stripslashes($_GET['Dietary']));
$FinalQ = Trim(stripslashes($_GET['FinalQ']));
// if not setting worksheet, "Sheet1" is assumed
// $ss->useWorksheet("worksheetName");
$row = array("Name" => $Name, "E-mail" => $Email, "Year" => $Year, "Phone" => $Phone, "I am a(an)" => $Status, "Occupation" => $Occupation, "Program" => $Program, "Campus" => $Campus, "Dietary" => $Dietary, "Final Question" => $FinalQ);
if ($ss->addRow($row)) {
echo "Form data successfully stored using Google Spreadsheet";
} else {
echo "Error, unable to store spreadsheet data";
}
<?php
// Zend library include path
set_include_path(get_include_path() . PATH_SEPARATOR . "{$_SERVER['DOCUMENT_ROOT']}/ZendGdata-1.8.1/library");
include_once "Google_Spreadsheet.php";
include_once "../../../config/post_spreadsheet_config.php";
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("Hiring Application Submissions 2014");
$Name = Trim(stripslashes($_GET['Name']));
$Campus = Trim(stripslashes($_GET['Campus']));
$Position = Trim(stripslashes($_GET['Position']));
$Email = Trim(stripslashes($_GET['Email']));
$Phone = Trim(stripslashes($_GET['Phone']));
$Occupation = Trim(stripslashes($_GET['Occupation']));
$Title = Trim(stripslashes($_GET['Title']));
$Year = Trim(stripslashes($_GET['Year']));
// if not setting worksheet, "Sheet1" is assumed
// $ss->useWorksheet("worksheetName");
$row = array("Name" => $Name, "Campus" => $Campus, "Application Position" => $Position, "E-mail" => $Email, "Phone" => $Phone, "Program" => $Occupation, "Year of Study" => $Year);
if ($ss->addRow($row)) {
echo "Form data successfully stored using Google Spreadsheet";
} else {
echo "Error, unable to store spreadsheet data";
}
$mail->Subject = $_SETTINGS['email']['subject'];
$mail->AltBody = "To view the message, please use an HTML compatible email viewer!";
// optional, comment out and test
$mail->MsgHTML($body);
$mails = explode(',', $_SETTINGS['email']['address']);
foreach ($mails as $v) {
$mail->AddAddress(trim($v));
}
if (!$mail->Send()) {
$ret['error'] = 1;
}
}
/**************** GOOGLE.DOCS method ************************/
if ($_SETTINGS['store_to_gdocs']) {
include_once "GoogleSpreadsheet/Google_Spreadsheet.php";
$ss = new Google_Spreadsheet($_SETTINGS['gdocs']['user'], $_SETTINGS['gdocs']['password']);
$ss->useSpreadsheet($_SETTINGS['gdocs']['spreadsheet_name']);
$ss->useWorksheet($_SETTINGS['gdocs']['worksheet_name']);
$row = array("Date" => date("m/d/Y H:i"));
foreach ($_POST['fields'] as $k => $v) {
$row[$k] = $v;
}
if (!$ss->addRow($row)) {
$ret['error'] = 1;
}
}
/**************** MailChimp method ************************/
if ($_SETTINGS['store_to_mailchimp']) {
if (@$_POST['fields'][$_SETTINGS['email_field_name']] && $_SETTINGS['mailchimp']['apikey'] && $_SETTINGS['mailchimp']['listId']) {
include_once 'mailChimp/MCAPI.class.php';
$MCAPI = new MCAPI($_SETTINGS['mailchimp']['apikey']);
<?php
// Zend library include path
set_include_path(get_include_path() . PATH_SEPARATOR . "{$_SERVER['DOCUMENT_ROOT']}/ZendGdata-1.8.1/library");
include_once "Google_Spreadsheet.php";
include_once "../../../config/post_spreadsheet_config.php";
$ss = new Google_Spreadsheet($u, $p);
$ss->useSpreadsheet("Nomination Submissions 2014");
$Nominator_Name = Trim(stripslashes($_GET['Nominator_Name']));
$Nominator_Email = Trim(stripslashes($_GET['Nominator_Email']));
$Nominator_Phone = Trim(stripslashes($_GET['Nominator_Phone']));
$Nominee_Name = Trim(stripslashes($_GET['Nominee_Name']));
$Nominee_Email = Trim(stripslashes($_GET['Nominee_Email']));
$Nominee_Phone = Trim(stripslashes($_GET['Nominee_Phone']));
$Overview = Trim(stripslashes($_GET['Overview']));
$Websites_Articles = Trim(stripslashes($_GET['Websites_Articles']));
$Audios_Videos = Trim(stripslashes($_GET['Audios_Videos']));
$Speaking_Style = Trim(stripslashes($_GET['Speaking_Style']));
$Why_fits_the_theme = Trim(stripslashes($_GET['Why_fits_the_theme']));
// if not setting worksheet, "Sheet1" is assumed
// $ss->useWorksheet("worksheetName");
$row = array("Nominator Name" => $Nominator_Name, "Nominator E-mail" => $Nominator_Email, "Nominator Phone" => $Nominator_Phone, "Nominee Name" => $Nominee_Name, "Nominee E-mail" => $Nominee_Email, "Nominee Phone" => $Nominee_Phone, "Overview" => $Overview, "Websites or Articles" => $Websites_Articles, "Audios or Videos" => $Audios_Videos, "Speaking Style" => $Speaking_Style, "Why fits the theme" => $Why_fits_the_theme);
if ($ss->addRow($row)) {
echo "Form data successfully stored using Google Spreadsheet";
} else {
echo "Error, unable to store spreadsheet data";
}
function __construct()
{
new Model();
$teamSpreadsheet = new Google_Spreadsheet('Team Contacts & Roles');
// d($teamSpreadsheet);
// $columnNames = $teamSpreadsheet->getColumnNames();
// dd($columnNames);
$this->rows = $teamSpreadsheet->getRows();
// $rows = $teamSpreadsheet->getRows();
// dd($rows);
// foreach ($rows as $row) {
// $teamName;
// if (is_string($row)) {
// $teamName = $row;
// }
// $data = array();
// // $data = array_merge($row, $teamName);
// $teamMember = new TeamMember($row);
// $teamMember->setTeam($teamName);
// // $teamMember = new TeamMember($teamName);
// // foreach ($row as $key => $value) {
// // $teamMember->set()
// // $teamMember[] = $teamMember[$key] = $value;
// // }
// $this->teamMembers[] = $teamMember;
// }
// dd($teamMembers);
// foreach ($rows as $row) {
// // if row begins with '*' then trim it off and create a class with the name
// // dd($row);
// $count = 0;
// $this->teamMembers[$count] = new TeamMember($row[0]);
// // d($this->teamMembers);
// foreach ($row as $k => $v) {
// $this->teamMembers[$count]->setAll($v[0], $v[1], $v[2], $v[5], $v[6], $v[7], $v[8], $v[9]);
// // d($row);
// // sd($k);
// // if ($k[0] == 'Position' && $k[9] == 'Picture') {
// // }
// }
// $count++;
// }
// dd($teamMembers);
// LOOP THROUGH AND CREATE TEAM MEMBERS
// $teamMember = new TeamMember();
// foreach ($rows as $colName => $colValue) {
// for ($i = 0; $i < count($rows); $i++) {
// $columnValues = array();
// $columns = $rows[$i];
// // for ($colPosition = 0; $colPosition < ; $colPosition++) {
// // $columns[] = $rows[$i][$colPosition]
// // }
// foreach ($columns as $column) {
// // dd($column);
// // $columnValues[] =
// }
// }
// $teams[] = new Team($currentFirstColumn);
// - instantiate the Team Class
// -
}
