public function actionLista($id, $idPlat)
{
$nomePlat = Platforms::model()->findByPk($idPlat);
$model = new Characteristic('searchLista');
$model->unsetAttributes();
// clear any default values
//if(Yii::app()->request->isAjaxRequest){
if (isset($_POST['confirm'])) {
if (isset($_POST['selectedIds'])) {
// print_r($_POST['selectedIds']);
foreach ($_POST['selectedIds'] as $idT) {
$array1[] = $idT;
}
foreach ($array1 as $VETOR) {
$connection = Yii::app()->db;
// $querido = "SELECT test_case.id FROM test_case WHERE id_characteristic =" .$VETOR ;
$querido = "SELECT TC.id FROM test_case as TC LEFT JOIN test_platform\n ON TC.id = test_platform.id_test_case \n WHERE test_platform.id_platform = " . $idPlat . " AND TC.id_characteristic = " . $VETOR;
$commando = $connection->createCommand($querido);
$vetorTesteEscolhido = $commando->query();
foreach ($vetorTesteEscolhido as $vetorzinho) {
$meuDeus[] = $vetorzinho["id"];
}
}
$connection = Yii::app()->db;
$MY = "SELECT test_case.id FROM test_case LEFT JOIN test_platform ON test_case.id = test_platform.id_test_case WHERE test_case.id_characteristic IS NULL AND test_platform.id_platform = " . $idPlat;
$commando = $connection->createCommand($MY);
$tentativa = $commando->query();
foreach ($tentativa as $vamo) {
$value[] = $vamo['id'];
}
$result = array_merge($value, $meuDeus);
$test = json_encode($value);
$que = json_encode($meuDeus);
$mara = json_encode($result);
foreach ($result as $key) {
if ($key != "") {
$id_testcase = $key;
$id_runs = $id;
$connection = Yii::app()->db;
$command = $connection->createCommand("INSERT INTO `test_run`(`id_runs`, `id_test_case`, `status`) VALUES (" . $id_runs . "," . $key . ",0)");
$rowCount = $command->execute();
}
}
$this->redirect(array('runs/view', 'id' => $id));
// $this->redirect(array("/runs/Teste/","que"=>$que,"test"=>$test, "mara"=>$mara));
}
}
$this->render('lista', array('model' => $model, 'idPlat' => $idPlat, 'nomePlat' => $nomePlat));
}
