Module OnePage V1.4

titoun · 23 Januar 2022, 18:52:15

Bonsoir les amis

J'aimerai inclure dans l'administration du module OnePage V1.4 une image dans une table bd qui change au clique.

pour cette image

Un peu comme dans l'administration du module pmxSlider !

J'ai fait un tas de test mais je n'y arrive pas

Code Auswählen

defined('mxMainFileLoaded') or die('access denied');

/* Sprachdatei auswählen */
mxGetLangfile(dirname(__FILE__));

if (!mxGetAdminPref('radminsuper')) {
    mxErrorScreen("Access Denied");
    die();
}

// mxSessionSetVar('panel', MX_ADMINPANEL_CONTENT);

function messages()
{
    global $language, $prefix;
    $img_delete = mxCreateImage("images/delete.gif", _DELETE, 0, 'title="' . _DELETE . '"');
	$img_new = mxCreateImage("images/new.gif", _NOUVEAU, 0, 'title="' . _NOUVEAU . '"');

    include("header.php");
    GraphicAdmin();
    title(_MESSAGESADMIN);
    OpenTable();
    echo '
    <table class="full list">
      <thead>
        <tr>
          <th>' . _ID . '</th>
          <th>' . _COURSE . '</th>		  
          <th>' . _NOM . '</th>
          <th>' . _PRENOM . '</th>
          <th>' . _MAIL . '</th>	
          <th>' . _PORTABLE . '</th>
          <th>' . _PASSAGER . '</th>
          <th>' . _DEPART . '</th>
          <th>' . _DESTINATION . '</th>		  	  		  
          <th>' . _REF . '</th>
          <th>' . _COMMANTAIRE . '</th>
		  <th>' . _CPAM . '</th>
          <th>' . _ACTION . '</th>
        </tr>
      </thead>
      <tbody>';
    $class = '';
    $out = '';
    $result = sql_query("select id_devis, date, ref, qte, contenu, nom, prenom, fonction, societe, cp, mail, tel, saisie from devis ORDER BY id_devis DESC");
    while (list($id_devis, $date, $ref, $qte, $contenu, $nom, $prenom, $fonction, $societe, $cp, $mail, $tel, $saisie) = sql_fetch_row($result)) {
        $class = ($class == '') ? ' class="alternate-a"' : '';
        $out .= '
        <tr' . $class . '>
          <td>' . $id_devis . '</td>
          <td>' . $fonction . '</td>
		  <td>' . $nom . '</td>
          <td>' . $prenom .'</td>
          <td>' . $mail . '</td>
          <td>' . $tel . '</td>
          <td>' . $qte . '</td>
		  <td>' . $societe . '</td>
		  <td>' . $cp . '</td>
          <td>' . $ref . '</td>
          <td>' . $contenu . '</td>
		  <td>' . $saisie . '</td>
          <td>
		    <a href="' . adminUrl(PMX_MODULE, 'nouveau', 'id_devis=' . $id_devis) . '">' . $img_new . '</a>
            <a href="' . adminUrl(PMX_MODULE, 'delete', 'id_devis=' . $id_devis) . '">' . $img_delete . '</a>
          </td>
        </tr>';
    }
    if ($out) {
        echo $out;
    } else {
        echo '
        <tr><td colspan="6"></td></tr>';
    }
    echo '
      </tbody>
    </table>';
    CloseTable();
    
    include("footer.php");
}


function deletemsg($id_devis, $ok = 0)
{
    global $prefix;
    if ($ok) {
        $result = sql_query("delete from devis where id_devis=" . intval($id_devis) . "");
        if (!$result) {
            return;
        }
        mxRedirect(adminUrl(PMX_MODULE));
    } else {
        include("header.php");
        GraphicAdmin();
        title(_MESSAGESADMIN);

        OpenTableAl();
        echo "<center>" . _REMOVEMSG;
        echo "<br /><br />[&nbsp;<a href=\"" . adminUrl(PMX_MODULE) . "\">" . _NO . "</a> | <a href=\"" . adminUrl(PMX_MODULE, 'delete', 'id_devis=' . $id_devis . '&amp;ok=1') . "\">" . _YES . "</a>&nbsp;]</center>";
        CloseTableAl();
        include("footer.php");
    }
}
switch ($op) {


    case PMX_MODULE . "/delete":
        $ok = (empty($_REQUEST['ok'])) ? 0 : $_REQUEST['ok'];
        deletemsg($id_devis, $ok);
        break;

    default:
        messages();
        break;
}

?>

Pouvez-vous m'aider ?

Merci d'avance et à bientôt

Olaf / TerraProject · 23 Januar 2022, 19:11:39

see the file: modules/pmxSlider/admin/admin.php in line 173. This is the Code for this image

Code Auswählen

$img_activate = mxCreateImage('images/adminform/accept.png', _ACTIVATE, array('title' => _DEACTIVATE,"style"=>'width:16px;height:16px;'));

titoun · 30 Januar 2022, 15:24:14

Bon dimanche les ami(e)s

J'ai cherché...cherché, encore cherché

Puis j'y suis arriver

Pour que cela fonctionne bien, il faut depuis le fichier: modules/pmxSlider/admin/admin.php

ligne: 93

Code Auswählen

	function main($act,$id)
	{
		global $module_name;
		
		$error="";
		$info=$module_name;
		$form="";
		$tb = load_class('AdminForm', "adminFormMain");
		
		switch ($act)
		{
			case "activate":
				$id=intval($id);
				$this->_activate($id);
				break;
			case "deactivate":
				$id=intval($id);
				$this->_deactivate($id);
				break;
		}

ligne: 170

Code Auswählen

		$img_activate = mxCreateImage('images/adminform/accept.png', _ACTIVATE, array('title' => _DEACTIVATE,"style"=>'width:16px;height:16px;'));
		$img_deactivate = mxCreateImage('images/adminform/cancel.png', _DEACTIVATE, array('title' => _ACTIVATE,"style"=>'width:16px;height:16px;'));

ligne:179

Code Auswählen

$action_set=
                    '<a href="admin.php?op='.$module_name.'&amp;act='.(($value['active']==0)?"activate":"deactivate").'&amp;id='.$value['nr'].'" title="">'.
					(($value['active']==0)?$img_deactivate:$img_activate).'</a>&nbsp;';

ligne:617

Code Auswählen

	private function _activate($nr)
	{
			$qry ="UPDATE ".$this->_tablename." SET active='1'";
			$qry .=" WHERE nr=".intval($nr)."";
			//mxDebugFuncVars($qry);
			if ($qry) pmxDatabase::system_query($qry);		
	}	

	private function _deactivate($nr)
	{
			$qry ="UPDATE ".$this->_tablename." SET active='0'";
			$qry .=" WHERE nr=".intval($nr)."";
			//mxDebugFuncVars($qry);
			if ($qry) pmxDatabase::system_query($qry);		
	}

Puis adapté les champs exemple
ligne: 164

Code Auswählen

array("name"=>mxText("_ACTIVE"),"attr"=>"style='width:50px'"),

C'était pas facile

A présent j'aimerais ajouter une 3ème image.

J'ai créé une nouvelle classe pour que cela soit plus simple dans le fichier:
includes/classes/AdminForm.php

voir ligne 846

Code Auswählen

			//Titoun
		    case "anvane":
                $class = self::extract_class($fextern);
                $fextern = self::get_attributes_from_array($fextern);
                $forminput = "<div class=\"forminputline{$class}\">";
                $forminput .= $inputlabel;
                $forminput .= "<div {$linestyle2}>";
                $forminput .= "<select name=\"" . $ffieldname . "\" size=\"2\"  id=\"" . $inputid . "\" title=\"" . $fdesc . "\" " . $fextern . " >
		<option value=\"2\"" . (($fvalue == 1) ? ' selected="selected" class="current"' : '') . ">" . _ANVANE3 . "</option>
                <option value=\"1\"" . (($fvalue == 1) ? ' selected="selected" class="current"' : '') . ">" . _ANVANE2 . "</option>
                <option value=\"0\"" . (($fvalue != 1) ? ' selected="selected" class="current"' : '') . ">" . _ANVANE1 . "</option>
                </select>";
                $forminput .= "</div><div {$linestyle3}>" . $fdescription . "</div>";
                $forminput .= "</div>";
                break;

puis modifier les codes cités plus haut. Mais je bloque ici je n'arrive pas a adapter ce boue de code avec l'option value 2

Code Auswählen

<option value=\"2\"" . (($fvalue == 1) ? ' selected="selected" class="current"' : '') . ">" . _ANVANE3 . "</option>
dans le code d'origine du module pmxSlider
modules/pmxSlider/admin/admin.php in line 179

Code Auswählen

$action_set=
                    '<a href="admin.php?op='.$module_name.'&amp;act='.(($value['active']==0)?"activate":"deactivate").'&amp;id='.$value['nr'].'" title="">'.
					(($value['active']==0)?$img_deactivate:$img_activate).'</a>&nbsp;';

PS: ma 3ème image est

Code Auswählen

$img_option3 = mxCreateImage('images/adminform/cxl.png', _OPTION3, array('title' => _OPTION3,"style"=>'width:36px;height:12px;'));

Pouvez-vous m'aider Olaf ?

Merci d'avance et à bientôt

Olaf / TerraProject · 31 Januar 2022, 07:46:48

Veuillez écrire en anglais ou en allemand

Merci

So you want to map 3 states. Each click advances one state. is it there what you mean? Or something else?
What should happen if you click on the picture1/picture2/picture3 ?

titoun · 31 Januar 2022, 09:16:31

Hello Olaf

Zitat von: Olaf am 31 Januar 2022, 07:46:48
So you want to map 3 states. Each click advances one state. is it there what you mean?

Yes that's fine

Zitat von: Olaf am 31 Januar 2022, 07:46:48
What should happen if you click on the picture1/picture2/picture3 ?

Here is my current code

Code Auswählen

$action_set=
                    '<a href="admin.php?op='.$module_name.'&amp;act='.(($value['active']==0)?"activate":"deactivate").'&amp;id='.$value['id_devis'].'" title="">'.(($value['active']==0)?$img_deactivate:$img_activate).(($value['active']==0)?$img_option3:$img_activate).'</a>&nbsp;';

Code Auswählen

		switch ($act)
		{
			case "option3":
				$id=intval($id);
				$this->_option3($id);
				break;
			case "activate":
				$id=intval($id);
				$this->_activate($id);
				break;
			case "deactivate":
				$id=intval($id);
				$this->_deactivate($id);
				break;
		}

Code Auswählen

		$values=array();
		$img_option3 = mxCreateImage('images/adminform/cxl.png', _OPTION3, array('title' => _OPTION3,"style"=>'width:36px;height:12px;'));
		$img_activate = mxCreateImage('images/adminform/valide.png', _ACTIVATE, array('title' => _DEACTIVATE,"style"=>'width:36px;height:12px;'));
		$img_deactivate = mxCreateImage('images/adminform/nouveau.gif', _DEACTIVATE, array('title' => _ACTIVATE,"style"=>'width:36px;height:12px;'));

Code Auswählen

	private function _option3($id_devis)
	{
			$qry ="UPDATE ".$this->_tablename." SET active='2'";
			$qry .=" WHERE id_devis=".intval($id_devis)."";
			//mxDebugFuncVars($qry);
			if ($qry) pmxDatabase::system_query($qry);		
	}
	
	private function _activate($id_devis)
	{
			$qry ="UPDATE ".$this->_tablename." SET active='1'";
			$qry .=" WHERE id_devis=".intval($id_devis)."";
			//mxDebugFuncVars($qry);
			if ($qry) pmxDatabase::system_query($qry);		
	}	

	private function _deactivate($id_devis)
	{
			$qry ="UPDATE ".$this->_tablename." SET active='0'";
			$qry .=" WHERE id_devis=".intval($id_devis)."";
			//mxDebugFuncVars($qry);
			if ($qry) pmxDatabase::system_query($qry);		
	}

Thanks a lot for your help Olaf

See you soon

Olaf / TerraProject · 01 Februar 2022, 07:07:23

is your problem solved now?

titoun · 01 Februar 2022, 14:18:24

Not yet olaf

Olaf / TerraProject · 01 Februar 2022, 14:56:50

ok for my understanding

Data new => Status=2
Data active => Status=1
Data inactive => status=0

order of clicks
Data is generated - first status = 2
Click on image "new" => Data active = Status=1
another click => switch between active and inactive
Is that correct?

titoun · 01 Februar 2022, 15:33:03

that's ok thanks in advance for the help Olaf

titoun · 03 Februar 2022, 17:50:59

Good evening Olaf

In fact I can not adapt this code.

Code Auswählen

$action_set=
                    '<a href="admin.php?op='.$module_name.'&amp;act='.(($value['active']==0)?"activate":"deactivate").'&amp;id='.$value['id_devis'].'" title="">'.(($value['active']==0)?$img_deactivate:$img_activate).'</a>&nbsp;';

I think for the rest is correct.

Olaf / TerraProject · 04 Februar 2022, 07:09:21

.... ?

Code Auswählen


'<a href="admin.php?op='.$module_name.'&amp;act='.(($value['active']==2)?"new":(($value['active']==0)?"activate":"deactivate")).'&amp;id='.$value['id_devis'].'" title="">'.
						  (($value['active']==2)?$img_option3:(($value['active']==0)?$img_activate:$img_deactivate)).'</a>&nbsp;';

more clearly.....

Code Auswählen


switch ($value['active'])
{
	case 1:
		$aact="deactivate";
		$aimg=$img_deactivate;
		break;
	case 2:	
		$aact="new";
		$aimg=$img_new;
		break;
	default:	
		$aact="activate";
		$aimg=$img_activate;
		break;

}

$link= '<a href="admin.php?op='.$module_name.'&amp;act='.$aact.'&amp;id='.$value['id_devis'].'" title="">'.$aimg.'</a>&nbsp;';

titoun · 04 Februar 2022, 16:28:12

Hello

It works fine for me

This is the reason why I love our system PragmaMx

Thank you very much for the precious help Olaf