当前位置: 首页>>代码示例>>PHP>>正文


PHP Contact::getNumRows方法代码示例

本文整理汇总了PHP中Contact::getNumRows方法的典型用法代码示例。如果您正苦于以下问题:PHP Contact::getNumRows方法的具体用法?PHP Contact::getNumRows怎么用?PHP Contact::getNumRows使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Contact的用法示例。


在下文中一共展示了Contact::getNumRows方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: eventExportContacts

 function eventExportContacts(EventControler $evtcl)
 {
     $iduser = $_SESSION['do_User']->iduser;
     $do_contact = new Contact();
     $do_contact->getAllContactsForAUser();
     $num_contacts = $do_contact->getNumRows();
     $report_name = "ofuz_" . $iduser . "_report" . ".xls";
     $fname = "xls_report/{$report_name}";
     $workbook =& new writeexcel_workbook($fname);
     $worksheet =& $workbook->addworksheet('Report');
     $heading =& $workbook->addformat(array('align' => 'center', 'bold' => 1, 'fg_color' => 'yellow'));
     $right =& $workbook->addformat(array('align' => 'right'));
     $left =& $workbook->addformat(array('align' => 'left'));
     # Create a border format
     $border1 =& $workbook->addformat();
     $border1->set_color('magenta');
     $border1->set_bold();
     $border1->set_size(15);
     $border1->set_pattern(0x1);
     $border1->set_fg_color('aqua');
     $border1->set_border_color('yellow');
     $border1->set_top(6);
     $border1->set_bottom(6);
     $border1->set_left(6);
     $border1->set_align('center');
     $border1->set_align('vcenter');
     $border1->set_merge();
     # This is the key feature
     # Create another border format.
     $border2 =& $workbook->addformat();
     $border2->set_color('magenta');
     $border2->set_bold();
     $border2->set_size(15);
     $border2->set_pattern(0x1);
     $border2->set_fg_color('aqua');
     $border2->set_border_color('yellow');
     $border2->set_top(6);
     $border2->set_bottom(6);
     $border2->set_right(6);
     $border2->set_align('center');
     $border2->set_align('vcenter');
     $border2->set_merge();
     # This is the key feature
     /*
     		# Set the row height for row 0 (heading current date)
     		$worksheet->set_row(0, 24);
     	
     		$worksheet->write      (0, 0, "Welcome", $border1);
     		$worksheet->write_blank(0, 1,                        $border2);
     		$worksheet->write_blank(0, 2,                        $border2);
     */
     # Set the row height for row 0 (heading current date)
     $worksheet->set_row(1, 24);
     $current_date = _("As on ") . date('m/d/Y h:i:s') . ", ";
     $heading_total_contacts = $current_date . _("Total Contacts : ") . $num_contacts;
     $worksheet->write(1, 0, $heading_total_contacts, $border1);
     $worksheet->write_blank(1, 1, $border2);
     $worksheet->write_blank(1, 2, $border2);
     $worksheet->write_blank(1, 3, $border2);
     $worksheet->write_blank(1, 4, $border2);
     $worksheet->write_blank(1, 5, $border2);
     $report_heading = array('First Name', 'Last Name', 'Company', 'Position', 'Email', 'Phone', 'Tags');
     $col = 0;
     foreach ($report_heading as $colum) {
         $worksheet->write(3, $col, $colum, $heading);
         $col++;
     }
     $row = 4;
     if ($num_contacts) {
         while ($do_contact->next()) {
             $col = 0;
             $worksheet->write($row, $col, $do_contact->getData('firstname'), $left);
             $col++;
             $worksheet->write($row, $col, $do_contact->getData('lastname'), $left);
             $col++;
             $worksheet->write($row, $col, $do_contact->getData('company'), $left);
             $col++;
             $worksheet->write($row, $col, $do_contact->getData('position'), $left);
             $col++;
             $worksheet->write($row, $col, $do_contact->getData('email_address'), $left);
             $col++;
             $worksheet->write($row, $col, $do_contact->getData('phone_number'), $left);
             $col++;
             $worksheet->write($row, $col, $do_contact->getData('tags'), $left);
             $row++;
         }
     } else {
     }
     $workbook->close();
     //header("Location: {$fname}");
     $evtcl->setDisplayNext(new Display($fname));
 }
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:92,代码来源:Export.class.php

示例2: AutoResponder

 * A cron job script for sending the autoresponders.
 * Will get the autoresponders with the tags and will send the email to the contacts associated with the tag_name
 * @see class/Autoresponder.class.php
 */
include_once 'config.php';
$AutoResponder = new AutoResponder();
$AutoResponder->getAutoresponders();
if ($AutoResponder->getNumRows()) {
    while ($AutoResponder->next()) {
        $User = new User();
        $User->getId($AutoResponder->iduser);
        $User->sessionPersistent('do_User', 'contacts.php', OFUZ_TTL);
        $email_template = new EmailTemplate();
        $email_template->bodyhtml = nl2br(stripslashes($AutoResponder->bodyhtml));
        $email_template->subject = $AutoResponder->subject;
        $email_template->senderemail = $User->email;
        $email_template->sendername = $User->firstname . ' ' . $User->lastname;
        $resp_name = $AutoResponder->resp_name;
        $Contact = new Contact();
        $Contact->getContactsForAutoResponder($AutoResponder->iduser, $AutoResponder->tag_name, $AutoResponder->num_days_to_send);
        if ($Contact->getNumRows()) {
            while ($Contact->next()) {
                $values = array("idcontact" => $Contact->idcontact, "firstname" => $Contact->firstname, "lastname" => $Contact->lastname, "position" => $Contact->position, "company" => $Contact->company, "idtag" => $Contact->idtag, "resp_name" => $resp_name, "flag" => "unsubscribe_autoresponder");
                $Contact->sendMessage($email_template, $values);
                echo '<br /> Email Sent to :' . $Contact->email_address;
            }
        }
        $Contact->free();
    }
    $AutoResponder->free();
}
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:31,代码来源:cron_autoresponder.php

示例3: while

       if($do_contact->getNumRows()){
       while($do_contact->next()){
       $co_workers[] = $do_->idcoworker;
       $user_picture = $do_contact->picture;
       $contact_id = $do_contact->idcontact;
       }
       }
 if($user_picture ==''){
       $user_pic="/images/empty_avatar.gif";
       }else{
       $user_pic="/dbimage/".$user_picture;
       }
 */
 $do_contact = new Contact();
 $do_contact->getContactPictureDetails($_SESSION['do_coworker']->idcoworker);
 if ($do_contact->getNumRows()) {
     if ($do_contact->picture != '') {
         $thumb_name = $_SERVER['DOCUMENT_ROOT'] . '/dbimage/thumbnail/' . $do_contact->picture;
         if (file_exists($thumb_name)) {
             $contact_picture = "/dbimage/thumbnail/" . $do_contact->picture;
         } else {
             $contact_picture = "/images/empty_avatar.gif";
         }
     } else {
         $contact_picture = '/images/empty_avatar.gif';
     }
     $contact_id = $do_contact->idcontact;
 }
 $do_user = new User();
 $username = $do_user->getUserLoginId($_SESSION['do_coworker']->idcoworker);
 $do_user->free();
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:31,代码来源:co_workers.php

示例4: eventAddFeed

 /**
  *  Add the note to the workfeed
  *  Select all other Co-Worker on the project and push the note to them.
  *  Every Co-Worker in the project get the feed except the one posting the note.
  *  @param EventControler object
  */
 function eventAddFeed(EventControler $evtcl)
 {
     $prefix_note = $evtcl->block_unblock_flag == "Block" ? "<b>Task Block </b>" : "<b>Task Unblock </b>";
     $this->idproject_task = $evtcl->ofuz_idprojecttask;
     $this->discuss = $prefix_note . $evtcl->block_unblock_reason;
     $this->iduser = $_SESSION['do_User']->iduser;
     $this->idproject_discuss = $evtcl->idproject_discuss;
     $this->idproject = $_SESSION['do_project_task']->idproject;
     $this->block_unblock_flag = $evtcl->block_unblock_flag;
     $do_project = new Project();
     $do_project->getId($this->idproject);
     $this->project_name = $do_project->getProjectName();
     $user = new User();
     $user->getId($this->iduser);
     $this->user_full_name = $user->getFullName();
     $do_contact = new Contact();
     $do_contact->getContactPictureDetails($this->iduser);
     if ($do_contact->getNumRows()) {
         while ($do_contact->next()) {
             $this->user_picture = $do_contact->picture;
             $this->contact_id = $do_contact->idcontact;
         }
     }
     $do_proj_task_feed = new ProjectTask();
     $do_proj_task_feed->getProjectTaskDetails($this->idproject_task);
     $this->task_description = $do_proj_task_feed->task_description;
     if (strlen($this->discuss) > 200) {
         $this->discuss = substr($this->discuss, 0, 200);
         $this->more = True;
     } else {
         $this->more = False;
     }
     $do_project_sharing = new ProjectSharing();
     $project_users = $do_project_sharing->getCoWorkersAsArray($do_project);
     $project_users[] = $do_project->getProjectOwner();
     $users = array();
     foreach ($project_users as $project_user) {
         if ($_SESSION['do_User']->iduser != $project_user) {
             $users[] = $project_user;
         }
     }
     $this->addFeed($users);
 }
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:49,代码来源:WorkFeedKanbanBlockReasonProjectDiscuss.class.php

示例5: AddProjectDiscussFeedFromDropBox

 /**
  *  Add the note to the workfeed from drop box email 
  *  Select all other Co-Worker on the project and push the note to them.
  *  Every Co-Worker in the project get the feed except the one posting the note.
  *  @param EventControler object
  */
 function AddProjectDiscussFeedFromDropBox($idproject_task, $discuss, $iduser, $idproject_discuss, $idproject)
 {
     $this->idproject_task = $idproject_task;
     $this->discuss = $discuss;
     $this->iduser = $iduser;
     $this->idproject_discuss = $idproject_discuss;
     $this->idproject = $idproject;
     $do_project = new Project();
     $do_project->getId($this->idproject);
     $this->project_name = $do_project->getProjectName();
     $user = new User();
     $user->getId($this->iduser);
     $this->user_full_name = $user->getFullName();
     $do_contact = new Contact();
     $do_contact->getContactPictureDetails($this->iduser);
     if ($do_contact->getNumRows()) {
         while ($do_contact->next()) {
             $co_workers[] = $do_->idcoworker;
             $this->user_picture = $do_contact->picture;
             $this->contact_id = $do_contact->idcontact;
         }
     }
     $do_proj_task_feed = new ProjectTask();
     $do_proj_task_feed->getProjectTaskDetails($this->idproject_task);
     $this->task_description = $do_proj_task_feed->task_description;
     if (strlen($this->discuss) > 200) {
         $this->discuss = substr($this->discuss, 0, 200);
         $this->more = True;
     } else {
         $this->more = False;
     }
     $do_project_sharing = new ProjectSharing();
     $project_users = $do_project_sharing->getCoWorkersAsArray($do_project);
     $project_users[] = $do_project->getProjectOwner();
     $users = array();
     foreach ($project_users as $project_user) {
         if ($iduser != $project_user) {
             $users[] = $project_user;
         }
     }
     $this->addFeed($users);
 }
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:48,代码来源:WorkFeedProjectDiscuss.class.php

示例6: _

            </div>
        </div>
        <div class="left_menu_footer"></div>
        <br /><br />
        <div class="left_menu_header">
            <div class="left_menu_header_content"><?php 
echo _('People in this Company');
?>
</div>
        </div>
        <div class="left_menu">
            <div class="left_menu_content">
                        <?php 
$do_comp_cont = new Contact();
$do_comp_cont->getCompanyRelatedContacts($idcompany);
if ($do_comp_cont->getNumRows()) {
    while ($do_comp_cont->next()) {
        $currentpage = $_SERVER['PHP_SELF'];
        //$e_detail = new Event("mydb.gotoPage");
        //$e_detail->addParam("goto", "contact.php");
        //$e_detail->addParam("idcontact",$do_comp_cont->idcontact);
        //$e_detail->addParam("tablename", "contact");
        //$e_detail->requestSave("eDetail_contact", $currentpage);
        $id_shared_owner = $do_comp_cont->isContactRelatedToUser($do_comp_cont->idcontact);
        ?>
                                      
                                      <span class="contact_name">
                                      <?php 
        if ($id_shared_owner) {
            ?>
                                      <a href="/Contact/<?php 
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:31,代码来源:company.php

示例7: rebuildContactUserTable

 public function rebuildContactUserTable($iduser = 0)
 {
     if (empty($iduser)) {
         $iduser = $this->iduser;
     }
     $this->setUser($iduser);
     //$this->sql_view_name = "userid".$iduser."_contact";
     $this->query("DROP VIEW IF EXISTS " . $this->sql_view_name);
     $this->query("DROP TABLE IF EXISTS " . $this->sql_view_name);
     $this->query("CREATE TABLE `" . $this->sql_view_name . "` (\n\t\t\t`idcontact` int(10) NOT NULL default '0',\n\t\t\t`firstname` varchar(50) NOT NULL,\n\t\t\t`lastname` varchar(60) NOT NULL,\n\t\t\t`company` varchar(70) NOT NULL,\n\t\t\t`idcompany` int(10) NOT NULL,\n\t\t\t`position` varchar(60) NOT NULL,\n\t\t\t`picture` varchar(200) NOT NULL,\n\t\t\t`email_address` varchar(180),\n\t\t\t`phone_number` varchar(30),\n\t\t\t`tags` varchar(250) NOT NULL,\n\t\t\t`last_activity` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,\n\t\t\t`last_update` timestamp NOT NULL default '0000-00-00 00:00:00',\n\t\t\t`first_created` timestamp NOT NULL default '0000-00-00 00:00:00',\n\t\t\tKEY `firstname` (`firstname`),\n\t\t\tKEY `lastname` (`lastname`),\n\t\t\tKEY `company` (`company`), \n\t\t\tKEY `tags` (`tags`), \n\t\t\tKEY `last_activity` (`last_activity`)) ENGINE=MyISAM DEFAULT CHARSET=utf8");
     //echo $this->getSqlQuery();
     //		exit;
     $contacts = new Contact();
     $contacts->getUserContacts($this->iduser);
     $this->setLog("\n importing Contacts:" . $contacts->getNumRows());
     while ($contacts->next()) {
         $this->setLog("\n name:" . $contacts->firstname);
         $this->rebuildAddContact($contacts);
     }
     /**
     		$contacts->query("SELECT contact.idcontact as idcontact,         
                                     contact.firstname as firstname,         
                                     contact.lastname as lastname,        
                                     contact.company as company,   
                                     contact.idcompany as idcompany,     
                                     contact.position as position,        
                                     contact.picture as picture                                                         
                                 FROM contact,		
     							     contact_sharing							  
                                 WHERE `contact_sharing`.`idcoworker` = ".$this->iduser."
                                 AND contact.idcontact = contact_sharing.idcontact");
             while($contacts->next) {
     			$this->rebuildAddContact($contacts);
     		}
     		**/
     /**
     		$this->query("SELECT contact.idcontact as idcontact,         
                                     contact.firstname as firstname,         
                                     contact.lastname as lastname,        
                                     contact.company as company,   
                                     contact.idcompany as idcompany,     
                                     contact.position as position,
                                     contact.picture as picture,
                                     contact_email.email_address as email_address, 
                                     contact_phone.phone_number,
     					GROUP_CONCAT(DISTINCT tag.tag_name ORDER BY tag.tag_name SEPARATOR ',') as tags,
     					activity.when,
     					created_date_log.created_date,
     					updated_date_log.updatedate
                                 FROM  contact LEFT JOIN contact_email ON contact.idcontact = contact_email.idcontact 
                                               LEFT JOIN contact_phone ON contact.idcontact = contact_phone.idcontact 
     							  LEFT JOIN tag ON (contact.idcontact = tag.idreference AND reference_type='contact' AND tag.iduser=".$iduser.") 
     							  LEFT JOIN activity ON (contact.idcontact = activity.idcontact)
     							  LEFT JOIN created_date_log ON (created_date_log.id = contact.idcontact AND created_date_log.table_name='contact')
     							  LEFT JOIN updated_date_log ON (updated_date_log.primarykeyvalue = contact.idcontact AND updated_date_log.tablename='contact')
                                 WHERE contact.iduser = ".$iduser."
                                 GROUP BY contact.idcontact
     				
     				UNION
     				
     				SELECT contact.idcontact as idcontact,         
                                     contact.firstname as firstname,         
                                     contact.lastname as lastname,        
                                     contact.company as company,   
                                     contact.idcompany as idcompany,     
                                     contact.position as position,        
                                     contact.picture as picture,
                                     contact_email.email_address as email_address, 
                                     contact_phone.phone_number,         
                                     GROUP_CONCAT(DISTINCT tag.tag_name ORDER BY tag.tag_name SEPARATOR ',') as tags,
     					activity.when,
     					created_date_log.created_date,
     					updated_date_log.updatedate 
                                 FROM contact        LEFT JOIN tag ON (contact.idcontact = tag.idreference AND reference_type='contact' AND tag.iduser=".$iduser."),		
     				     contact_sharing LEFT JOIN contact_email ON contact_sharing.idcontact = contact_email.idcontact 
                                                      LEFT JOIN contact_phone ON contact_sharing.idcontact = contact_phone.idcontact 
     									 LEFT JOIN activity ON (contact_sharing.idcontact = activity.idcontact)
     									 LEFT JOIN created_date_log ON (created_date_log.id = contact_sharing.idcontact AND created_date_log.table_name='contact')
     									 LEFT JOIN updated_date_log ON (updated_date_log.primarykeyvalue = contact_sharing.idcontact AND updated_date_log.tablename='contact')							  
                                 WHERE `contact_sharing`.`idcoworker` = ".$iduser."
                                 AND contact.idcontact = contact_sharing.idcontact
         GROUP BY contact.idcontact
     				");
     $this->setLog("\n---------\n Users contact: ".$this->getSqlQuery()."\n----------\n");
     $q_insert = new sqlQuery($this->getDbCon());
     while($this->next()) {
     	$q_insert->query("INSERT INTO ".$this->sql_view_name." 
     	                  VALUES (".$this->idcontact.", 
     							  '".addslashes($this->firstname)."',
     							  '".addslashes($this->lastname)."',
     							  '".addslashes($this->company)."',
     							   ".$this->idcompany.",
     							  '".addslashes($this->position)."',
     							  '".$this->picture."',
     							  '".$this->email_address."',
     							  '".$this->phone_number."',
     							  '".addslashes($this->tags)."',
     							  '".$this->when."',
     							  '".$this->created_date."',
     							  '".$this->updatedate."')");		
//.........这里部分代码省略.........
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:101,代码来源:ContactView.class.php

示例8: trim

<?php

/** Ofuz Open Source version is released under the GNU Affero General Public License, please read the full license at: http://www.gnu.org/licenses/agpl-3.0.html **/
// Copyright 2008 - 2010 all rights reserved, SQLFusion LLC, info@sqlfusion.com
/** Ofuz Open Source version is released under the GNU Affero General Public License, please read the full license at: http://www.gnu.org/licenses/agpl-3.0.html **/
/**
 * unsubscribe a user 
 */
include_once "config.php";
$idcontact = (int) $_GET['idc'];
$iduser = (int) trim($_GET['idu']);
$do_contact = new Contact();
//$do_contact->getId($idcontact);
$do_user = new User();
$do_user->getId($iduser);
$do_user->sessionPersistent('user_unsub', 'unsubscribe_message.php', TTL_OFUZ);
$do_contact->query("SELECT * \n                            FROM  contact \n                            WHERE contact.idcontact=" . $idcontact . " AND contact.iduser = " . $iduser);
if ($do_contact->getNumRows() == 0) {
    $do_contact->query("SELECT contact.*\n                            FROM contact, contact_sharing \n                            WHERE `contact_sharing`.`idcoworker` = " . $iduser . "\n                            AND contact.idcontact = contact_sharing.idcontact\n\t\t\t\t\t\t\tAND contact.idcontact=" . $idcontact);
}
if ($do_contact->getNumRows() == 1 && $do_user->getNumRows() == 1) {
    $do_contact->email_optout = 'y';
    $do_contact->update();
    $do_workfeed_uns = new WorkFeedContactUnsubscibeEmails();
    $do_workfeed_uns->addUnsubscribeEmailWorkfeed($do_contact);
}
//$do_contact->sessionPersistent('do_contact', 'unsubscribe_messaage.php', OFUZ_TTL);
header("Location: /unsubscribe_message.php");
exit;
开发者ID:jacquesbagui,项目名称:ofuz,代码行数:29,代码来源:unsubscribe_email.php


注:本文中的Contact::getNumRows方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。