PHP Companies::findAll方法代码示例

 /**
  * Return favorite companies
  *
  * @param void
  * @return array
  */
 static function getFavorites()
 {
     return Companies::findAll(array('conditions' => array('`is_favorite` = ?', 1), 'order' => '`id`'));
 }

 /**
  * Return company clients
  *
  * @param Company $company
  * @return array
  */
 static function getCompanyClients(Company $company)
 {
     return Companies::findAll(array('conditions' => array('`client_of_id` = ?', $company->getId()), 'order' => '`name`'));
     // array
 }

    if ($do == "edit") {
        if (!empty($id)) {
            $sql = "SELECT c.*,m.username,m.membergroup_id,m.credits FROM {$tb_prefix}companies c LEFT JOIN {$tb_prefix}members m ON c.member_id=m.id WHERE c.id=" . $id;
            $res = $pdb->GetRow($sql);
            $r1 = $industry->disSubOptions($res['industry_id'], "industry_");
            $r2 = $area->disSubOptions($res['area_id'], "area_");
            $res = am($res, $r1, $r2);
            setvar("item", $res);
            $selected['properties'] = explode(",", $res['manage_type']);
            setvar("SelectedManageType", $selected['properties']);
            $selected['markets'] = explode(",", $res['main_market']);
            setvar("SelectedMarket", $selected['markets']);
        }
        uaAssign(array("CompanyProperty" => $_PB_CACHE['economic_type'], "ManageTypes" => $_PB_CACHE['manage_type'], "MainMarkets" => $_PB_CACHE['main_market'], "CompanyFunds" => $_PB_CACHE['reg_fund'], "CompanyAnual" => $_PB_CACHE['year_annual'], "LinkmanPositions" => $_PB_CACHE['position'], "EmployeeAmounts" => $_PB_CACHE['employee_amount'], "Genders" => $_PB_CACHE['gender']));
        $tpl_file = "company.edit";
        template($tpl_file);
        exit;
    }
}
$fields = "Company.id,m.space_name,Company.cache_spacename,m.membergroup_id,m.credits,member_id,m.username,Company.name AS CompanyName,Company.status AS CompanyStatus,Company.created AS pubdate,Company.if_commend,Company.area_id,industry_id,cache_credits";
$total_amount = $pdb->CacheGetOne(120, "SELECT COUNT(id) AS amount FROM " . $tb_prefix . "companies WHERE status='0'");
$amount = $company->findCount(null, $conditions, "Company.id");
$page->setPagenav($amount);
$joins = array();
$joins[] = "LEFT JOIN {$tb_prefix}members m ON m.id=Company.member_id";
if (empty($lists)) {
    $lists = $company->findAll($fields, $joins, $conditions, "Company.id DESC", $page->firstcount, $page->displaypg);
}
setvar("Items", $lists);
uaAssign(array("ByPages" => $page->pagenav, "TotalAmount" => $total_amount));
template($tpl_file);

 function allowed_users_view_events()
 {
     $comp_array = array();
     $actual_user_id = isset($_GET['user']) ? $_GET['user'] : logged_user()->getId();
     $wspace_id = isset($_GET['ws_id']) ? $_GET['ws_id'] : 0;
     $ws = Projects::findByCSVIds($wspace_id);
     $evid = array_var($_GET, 'evid');
     $companies = Companies::findAll();
     $i = 0;
     foreach ($companies as $comp) {
         $users = $comp->getUsersOnWorkspaces($ws);
         if (is_array($users)) {
             foreach ($users as $k => $user) {
                 // removing event creator from notification list
                 $keep = false;
                 foreach ($ws as $w) {
                     if (can_read_type($user, $w, 'ProjectEvents')) {
                         $keep = true;
                     }
                 }
                 if (!$keep) {
                     unset($users[$k]);
                 }
             }
             if (count($users) > 0) {
                 $comp_data = array('id' => $i++, 'object_id' => $comp->getId(), 'name' => $comp->getName(), 'logo_url' => $comp->getLogoUrl(), 'users' => array());
                 foreach ($users as $user) {
                     $comp_data['users'][] = array('id' => $user->getId(), 'name' => $user->getDisplayName(), 'avatar_url' => $user->getAvatarUrl(), 'invited' => $evid == 0 ? $user->getId() == $actual_user_id : EventInvitations::findOne(array('conditions' => "`event_id` = {$evid} and `user_id` = " . $user->getId())) != null, 'mail' => $user->getEmail());
                 }
                 $comp_array[] = $comp_data;
             }
         }
     }
     $object = array("totalCount" => count($comp_array), "start" => 0, "companies" => array());
     $object['companies'] = $comp_array;
     ajx_extra_data($object);
     ajx_current("empty");
 }

 function getAssignableCompanies($project = null)
 {
     if ($this->isMemberOfOwnerCompany()) {
         return Companies::getCompaniesWithUsers();
     }
     TimeIt::start('get assignable companies');
     if ($project instanceof Project) {
         $ws = $project->getAllSubWorkspacesQuery(true);
     }
     $uid = $this->getId();
     $cid = $this->getCompany()->getId();
     $tp = TABLE_PREFIX;
     $gids = "SELECT `group_id` FROM `{$tp}group_users` WHERE `user_id` = {$uid}";
     $q1 = "SELECT `project_id` FROM `{$tp}project_users` WHERE (`user_id` = {$uid} OR `user_id` IN ({$gids})) AND `can_assign_to_other` = '1'";
     $q2 = "SELECT `project_id` FROM `{$tp}project_users` WHERE (`user_id` = {$uid} OR `user_id` IN ({$gids})) AND `can_assign_to_owners` = '1'";
     if (isset($ws)) {
         $q1 .= " AND `project_id` IN ({$ws})";
         $q2 .= " AND `project_id` IN ({$ws})";
     }
     $query1 = "SELECT `user_id` FROM `{$tp}project_users` WHERE `project_id` IN ({$q1})";
     $query2 = "SELECT `user_id` FROM `{$tp}project_users` WHERE `project_id` IN ({$q2})";
     $query = "SELECT `company_id` FROM `{$tp}users` WHERE `id` IN ({$query1}) AND `company_id` <> 1 AND `company_id` <> {$cid} OR `id` IN ({$query2}) AND `company_id` = 1";
     // get companies for assignable users (see getAssignableUsers)
     $companies = Companies::findAll(array('conditions' => "`id` = {$cid} OR `id` IN ({$query})"));
     TimeIt::stop();
     return $companies;
 }

function allowed_users_to_assign($wsid)
{
    $ws = Projects::findById($wsid);
    $comp_array = array();
    $companies = Companies::findAll();
    if ($companies != null) {
        foreach ($companies as $comp) {
            if ($ws != null) {
                $users = $comp->getUsersOnProject($ws);
            } else {
                continue;
            }
            if (is_array($users)) {
                foreach ($users as $k => $user) {
                    // if logged_user can assign tasks to user and user can read tasks the user is allowed
                    if (!can_assign_task(logged_user(), $ws, $user) || !can_read_type($user, $ws, 'ProjectTasks')) {
                        unset($users[$k]);
                    }
                }
                if (count($users) > 0) {
                    $comp_data = array('id' => $comp->getId(), 'name' => $comp->getName(), 'users' => array());
                    foreach ($users as $user) {
                        $comp_data['users'][] = $user->getArrayInfo();
                    }
                    //if ($ws == null || can_assign_task(logged_user(), $ws, $comp)) {
                    if (count($users) > 0) {
                        $comp_array[] = $comp_data;
                    }
                }
            }
        }
    }
    return $comp_array;
}