如何检查同一ID在另一列中是否有多个值？ [英] How to check same id have multiple values in another column?

问题描述

我有团队成员表和团队表。
在team member table中，有3列是teamid，staff_id和stafftype（领导者或技术员）。一队只有一名领导者（staff_type列值）。因此，当我向团队成员表中插入数据时，我需要检查同一团队中是否有任何领导者。

i have team member table and team table. In team member table have , three columns are there teamid, staff_id and stafftype(leader or technician). Only one leader (staff_type column value) will comes in one team. So when i insert data to team member table i need to check whether any leader is there in same team.

如何显示一条错误消息，已经有领导者了团队？

How to show an error message that "already have leader in this team"?

team_id   staff_id   stafftype
1          2        leader
2          1        other
3          8        other
1          5        Technician
2          3        Other
1          4        Leader //This should not come. becoz already teamid-1 have Leader When trying to save from frond end, need to show error message ie;"already have leader in this team"

模式

  public function addteam_memb($datas){

    $this->db->select('*');
    $this->db->from('team_members');
    $querySS = $this->db->get()->result();

    if(array_search('1', array_column($querySS, 'team_id')) !== false) {
    return 1;
}
 else {
    $insert_id = 0;
    if ( ! empty($datas))
    {
      $this->db->insert('team_members', $datas);
      $insert_id = $this->db->insert_id();
    }
 }

 }

控制器

public function editteammember(){

    $getaddstafftype = $this->input->post( 'getaddstafftype' );
    $getaddstaffname = $this->input->post( 'getaddstaffname' );
    $getteamid = $this->input->post('getteamid');
    $getstatus = $this->input->post('getstatus');

    //if ( ! empty($getaddstaffname) ) 
    if ( ! empty($getaddstaffname) && ! empty($getaddstafftype) ) 
{
    foreach ($getaddstaffname as $key => $value ) 
    {
        $data['Staff_id'] = $value;
        $data['Staff_type'] = $getaddstafftype[$key];
        $data['team_id'] = $getteamid[$key];
        $data['status'] = "active";
      $value = $this->mastertable_model->addteam_memb($data);

    }

    if($value == 1)
        {
            echo "Already have leader in this team";
        }
        else
        {
            //$this->load->view('team_memb_creation');        
        }

} 

}

推荐答案

模型：

   public function add_team_memb(){


    $this->db->select('NEXT VALUE FOR team_seq as team_id');
    $query = $this->db->get();

    foreach ($query->result_array() as $row) {
        $team_id = $row['team_id'];
    }

    $this->db->select('*');
    $this->db->from('team_member');
    $querySS = $this->db->get()->result();

    if(array_search('1', array_column($querySS, 'team_id')) !== false) {

        return 1;
    }
    else {

        $datateam_memb = array(
            'team_id' => $team_id,
            'staff_id' => 3,
            'stafftype' => 'leader',

        );
        $insert_id = 0;
        if ($this->db->insert("team_member", $datateam_memb)) {
            $insert_id = $this->db->insert_id();
        }
        return $team_id;

    }


}

控制器::

 public function addteammember()
{

    $value = $this->Admin_model->add_team_memb();

    if($value == 1)
    {
        ///pass message in view leader is already in team
    }
    else
    {
        $this->load->view('team_memb_creation');        
    }

}

这篇关于如何检查同一ID在另一列中是否有多个值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！