protected function execute($arguments = array(), $options = array())
{
if ( !$options['appmin'] || !$options['appmax'] || ($options['appmin'] > $options['appmax']))
{
throw new Exception("invalid option: ");
}
$databaseManager = new sfDatabaseManager($this->configuration);
$this->conn = $databaseManager->getDatabase('doctrine')->getDoctrineConnection();
$sql = 'SELECT id FROM application';
$appIds = $this->conn->fetchColumn($sql);
$sql = 'SELECT id FROM member WHERE is_active != 0';
$where = array();
if ( $options['min'] && $options['max'] && $options['min'] <= $options['max'])
{
$sql .= ' AND id BETWEEN ? AND ?';
$where = array(intval($options['min']),intval($options['max']));
}
$memberIds = $this->conn->fetchColumn($sql, $where);
foreach ($memberIds as $memberid)
{
$appids = $this->setrandomappid($appIds, $options['appmin'], $options['appmax']);
foreach ($appids as $application_id)
{
$sql = 'SELECT id FROM member_application WHERE member_id = ? AND application_id = ?';
$where = array(intval($memberid), intval($application_id));
$ma = $this->conn->fetchOne($sql, $where);
if (!$ma)
{
$memberApplication = new MemberApplication();
$memberApplication->setMemberId($memberid);
$memberApplication->setApplicationId($application_id);
$memberApplication->setPublicFlag('public');
$memberApplication->save();
$memberApplication->free();
$this->logSection('member_application', sprintf("%s - %s", $memberid, $application_id));
}
}
}
}
/**
* add this application to member
*
* @param Member $member
* @param array $applicationSettings
* @param array $reason
* @return MemberApplication
*/
public function addToMember(Member $member, $applicationSettings = array(), $reason = null)
{
$memberApplication = Doctrine::getTable('MemberApplication')->findOneByApplicationAndMember($this, $member);
if (!$memberApplication) {
$memberApplication = new MemberApplication();
$memberApplication->setApplication($this);
$memberApplication->setMember($member);
$memberApplication->save();
// to use Lifecycle Event (event.addapp)
$params = array('memberApplication' => $memberApplication, 'reason' => $reason);
$event = new sfEvent($this, 'op_opensocial.addapp', $params);
sfContext::getInstance()->getEventDispatcher()->notify($event);
}
foreach ($applicationSettings as $name => $value) {
$memberApplication->setApplicationSetting($name, $value);
}
$invites = Doctrine::getTable('ApplicationInvite')->findByApplicationIdAndToMemberId($this->getId(), $member->getId());
$invites->delete();
return $memberApplication;
}