public function trade_status_2()
{
$this->db->select('*');
$this->db->from('db_kunde');
$this->db->join('db_trade_protokoll', 'db_trade_protokoll.tb_trade_protokoll_kunde = db_kunde.tb_kunde_id');
$this->db->where('db_trade_protokoll.tb_trade_protokoll_status = 2');
$query = $this->db->get();
return $query->result_array();
}
public function trade_status_2_karte()
{
function kartenname($name_de, $name_en, $switch)
{
switch ($switch)
{
case 1:
echo $name_de;
break;
case 2:
echo $name_de;
break;
case 3:
echo $name_en;
break;
case 4:
echo $name_en;
break;
case 5:
echo $name_en;
break;
default:
break;
}
}
$this->db->select('*');
$this->db->from('db_karten_trade');
$this->db->join('db_edition_stats', 'db_edition_stats.tb_edition_stats_id = db_karten_trade.tb_karten_trade_edition_stats');
$this->db->join('db_edition', 'db_edition.tb_edition_id = db_edition_stats.tb_edition_stats_edition');
$this->db->join('db_ygo_karten_stats', 'db_ygo_karten_stats.tb_ygo_karten_stats_id = db_karten_trade.tb_karten_trade_karten_stats');
$this->db->join('db_qualitat', 'db_qualitat.tb_qualitat_id = db_karten_trade.tb_karten_trade_qualitat');
$this->db->join('db_sprache', 'db_sprache.tb_sprache_id = db_karten_trade.tb_karten_trade_sprache');
$this->db->join('db_rare', 'db_rare.tb_rare_id = db_edition_stats.tb_edition_stats_rare');
$this->db->join('db_auflage', 'db_auflage.tb_auflage_id = db_karten_trade.tb_karten_trade_auflage');
$this->db->where('db_karten_trade.tb_karten_trade_anzahl > 0');
$this->db->where('db_karten_trade.tb_karten_trade_status = 2');
$query = $this->db->get();
return $query->result_array();
}
public function insert_status_2()
{
// $data = array( 'tb_karte_datum' => date('Y.m.d H:i:s'),
// 'tb_karte_karten_stats' => $this->input->post('add_kast'),
// );
// $this->db->insert('db_karte', $data);
foreach ($this->input->post('add_kast') as $karten_stats)
{
$data = array( 'tb_karte_datum' => date('Y.m.d H:i:s'),
'tb_karte_karten_stats' => $karten_stats,
);
$this->db->insert('db_karte', $data);
}
}