PHP Zend_Gdata_Spreadsheets_ListQuery::setWorksheetId方法代码示例

function getWkshtListFeed($gdClient, $ssKey, $wkshtId, $queryString = null)
{
    $query = new Zend_Gdata_Spreadsheets_ListQuery();
    $query->setSpreadsheetKey($ssKey);
    $query->setWorksheetId($wkshtId);
    if ($queryString !== null) {
        $query->setSpreadsheetQuery($queryString);
    }
    $listFeed = $gdClient->getListFeed($query);
    return $listFeed;
}

 /**
  * Find rows in the spreadsheet
  * @param  $q string|null  - the search string
  * @return int  - number of rows found
  */
 function find($q = null)
 {
     if ($q && is_string($q)) {
         $this->user_query = $q;
     }
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($this->ssid);
     $query->setWorksheetId($this->wsid);
     if ($this->user_query) {
         $query->setSpreadsheetQuery($this->user_query);
     }
     try {
         $this->listFeed = $this->service->getListFeed($query);
     } catch (Exception $e) {
         return 0;
     }
     return (int) $this->listFeed->getTotalResults()->text;
 }

 public function testGetListFeed()
 {
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($this->sprKey);
     $query->setWorksheetId($this->wksId);
     $feed = $this->gdata->getListFeed($query);
     $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_ListFeed);
     foreach ($feed->entries as $entry) {
         $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_ListEntry);
         $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient());
     }
     
     $feed = $this->gdata->getListFeed($query->getQueryUrl());
     $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_ListFeed);
     foreach ($feed->entries as $entry) {
         $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_ListEntry);
         $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient());
     }
 }

 /**
  * Inserts a new row with provided data.
  *
  * @param array $rowData An array of column header to row data
  * @param string $key The key of the spreadsheet to modify
  * @param string $wkshtId (optional) The worksheet to modify
  * @return ListEntry The inserted row
  */
 public function insertRow($rowData, $key, $wkshtId = 'default')
 {
     $newEntry = new Zend_Gdata_Spreadsheets_ListEntry();
     $newCustomArr = array();
     foreach ($rowData as $k => $v) {
         $newCustom = new Zend_Gdata_Spreadsheets_Extension_Custom();
         $newCustom->setText($v)->setColumnName($k);
         $newEntry->addCustom($newCustom);
     }
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($key);
     $query->setWorksheetId($wkshtId);
     $feed = $this->getListFeed($query);
     $editLink = $feed->getLink('http://schemas.google.com/g/2005#post');
     return $this->insertEntry($newEntry->saveXML(), $editLink->href, 'Zend_Gdata_Spreadsheets_ListEntry');
 }

 public function execute($arguments = array(), $options = array())
 {
     echo 'START KINTAI BOT.\\n';
     $details = array();
     $databaseManager = new sfDatabaseManager($this->configuration);
     $service = self::getZendGdata();
     $p = array();
     $dql = Doctrine_Query::create()->from('Member m')->where('m.is_active = ?', '1');
     if (!is_null($options['start-member-id']) && is_numeric($options['start-member-id'])) {
         $dql = $dql->andWhere('m.id >= ?', $options['start-member-id']);
     }
     if (!is_null($options['end-member-id']) && is_numeric($options['end-member-id'])) {
         $dql = $dql->andWhere('m.id <= ?', $options['end-member-id']);
     }
     $members = $dql->execute();
     $rawKey = opConfig::get('op_kintai_spkey', null);
     $wid = self::getRowId($service, $rawKey);
     foreach ($members as $member) {
         //変数初期化
         list($memberId, $memberspkey, $memberWorkSheetId, $memberMasterSpkey, $memberMasterWorkSheetId) = array(null, null, null, null, null);
         $memberId = $member->getId();
         $memberspkey = self::getMemberSpreadSheetKey($service, $memberId);
         if (!is_null($memberspkey)) {
             $memberWorkSheetId = self::getMemberWorkSheetId($service, $memberspkey);
         }
         $memberMasterSpkey = self::getMemberMasterSpreadSheetKey($service, $memberId);
         if (!is_null($memberMasterSpkey)) {
             $memberMasterWorkSheetId = self::getMemberMasterWorkSheetId($service, $memberMasterSpkey);
         }
         echo '==== debug info =====\\n';
         echo 'Member Id : ' . $memberId . '\\n';
         echo 'rawkey: ' . $rawKey . ' || rowid: ' . $wid . '\\n';
         echo 'Key: ' . $memberspkey . ' || WorkSheetId: ' . $memberWorkSheetId . '\\n';
         echo 'MasterSpkey: ' . $memberMasterSpkey . ' || MasterWorkSheetId: ' . $memberMasterWorkSheetId . '\\n';
         // スプレッドシートで勤怠報告しているメンバーの勤怠を処理する。
         if (!is_null($memberspkey) && !is_null($memberWorkSheetId)) {
             $previousMonth = date('m') - 1;
             $year = date('Y');
             $today = date('d');
             if (!checkdate($previousMonth, 1, $year)) {
                 $previousMonth = 12;
                 $year = $year - 1;
             }
             // 先月分の勤怠を処理する。
             for ($i = 1; $i < 31; $i++) {
                 if (checkdate($previousMonth, $i, $year)) {
                     $q = new Zend_Gdata_Spreadsheets_ListQuery();
                     $q->setSpreadsheetKey($memberspkey);
                     $q->setWorksheetId($memberWorkSheetId);
                     $query = 'date=' . $year . '/' . $previousMonth . '/' . $i;
                     $q->setSpreadsheetQuery($query);
                     $lineList = $service->getListFeed($q);
                     if (!$lineList) {
                         continue;
                     } else {
                         foreach ($lineList->entries as $entry) {
                             $lines = $entry->getCustom();
                             foreach ($lines as $line) {
                                 $key = $line->getColumnName();
                                 switch ($key) {
                                     case 'date':
                                         $date = $line->getText();
                                         break;
                                     case 'ssh':
                                         $ssh = $line->getText();
                                         break;
                                     case 'ssm':
                                         $ssm = $line->getText();
                                         break;
                                     case 'seh':
                                         $seh = $line->getText();
                                         break;
                                     case 'sem':
                                         $sem = $line->getText();
                                         break;
                                     case 'srh':
                                         $srh = $line->getText();
                                         break;
                                     case 'srm':
                                         $srm = $line->getText();
                                         break;
                                     case 'zsh':
                                         $zsh = $line->getText();
                                         break;
                                     case 'zsm':
                                         $zsm = $line->getText();
                                         break;
                                     case 'zeh':
                                         $zeh = $line->getText();
                                         break;
                                     case 'zem':
                                         $zem = $line->getText();
                                         break;
                                     case 'zrh':
                                         $zrh = $line->getText();
                                         break;
                                     case 'zrm':
                                         $zrm = $line->getText();
                                         break;
                                     default:
//.........这里部分代码省略.........

 public function listDeleteAction($index)
 {
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($this->currKey);
     $query->setWorksheetId($this->currWkshtId);
     $this->listFeed = $this->gdClient->getListFeed($query);
     $this->gdClient->deleteRow($this->listFeed->entries[$index]);
 }

function setWorksheet()
{
    $user = "leopizzodb";
    $pass = "l30p1z04d";
    $SPREADSHEET = array();
    $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
    $SPREADSHEET['service'] = $service;
    $httpClient = $accessToken->getHttpClient($oauthOptions);
    $client = new Zend_Gdata_Docs($httpClient, "leopizzo-991");
    //$client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
    $SPREADSHEET['client'] = $client;
    $spreadsheetService = new Zend_Gdata_Spreadsheets($client);
    $SPREADSHEET['spreadsheetService'] = $spreadsheetService;
    //$feed = $spreadsheetService->getSpreadsheetFeed();
    if ($_POST['language'] == 'it') {
        $keyString = '0Au0T1WiZS_P8dHY3alR4RUNwcER5Rm9RNFZvRWFfeEE';
    } else {
        $keyString = '0Au0T1WiZS_P8dGZJOGFoVmZuY3ZfMERFMDM0TnZpSEE';
    }
    $query = new Zend_Gdata_Spreadsheets_ListQuery();
    $query->setSpreadsheetKey($keyString);
    $query->setWorksheetId('od6');
    $SPREADSHEET['query'] = $query;
    return $SPREADSHEET;
}

 private function findRows($search = FALSE)
 {
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($this->getSpreadsheetId());
     $query->setWorksheetId($this->getWorksheetId());
     if ($search) {
         $query->setSpreadsheetQuery($search);
     }
     $feed = $this->client->getListFeed($query);
     return $feed;
 }

// make cache object
$cache = Zend_Cache::factory('Output', 'File', $frontendOptions, $backendOptions);
if (!$cache->start($post_col)) {
    // load Zend Gdata libraries
    Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
    Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
    try {
        // connect to API
        $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
        $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
        $service = new Zend_Gdata_Spreadsheets($client);
        // define worksheet query
        // get list feed for query
        $query = new Zend_Gdata_Spreadsheets_ListQuery();
        $query->setSpreadsheetKey($spreadhsheet_key);
        $query->setWorksheetId($people_wksht);
    } catch (Exception $e) {
        die('ERROR: ' . $e->getMessage());
    }
    ?>

<?php 
    function labelBOD($entry)
    {
        if ($entry->getCustomByName('bodindustryprivatesector') == 'Y' || $entry->getCustomByName('bodacademicresearcheducationsector') == 'Y' || $entry->getCustomByName('bodpublicagenciesnonprofitothersector') == 'Y' || $entry->getCustomByName('bodatlarge') == 'Y' || $entry->getCustomByName('bodpublicseat') == 'Y' || $entry->getCustomByName('bodaffiliateseat') == 'Y' || $entry->getCustomByName('bodsustainingseat') == 'Y') {
            return ' (B)';
        } else {
            return '';
        }
    }
    // print order

// make cache object
$cache = Zend_Cache::factory('Output', 'File', $frontendOptions, $backendOptions);
if (!$cache->start('members_kml')) {
    // load Zend Gdata libraries
    Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
    Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
    try {
        // connect to API
        $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
        $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
        $service = new Zend_Gdata_Spreadsheets($client);
        // define worksheet query
        // get list feed for query
        $query = new Zend_Gdata_Spreadsheets_ListQuery();
        $query->setSpreadsheetKey($spreadhsheet_key);
        $query->setWorksheetId($membership_wksht);
    } catch (Exception $e) {
        die('ERROR: ' . $e->getMessage());
    }
    // Creates the Document.
    $dom = new DOMDocument('1.0', 'UTF-8');
    // Creates the root KML element and appends it to the root document.
    $node = $dom->createElementNS('http://earth.google.com/kml/2.1', 'kml');
    $parNode = $dom->appendChild($node);
    // Creates a KML Document element and append it to the KML element.
    $dnode = $dom->createElement('Document');
    $docNode = $parNode->appendChild($dnode);
    $styleNode = $dom->CreateElement('Style');
    $styleNode->setAttribute('id', 'yellow');
    $iconStyleNode = $dom->CreateElement('IconStyle');
    $iconNode = $dom->CreateElement('Icon');

 public function executeAjaxSend(sfWebRequest $request)
 {
     $service = self::getZendGdata();
     $wid = self::getRowId($service);
     if ($request->isMethod(sfWebRequest::POST)) {
         $y = $request->getParameter('y');
         $m = $request->getParameter('m');
         $d = $request->getParameter('d');
         $memberId = $this->getUser()->getMemberId();
         $data = $request->getParameter('data');
         $comment = $request->getParameter('comment');
         $keitai = substr($data, 0, 1);
         $start = array();
         $end = array();
         $start["hour"] = substr($data, 1, 2);
         $start["minute"] = substr($data, 3, 2);
         $end["hour"] = substr($data, 5, 2);
         $end["minute"] = substr($data, 7, 2);
         $start["time"] = $start["hour"] * 60 + $start["minute"];
         $end["time"] = $end["hour"] * 60 + $end["minute"];
         $rest = substr($data, 9, 3);
         if (substr($rest, 0, 1) == "0") {
             $rest = substr($rest, 1, 2);
         }
         $jitsumu = $end["time"] - $start["time"] - $rest;
         if (strlen($data) == 24) {
             $keitai2 = substr($data, 12, 1);
             $start2["hour"] = substr($data, 13, 2);
             $start2["minute"] = substr($data, 15, 2);
             $end2["hour"] = substr($data, 17, 2);
             $end2["minute"] = substr($data, 19, 2);
             $start2["time"] = $start2["hour"] * 60 + $start2["minute"];
             $end2["time"] = $end2["hour"] * 60 + $end2["minute"];
             $rest2 = substr($data, 21, 3);
             if (substr($rest2, 0, 1) == "0") {
                 $rest2 = substr($rest2, 1, 2);
             }
             $jitsumu2 = $end2["time"] - $start2["time"] - $rest2;
         }
         //Validation
         $message = null;
         if (strlen($data) != 12 && strlen($data) != 24) {
             $message .= "入力が不正です。<br />";
         }
         if (!preg_match("/^[0-2][0-9]\$/", $start["hour"]) || !preg_match("/^[0-5][0-9]\$/", $start["minute"])) {
             $message .= "始業時間の入力が誤っています。<br />";
         }
         if (!preg_match("/^[0-2][0-9]\$/", $end["hour"]) || !preg_match("/^[0-5][0-9]\$/", $end["minute"])) {
             $message .= "終業時間の入力が誤っています。<br />";
         }
         if ($jitsumu <= 0) {
             $message .= "実務時間が0分となってしまいます。入力を見なおしてください。<br />";
         }
         if (!preg_match("/^\\d{2,3}\$/", $rest)) {
             $message .= "休憩時間の入力が誤っています。<br />";
         }
         if ($keitai != "S" && $keitai != "Z") {
             $message .= "勤務種別の入力が誤っています(2)。<br />";
         }
         if (!$comment) {
             $message .= 'コメントがありません。<br />';
         }
         if (strlen($data) == 24) {
             if (isset($keitai) && isset($keitai2) && $keitai == $keitai2) {
                 $message .= "同じ業務種別です。(2)";
             }
             if (!preg_match("/^[0-2][0-9]\$/", $start2["hour"]) || !preg_match("/^[0-5][0-9]\$/", $start2["minute"])) {
                 $message .= "始業時間の入力が誤っています。(2)<br />";
             }
             if (!preg_match("/^[0-2][0-9]\$/", $end2["hour"]) || !preg_match("/^[0-5][0-9]\$/", $end2["minute"])) {
                 $message .= "終業時間の入力が誤っています。(2)<br />";
             }
             if ($jitsumu <= 0) {
                 $message .= "実務時間が0分となってしまいます。入力を見なおしてください。(2)<br />";
             }
             if (!preg_match("/^\\d{2,3}\$/", $rest2)) {
                 $message .= "休憩時間の入力が誤っています。(2)<br />";
             }
             if ($keitai2 != "S" && $keitai2 != "Z") {
                 $message .= "勤務種別の入力が誤っています。(2)<br />";
             }
         }
         $unixtime = mktime(0, 0, 0, $m, $d, $y);
         $nowtime = time();
         $pasttime = $unixtime - $nowtime;
         $allowtime = opConfig::get('op_kintai_allowdate', '3');
         if ($pasttime > $allowtime) {
             $message .= "勤怠の登録期限がすでに過ぎてしまっています。<br />";
         }
         $q = new Zend_Gdata_Spreadsheets_ListQuery();
         $q->setSpreadsheetKey(opConfig::get('op_kintai_spkey', null));
         $q->setWorksheetId($wid);
         $query = "id={$memberId} and date={$y}/{$m}/{$d}";
         $q->setSpreadsheetQuery($query);
         $line = $service->getListFeed($q);
         if (!$line->entries["0"]) {
             $message .= '編集しようとした勤怠は存在しませんでした。<br />';
         } else {
             $nowtime = time();
             $unixtime = mktime(0, 0, 0, $m, $d, $y);
//.........这里部分代码省略.........

 private function updateMasterKintai($service, $memberId, $memberMasterSpkey, $memberMasterWorkSheetId, $year, $month, $i, $detail)
 {
     $r = new Zend_Gdata_Spreadsheets_ListQuery();
     $r->setSpreadsheetKey($memberMasterSpkey);
     $r->setWorksheetId($memberMasterWorkSheetId);
     $query = 'date=' . $year . '/' . $month . '/' . $i;
     $r->setSpreadsheetQuery($query);
     $lineList = $service->getListFeed($r);
     if ($lineList) {
         $update = $service->updateRow($lineList->entries['0'], $detail);
         if ($update) {
             echo sprintf("UPDATE SUCCESS!(SpreadSheet) memberId: %s date: %s;\n", $memberId, $detail["date"]);
         } else {
             echo sprintf("ERROR! NO UPDATED.(SpreadSheet) Maybe Internal Server Error Occured on Google Service. memberId: %s date: %s;", $memberId, $detail["date"]);
         }
     } else {
         echo sprintf("ERROR! NO UPDATED.(SpreadSheet) Maybe Spreadsheet has been broken. memberId: %s date %s;", $memberId, $detail["date"]);
     }
 }

 /**
  * Reads in a complete worksheet for the specified document.
  */
 protected function readCompleteWorksheet()
 {
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($this->gs_document);
     $query->setWorksheetId($this->gs_worksheet);
     try {
         // this reads all the rows of the spreadsheet
         // up until the first empty row.
         $this->list_feed_allrows = $spreadsheetService->getListFeed($query);
     } catch (Zend_Exception $e) {
         throw new JLD_System_Exception();
     }
     return true;
 }

 /**
  * Retourne le résultat de la requete passé en paramètre sous la forme d'une liste de lignes
  * @param String $worksheetId Id du worksheet
  * @param String $spreadsheetId Id du spreadsheet
  * @param String $strQuery la requête
  */
 public function getResultQueryList($strQuery, $worksheetId, $spreadSheetId)
 {
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($spreadSheetId);
     $query->setWorksheetId($worksheetId);
     $query->setSpreadsheetQuery($strQuery);
     return $this->service->getListFeed($query);
 }

 private function createListQuery()
 {
     $query = new Zend_Gdata_Spreadsheets_ListQuery();
     $query->setSpreadsheetKey($this->currKey);
     $query->setWorksheetId($this->currWkshtId);
     return $query;
 }