#Gocha#

<?php

// This file keeps track of upgrades to
// the certificate module
//
// Sometimes, changes between versions involve
// alterations to database structures and other
// major things that may break installations.
//
// The upgrade function in this file will attempt
// to perform all the necessary actions to upgrade
// your older installation to the current version.
//
// If there's something it cannot do itself, it
// will tell you what you need to do.
//
// The commands in here will all be database-neutral,
// using the functions defined in lib/ddllib.php

function xmldb_simplecertificate_upgrade($oldversion=0) {
    global $CFG, $DB, $OUTPUT;
    
    $dbman = $DB->get_manager();
    if ($oldversion < 2013053102) {

$table = new xmldb_table('simplecertificate');
        $field = new xmldb_field('disablecode', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'requiredtime');

// Conditionally launch add field disablecode
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('codex', XMLDB_TYPE_INTEGER, '4', null, XMLDB_NOTNULL, null, '10', 'disablecode');

// Conditionally launch add field codex
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('codey', XMLDB_TYPE_INTEGER, '4', null, XMLDB_NOTNULL, null, '10', 'codex');

// Conditionally launch add field codey
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('enablesecondpage', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'codey');

// Conditionally launch add field enablesecondpage
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('secondpagex', XMLDB_TYPE_INTEGER, '4', null, null, null, '10', 'enablesecondpage');

// Conditionally launch add field secondpagex
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('secondpagey', XMLDB_TYPE_INTEGER, '4', null, null, null, '50', 'secondpagex');

// Conditionally launch add field secondpagey
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('secondpagetext', XMLDB_TYPE_TEXT, null, null, null, null, null, 'secondpagey');

// Conditionally launch add field secondpagetext
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('secondpagetextformat', XMLDB_TYPE_TEXT, null, null, null, null, null, 'secondpagetext');

// Conditionally launch add field secondpagetextformat
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('secondimage', XMLDB_TYPE_TEXT, null, null, null, null, null, 'secondpagetextformat');

// Conditionally launch add field secondimage
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

// Changing type of field certdatefmt on table simplecertificate to char
        $field = new xmldb_field('certdatefmt', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, 'certdate');

// Launch change of type for field certdatefmt
        $dbman->change_field_type($table, $field);
        
        
        // Updating old values  (thanks hqhoang for reporting and fix it)
        $sql = 'UPDATE {simplecertificate} SET certdatefmt = :dateformat WHERE certdatefmt = :old_1';
        $DB->execute ( $sql, array('dateformat' => '%B %d, %Y', 'old_1' => '1') );
        
        $sql = 'UPDATE {simplecertificate} SET certdatefmt = :dateformat WHERE certdatefmt = :old_2';
        $DB->execute ( $sql, array('dateformat' => 'F jS, Y', 'old_2' => '2') );
        
        $sql = 'UPDATE {simplecertificate} SET certdatefmt = :dateformat WHERE certdatefmt = :old_3';
        $DB->execute ( $sql, array('dateformat' => '%d %B %Y', 'old_3' => '3') );
        
        $sql = 'UPDATE {simplecertificate} SET certdatefmt = :dateformat WHERE certdatefmt = :old_4';
        $DB->execute ( $sql, array('dateformat' => '%B %Y', 'old_4' => '4') );
        
        $sql = 'UPDATE {simplecertificate} SET certdatefmt = \'\' WHERE certdatefmt = :old_5 OR certdatefmt = :old_6';
        $DB->execute ( $sql, array('old_5' => '5', 'old_6' => '6') );

// simplecertificate savepoint reached
        upgrade_mod_savepoint(true, 2013053102, 'simplecertificate');

}

if ($oldversion < 2013092000) {

// Changing nullability of field certificateimage on table simplecertificate to null.
        $table = new xmldb_table('simplecertificate');
        $field = new xmldb_field('certificateimage', XMLDB_TYPE_TEXT, null, null, null, null, null, 'height');

// Launch change of type for field certificateimage.
        $dbman->change_field_type($table, $field);

// Launch rename field disablecode->printqrcode.
        
        $field = new xmldb_field('disablecode', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '1', 'requiredtime');

if ($dbman->field_exists($table, $field)) {
        	$objs = $DB->get_records('simplecertificate',array("disablecode"=>0),'','id');
        	$ids='';
        	
        	foreach ($objs as $obj) {
        		$ids= $ids . $obj->id .',';
        	}
        	if (!empty($ids)) {
        		$ids=chop($ids,',');
        	
				$sql = 'UPDATE {simplecertificate} SET disablecode = 1 WHERE id in (' . $ids . ')';
				$DB->execute ( $sql );
				
				$sql = 'UPDATE {simplecertificate} SET disablecode = 0 WHERE id not in (' . $ids . ')';
				$DB->execute ( $sql );
        	}

// 	Launch change of default for field.
        	$dbman->change_field_default($table, $field);
	        // Launch rename field printqrcode.
    	    $dbman->rename_field($table, $field, 'printqrcode');
        } else {
        	$field = new xmldb_field('printqrcode', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '1', 'requiredtime');
        	if (!$dbman->field_exists($table, $field)) {
        		$dbman->add_field($table, $field);
        	}
        }

$field = new xmldb_field('qrcodefirstpage', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'printqrcode');

// Conditionally launch add field qrcodefirstpage.
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

$field = new xmldb_field('savecert');

// Conditionally launch drop field savecert.
        if ($dbman->field_exists($table, $field)) {
            $dbman->drop_field($table, $field);
        }

$table = new xmldb_table('simplecertificate_issues');
    	$field = new xmldb_field('certificatename', XMLDB_TYPE_TEXT, null, null, null, null, null, 'userid');
    	
    	// Conditionally launch add field certificatename.
    	if (!$dbman->field_exists($table, $field)) {
    		$dbman->add_field($table, $field);
    	}
    	
    	$field = new xmldb_field('username');
    	
    	// Conditionally launch drop field username.
    	if ($dbman->field_exists($table, $field)) {
    		$dbman->drop_field($table, $field);
    	}
    	
    	$field = new xmldb_field('coursename');
    	
    	// Conditionally launch drop field coursename.
    	if ($dbman->field_exists($table, $field)) {
    		$dbman->drop_field($table, $field);
    	}
    	
    	//Populating certificatename
    	$certs = $DB->get_records('simplecertificate');
    	foreach ($certs as $cert) {
    		$DB->execute('UPDATE {simplecertificate_issues} SET certificatename = ? WHERE certificateid = ?', array($cert->name, $cert->id));
    	}
    	
    	// Simplecertificate savepoint reached.
    	upgrade_mod_savepoint(true, 2013092000, 'simplecertificate');
    }
    
    if ($oldversion < 2013111900) {
    	
    	//Certdate update
    	$objs = $DB->get_records('simplecertificate',array("certdate"=>1),'','id');
    	$objs = $objs + $DB->get_records('simplecertificate',array("certdate"=>2),'','id');
        $ids='';
		        	
        foreach ($objs as $obj) {
        	$ids= $ids . $obj->id .',';
        }
        if (!empty($ids)) {
        	$ids = chop($ids,',');
        	$sql = 'UPDATE {simplecertificate} SET certdate = -1 * certdate where id in (' . $ids . ')';
    		$DB->execute ($sql);
    	
        }
        
        //Certgrade update
        $objs = $DB->get_records('simplecertificate',array("certgrade"=>1),'','id');
        $ids='';
         
        foreach ($objs as $obj) {
        	$ids= $ids . $obj->id .',';
        }
        if (!empty($ids)) {
        	$ids = chop($ids,',');
        	$sql = 'UPDATE {simplecertificate} SET certdate = -1 * certgrade where id in (' . $ids . ')';
        	$DB->execute ($sql);
        }
        
    	// Simplecertificate savepoint reached.
    	upgrade_mod_savepoint(true, 2013111900, 'simplecertificate');
    }
    if ($oldversion < 2013112500) {
	    // Changing the default of field certdate on table simplecertificate to -2.
    	$table = new xmldb_table('simplecertificate');
    	$field = new xmldb_field('certdate', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '-2', 'outcome');
    
	    // Launch change of default for field certdate.
    	$dbman->change_field_default($table, $field);
    	
    	$field = new xmldb_field('emailothers', XMLDB_TYPE_TEXT, null, null, null, null, null, 'emailfrom');
    	
    	// Launch change of nullability for field emailothers.
    	$dbman->change_field_notnull($table, $field);
    
	    // Simplecertificate savepoint reached.
    	upgrade_mod_savepoint(true, 2013112500, 'simplecertificate');
    }
    
    if ($oldversion < 2013112901) {
    
    	// Define field coursename to be added to simplecertificate_issues.
    	$table = new xmldb_table('simplecertificate_issues');
    	$field = new xmldb_field('coursename', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, 'timedeleted');
    
    	// Conditionally launch add field coursename.
    	if (!$dbman->field_exists($table, $field)) {
    		$dbman->add_field($table, $field);
    	}
    	$sql= 'UPDATE {simplecertificate_issues} set coursename = (select fullname from {course} where id = (select course from {simplecertificate} where id = certificateid)) where timedeleted is null';
    	$DB->execute($sql);
    	 
    
    	// Simplecertificate savepoint reached.
    	$field = new xmldb_field('haschange', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'coursename');
    
    	// Conditionally launch add field haschange.
    	if (!$dbman->field_exists($table, $field)) {
    		$dbman->add_field($table, $field);
    	}
    	
    	$sql = 'UPDATE {simplecertificate_issues} SET haschange = 1';
    	$DB->execute($sql);
    	
    
    	// Simplecertificate savepoint reached.
    	upgrade_mod_savepoint(true, 2013112901, 'simplecertificate');
    }
    // v2.1.3
    if ($oldversion < 2014051000) {
        
        // Define field timestartdatefmt to be added to simplecertificate.
        $table = new xmldb_table('simplecertificate');
        $field = new xmldb_field('timestartdatefmt', XMLDB_TYPE_CHAR, '255', null, null, null, '', 'secondimage');
        
        // Conditionally launch add field timestartdatefmt.
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
  	
    	$table = new xmldb_table('simplecertificate_issues');
    	
    	$field = new xmldb_field('haschange', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'timedeleted');
    	
    	// Conditionally launch add field haschange.
    	if (!$dbman->field_exists($table, $field)) {
    	    $dbman->add_field($table, $field);
    	}
    	
    	
    	$field = new xmldb_field('pathnamehash', XMLDB_TYPE_CHAR, '40', null, null, null, null, 'haschange');
    	if (!$dbman->field_exists($table, $field)) {
    		$dbman->add_field($table, $field);
    	}
    	//Must move files to new area and add the certificate files hashs
    	$issuedcerts = $DB->get_records('simplecertificate_issues');
    	$countcerts = count($issuedcerts);
    	
    	$fs = get_file_storage();
    	
    	$pbar = new progress_bar('simplecertificatemoveissuedfiles', 500, true);
    	$i = 0;
    	foreach ($issuedcerts as $issued) {
    	    $i++;
    	    try {
    	        $courseid = $DB->get_field('simplecertificate', 'course', array('id' => $issued->certificateid ), MUST_EXIST);
    	        $cm = get_coursemodule_from_instance('simplecertificate', $issued->certificateid, $courseid, false, MUST_EXIST);
    	        $context = context_module::instance($cm->id);
    	                        
                if ($user = $DB->get_record("user", array('id' => $issued->userid))) {
                    $filename = str_replace(' ', '_', clean_filename($issued->certificatename . ' ' . fullname($user) . ' ' . $issued->id . '.pdf'));
                } else {
                    $filename = str_replace(' ', '_', clean_filename($issued->certificatename . ' ' . $issued->id . '.pdf'));
                }
                
                $fileinfo = array('contextid' => $context->id,
                                'component' => 'mod_simplecertificate', 
                                'filearea' => 'issues',
                                'itemid' => $issued->id,
                                'filepath' => '/',
                                'filename' => $filename);
                
                if ($fs->file_exists($fileinfo['contextid'], $fileinfo['component'], $fileinfo['filearea'], 
                                    $fileinfo['itemid'], $fileinfo['filepath'], $fileinfo['filename'])) {
                                      
                    $file = $fs->get_file($fileinfo['contextid'], $fileinfo['component'], $fileinfo['filearea'], 
                                        $fileinfo['itemid'], $fileinfo['filepath'], $fileinfo['filename']);
                        
                    $fileinfo['filename'] = str_replace(' ', '_', clean_filename($issued->certificatename .' '. $issued->id . '.pdf'));
                        
                    if ($newfile = $fs->create_file_from_storedfile($fileinfo, $file)) {
                        $file->delete();
                        $issued->pathnamehash = $newfile->get_pathnamehash();
                    }
                } else {
                   throw new Exception('File not found');
                }
            } catch (Exception $e) {
                if (empty($issued->timedeleted)) {
                    $issued->haschange = 1;
                }
                $issued->pathnamehash = '';
            }
            $pbar->update($i, $countcerts, "Moving Issued certificate files  ($i/$countcerts)");
            if (!$DB->update_record('simplecertificate_issues', $issued)) {
                print_error('upgradeerror', 'simplecertificate', null, "Can't update an issued certificate [id->$issued->id]");
            }
           
    	}
    	
    	$field = new xmldb_field('pathnamehash', XMLDB_TYPE_CHAR, '40', null, XMLDB_NOTNULL, null, null, 'haschange');
    	
    	// Launch change of nullability for field pathnamehash.
    	$dbman->change_field_notnull($table, $field);
    	
    	
    	$field = new xmldb_field('coursename');
    	
    	// Conditionally launch drop field coursename.
    	if ($dbman->field_exists($table, $field)) {
    	    $dbman->drop_field($table, $field);
    	}
    	  
    	// Simplecertificate savepoint reached.
    	upgrade_mod_savepoint(true, 2014051000, 'simplecertificate');
    }
    return true;
}