English 中文(简体)
糖业 查阅:
原标题:SugarCRM Get Last Email Date and Search on it
  • 时间:2012-01-12 16:56:31
  •  标签:
  • php
  • sugarcrm

因此,我很晚才与糖业委员会广泛合作,我需要能够显示最后一次联系点被电子邮件到来,以及根据早前的联系被电子邮件查询。

我可以轻而易举地树立逻辑,以获得最后的电子邮件日期,但我无法根据这一日期的价值进行查询。

因此,我看着搜索场。 The php and found the following Code whichoch have the email of the Liaison.

 email  => 
  array (
     query_type  =>  default ,
     operator  =>  subquery ,
     subquery  =>  SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE ,
     db_field  => 
    array (
      0 =>  id ,
    ),
  ),

我决定利用这一数据建立一个新阵列,其代码如下,以达到最后的电子邮件日期。 显然,如果接触经过多次电子邮件,需要加以分类,或者需要做些事情才能获得最后一份电子邮件。

 last_email_c  => 
  array (
     query_type  =>  default ,
     operator  =>  subquery ,
     subquery  =>  SELECT e.date_sent FROM emails e WHERE e.parent_type =  Contacts  AND e.parent_id =  {0}  ,
     db_field  => 
    array (
      0 =>  id ,
    ),
  ),

我的问题是,我不知道与这一新的分局有何关系,我在清单和查询表中做了检查,不能发现任何提及这两个习俗的搜索领域。

我失踪了什么?

问题回答




相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签