GMAndroid/app/src/main/java/com/ivalentin/gm/AlbumLayout.java

package com.ivalentin.gm;

import android.annotation.SuppressLint;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.os.Bundle;
import android.app.Fragment;
import android.app.FragmentManager;
import android.app.FragmentTransaction;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.webkit.WebView;
import android.widget.ImageView;
import android.widget.LinearLayout;
import android.widget.TextView;

import java.io.File;
import java.util.Locale;

/**
 * Fragment to display photos of a selected album.
 * Album id is passed in a bundle.
 * Album name is also passed, to be displayed on photos with no title.
 * Everything is done when the view is inflated.
 *
 * @author Iñigo Valentin
 *
 * @see Fragment
 *
 */
public class AlbumLayout extends Fragment {

    //Main View
    //private View view;

    //private String currLang;
	//private String albumName;

    @SuppressLint("InflateParams") //Throws unknown error when done properly.
    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {

        //Load the layout
        View view = inflater.inflate(R.layout.fragment_layout_album, null);

        //Get bundled id
        Bundle bundle = this.getArguments();
        int id = bundle.getInt("album", -1);
        if (id == -1){
			Log.e("Album error", "No such album: " + id);
			this.getActivity().onBackPressed();
        }

        //Get data from database
        SQLiteDatabase db = getActivity().openOrCreateDatabase(GM.DB_NAME, Context.MODE_PRIVATE, null);
        final Cursor cursor;
        String currLang = Locale.getDefault().getDisplayLanguage();
        if (!currLang.equals("es") && !currLang.equals("eu")){
            currLang = "en";
        }
        cursor = db.rawQuery("SELECT id, name_" + currLang + " AS name, description_" + currLang + " AS description FROM album WHERE id = " + id + ";", null);
        cursor.moveToFirst();

        //Set album elements
        TextView tvTitle = (TextView) view.findViewById(R.id.tv_album_title);
        WebView tvDescription = (WebView) view.findViewById(R.id.wv_album_description);
        tvTitle.setText(cursor.getString(1));
		final String albumName = cursor.getString(1);
        if (cursor.getString(2).length() < 1){
            tvDescription.setVisibility(View.GONE);
        }
        else {
            tvDescription.loadDataWithBaseURL(null, cursor.getString(2), "text/html", "utf-8", null);
        }
		cursor.close();


        //Assign elements
        LinearLayout llList = (LinearLayout) view.findViewById(R.id.ll_album_list);
        LinearLayout entry;

        //An inflater
        LayoutInflater factory = LayoutInflater.from(getActivity());

        String image;
        Cursor imageCursor = db.rawQuery("SELECT id, title_" + currLang + " AS title, file, width, height FROM photo, photo_album WHERE photo = id AND album = " + id + " ORDER BY uploaded DESC;", null);
        while (imageCursor.moveToNext()){
            //Create a new row
            entry = (LinearLayout) factory.inflate(R.layout.row_album, null);

			//Set left and right layouts
			LinearLayout left = (LinearLayout) entry.findViewById(R.id.ll_row_album_left);

            //Set title
            TextView tvTitleLeft = (TextView) entry.findViewById(R.id.tv_row_album_title_left);
			if (imageCursor.getString(1).length() > 0) {
				tvTitleLeft.setText(imageCursor.getString(1));
			}
			else{
				tvTitleLeft.setVisibility(View.GONE);
			}

            //Set id
            TextView tvHiddenLeft = (TextView) entry.findViewById(R.id.tv_row_album_hidden_left);
            tvHiddenLeft.setText(imageCursor.getString(0));

            //Set image
            ImageView ivLeft = (ImageView) entry.findViewById(R.id.iv_row_album_left);
            image = imageCursor.getString(2);

            //Check if image exists
            File f;
            f = new File(this.getActivity().getFilesDir().toString() + "/img/galeria/preview/" + image);
            if (f.exists()){
                //If the image exists, set it.
                Bitmap myBitmap = BitmapFactory.decodeFile(this.getActivity().getFilesDir().toString() + "/img/galeria/preview/" + image);
                ivLeft.setImageBitmap(myBitmap);
            }
            else {
                //If not, create directories and download asynchronously
                File fpath;
                fpath = new File(this.getActivity().getFilesDir().toString() + "/img/galeria/preview/");
                if(fpath.mkdirs()) {
					new DownloadImage(GM.SERVER + "/img/galeria/preview/" + image, this.getActivity().getFilesDir().toString() + "/img/galeria/preview/" + image, ivLeft).execute();
				}
            }

			//Count comments
			Cursor cursorComments = db.rawQuery("SELECT id FROM photo_comment WHERE photo = " + imageCursor.getString(0) + ";", null);
			TextView tvCommentsLeft = (TextView) entry.findViewById(R.id.tv_row_album_comments_left);
			tvCommentsLeft.setText(cursorComments.getCount());
			cursorComments.close();

			//Set onClickListener
			left.setOnClickListener(new View.OnClickListener(){
				@Override
				public void onClick(View v) {
				//Toast.makeText(getActivity(), "OPENING POST", Toast.LENGTH_LONG).show();
				Fragment fragment = new PhotoLayout();
				Bundle bundle = new Bundle();
				//Pass post id
				int id = Integer.parseInt(((TextView) v.findViewById(R.id.tv_row_album_hidden_left)).getText().toString());
				bundle.putInt("photo", id);
				bundle.putString("albumName", albumName);
				fragment.setArguments(bundle);

				FragmentManager fm = AlbumLayout.this.getActivity().getFragmentManager();
				FragmentTransaction ft = fm.beginTransaction();

				ft.replace(R.id.activity_main_content_fragment, fragment);
				ft.addToBackStack("photo_" + id);
				ft.commit();
				}
			});
            
            //If odd pass, to the right line
            if (imageCursor.moveToNext()){

                LinearLayout right = (LinearLayout) entry.findViewById(R.id.ll_row_album_right);
                right.setVisibility(View.VISIBLE);

                //Set title
                TextView tvTitleRight = (TextView) entry.findViewById(R.id.tv_row_album_title_right);
				if (imageCursor.getString(1).length() > 0) {
					tvTitleRight.setText(imageCursor.getString(1));
				}
				else{
					tvTitleRight.setVisibility(View.GONE);
				}

                //Set id
                TextView tvHiddenRight = (TextView) entry.findViewById(R.id.tv_row_album_hidden_right);
                tvHiddenRight.setText(imageCursor.getString(0));

                //Set image
                ImageView ivRight = (ImageView) entry.findViewById(R.id.iv_row_album_right);
                image = imageCursor.getString(2);
                //Check if image exists
                f = new File(this.getActivity().getFilesDir().toString() + "/img/galeria/preview/" + image);
                if (f.exists()){
                    //If the image exists, set it.
                    Bitmap myBitmap = BitmapFactory.decodeFile(this.getActivity().getFilesDir().toString() + "/img/galeria/preview/" + image);
                    ivRight.setImageBitmap(myBitmap);
                }
                else {
                    //If not, create directories and download asynchronously
                    File fpath;
                    fpath = new File(this.getActivity().getFilesDir().toString() + "/img/galeria/preview/");
                    if(fpath.mkdirs()) {
						new DownloadImage(GM.SERVER + "/img/galeria/preview/" + image, this.getActivity().getFilesDir().toString() + "/img/galeria/preview/" + image, ivRight).execute();
					}
                }

				//Count comments
				cursorComments = db.rawQuery("SELECT id FROM photo_comment WHERE photo = " + imageCursor.getString(0) + ";", null);
				TextView tvCommentsRight = (TextView) entry.findViewById(R.id.tv_row_album_comments_right);
				tvCommentsRight.setText(cursorComments.getCount());
				cursorComments.close();

				//Set onClickListener
				right.setOnClickListener(new View.OnClickListener(){
					@Override
					public void onClick(View v) {
					Fragment fragment = new PhotoLayout();
					Bundle bundle = new Bundle();
					//Pass post id
					int id = Integer.parseInt(((TextView) v.findViewById(R.id.tv_row_album_hidden_right)).getText().toString());
					bundle.putInt("photo", id);
					bundle.putString("albumName", albumName);
					fragment.setArguments(bundle);

					FragmentManager fm = AlbumLayout.this.getActivity().getFragmentManager();
					FragmentTransaction ft = fm.beginTransaction();

					ft.replace(R.id.activity_main_content_fragment, fragment);
					ft.addToBackStack("photo_" + id);
					ft.commit();
					}
				});
            }

            llList.addView(entry);
        }

        imageCursor.close();
        db.close();
        return view;
    }
}