<?php
require_once('phpcassa/connection.php');
require_once('phpcassa/columnfamily.php');

function get_top($rep){
$conn = new Connection('tolmai');

$column_family= new ColumnFamily($conn,'tm');

//Languages array
$arr= array( 1 => "ActionScript", 2 => "ADA" ,3 => "asp" , 4 =>"AspectJ"  ,5 => "Assembly", 6 => "autoIt",7 => "awk", 8 => "bash", +
			9 => "Batch" , 10 => "C",11 => "C++",12 => "C#",13 => "Caml", 14 => "CMakeFile" , 15 => "CUDA",16 => "CSS", 17 => "COBOL", +
			18=>"D",19=>"DIFF",20=>"Dos Style",21=> "Dos Style",22=> "Fortran",23=> "Fortran",24=> "Haskell",25=> "HTML",26=>"Ini file",27=>"InnoSetup", +
			28=> "Java",29=> "JavaScript",30=> "JSP",31=> "KiXtart",32=> "LISP",33=> "Lua",34=>"Makefile",35=>"Matlab",36=>"NSIS", +
			37=>"Objective-C",38=> "Pascal",39=> "Perl",40=>"Php",41=> "Portugol",42=> "Postscript",43=> "PowerShell",44=> "Python", +
			45=>"R",46=> "RC",47=> "Ruby" ,48=> "Scheme",49=> "Smaltalk" ,50=>"SQL" ,50=> "TCL" ,51=>"TeX",52=> "VB/VBS",53=> "Verilog",54=> "VHDL",55=> "XML",+
			56=>"n/a", 57=>"Delphi/Kylix",58=>"Vala",59=>"Object Pascal",60=>"Common Lisp");

$converted_array = array_map("strtoupper", $arr);

$temp = new ColumnFamily($conn, 'temp'); // ColumnFamily
//
//for ($i = 1; $i <= $counter; $i++ ){
$index_Git = CassandraUtil::create_index_expression('tm_repository',$rep);
$index_clause_Git = CassandraUtil::create_index_clause(array($index_Git),'', $column_count=1);
$rows = $column_family->get_indexed_slices($index_clause_Git);
foreach($rows as $key => $columns) {
	
	$temp-> insert($key,array("tm_fullname" => $columns['tm_fullname']));
    $temp-> insert($key,array("tm_source" => $columns['tm_source']));
    $temp-> insert($key,array("tm_repository" => $columns['tm_repository']));
    $temp-> insert($key,array("tm_language_P" => $columns['tm_language_P']));
    $temp-> insert($key,array("tm_language_S" => $columns['tm_language_S']));
    $temp-> insert($key,array("tm_language_T" => $columns['tm_language_T']));
    $temp-> insert($key,array("tm_author" => $columns['tm_author']));
    $temp-> insert($key,array("tm_date_c" => $columns['tm_date_c']));
    $temp-> insert($key,array("tm_date_l" => $columns['tm_date_l']));
    $temp-> insert($key,array("tm_logo" => $columns['tm_logo']));
   
}
//}
//lang counter array
$arr_lang = array();
//limit
$counter = count($arr);

//------------------- Search language ----------------
for ($i = 1; $i <= $counter; $i++ ){

//--Lang_P search --
$index_exp = CassandraUtil::create_index_expression('tm_language_P',$converted_array[$i]);
$index_clause = CassandraUtil::create_index_clause(array($index_exp),'', $column_count=10000);
$rows = $temp->get_indexed_slices($index_clause);
// returns an Iterator over;

//language Counter
$count =0;
foreach($rows as $key => $columns) {
    //count matches
	$count++;
   
}

//--Lang_S search --
$index_exp = CassandraUtil::create_index_expression('tm_language_S',$converted_array[$i]);
$index_clause = CassandraUtil::create_index_clause(array($index_exp));
$rows = $column_family->get_indexed_slices($index_clause);
// returns an Iterator over;

foreach($rows as $key => $columns) {
    //count matches
	$count++;
   
}

//--Lang_T search --
$index_exp = CassandraUtil::create_index_expression('tm_language_T',$converted_array[$i]);
$index_clause = CassandraUtil::create_index_clause(array($index_exp));
$rows = $column_family->get_indexed_slices($index_clause);
// returns an Iterator over;


foreach($rows as $key => $columns) {
    //count matches
	$count++;
   
}
//--------------- End Search language ----------------
//assume key - language
$lang = $converted_array[$i];
//add to lang counter array
$arr_lang[$lang] = $count;

}


//sort array
arsort($arr_lang);

return ($arr_lang);
}


?>