Thursday, March 21, 2019

Lenovo Flex 15 Wifi Interface Disappearance in Linux Mint

This happens around a kernel update 4.15.0-43-generic.


inxi -Fxz
System:
Host: jnguyen-Lenovo-Ideapad-Flex-15 Kernel: 4.15.0-43-generic x86_64
bits: 64 compiler: gcc v: 7.3.0 Desktop: Cinnamon 4.0.9
Distro: Linux Mint 19.1 Tessa base: Ubuntu 18.04 bionic
Machine:
Type: Laptop System: LENOVO product: 20309 v: Lenovo Ideapad Flex 15
serial: <filter>
Mobo: LENOVO model: Strawberry 5D v: 31900003Std serial: <filter>
UEFI [Legacy]: LENOVO v: 8ACN08WW date: 08/22/2013
Battery:
ID-1: BAT1 charge: 35.4 Wh condition: 35.4/43.4 Wh (82%)
model: SANYO L12S4F01 status: Full
CPU:
Topology: Dual Core model: Intel Core i7-4500U bits: 64 type: MT MCP
arch: Haswell rev: 1 L2 cache: 4096 KiB
flags: lm nx pae sse sse2 sse3 sse4_1 sse4_2 ssse3 vmx bogomips: 19156
Speed: 1129 MHz min/max: 800/3000 MHz Core speeds (MHz): 1: 1764 2: 1711
3: 1786 4: 1738
Graphics:
Device-1: Intel Haswell-ULT Integrated Graphics vendor: Lenovo
driver: i915 v: kernel bus ID: 00:02.0
Display: x11 server: X.Org 1.19.6 driver: modesetting unloaded: fbdev,vesa
resolution: 1366x768~60Hz
OpenGL: renderer: Mesa DRI Intel Haswell Mobile v: 4.5 Mesa 18.2.2
direct render: Yes
Audio:
Device-1: Intel Haswell-ULT HD Audio vendor: Lenovo driver: snd_hda_intel
v: kernel bus ID: 00:03.0
Device-2: Intel 8 Series HD Audio vendor: Lenovo driver: snd_hda_intel
v: kernel bus ID: 00:1b.0
Sound Server: ALSA v: k4.15.0-43-generic
Network:
Device-1: Realtek RTL810xE PCI Express Fast Ethernet vendor: Lenovo
driver: r8169 v: 2.3LK-NAPI port: 3000 bus ID: 01:00.0
IF: enp1s0 state: down mac: <filter>
Device-2: Intel Wireless 7260 driver: iwlwifi v: kernel port: 3000
bus ID: 02:00.0
IF: wlp2s0 state: up mac: <filter>
Drives:
Local Storage: total: 465.76 GiB used: 420.56 GiB (90.3%)
ID-1: /dev/sda vendor: Seagate model: ST500LM000-1EJ162 size: 465.76 GiB
Partition:
ID-1: / size: 450.23 GiB used: 420.56 GiB (93.4%) fs: ext4 dev: /dev/sda2
ID-2: swap-1 size: 7.73 GiB used: 0 KiB (0.0%) fs: swap dev: /dev/sda3
Sensors:
System Temperatures: cpu: 52.0 C mobo: N/A
Fan Speeds (RPM): N/A
Info:
Processes: 242 Uptime: 6m Memory: 7.52 GiB used: 1.17 GiB (15.5%)
Init: systemd runlevel: 5 Compilers: gcc: 7.3.0 Shell: bash v: 4.4.19
inxi: 3.0.27


rfkill list
0: ideapad_wlan: Wireless LAN
Soft blocked: no
Hard blocked: no
1: ideapad_bluetooth: Bluetooth
Soft blocked: yes
Hard blocked: no
2: hci0: Bluetooth
Soft blocked: yes
Hard blocked: no
3: phy0: Wireless LAN
Soft blocked: no
Hard blocked: no

Solution

echo "options iwlwifi swenc=Y ips=N" | sudo tee /etc/modprobe.d/iwlwifi.conf
or
sudo apt-get remove bcmwl-kernel-source && sudo apt-get install firmware-b43-installer


Reboot 

Posted by at

Monday, February 11, 2019

PowerSchool Transportation Reports



File: ssis_transportation.html
<!DOCTYPE html>
<html>
<!-- start right frame -->
<head>
    <title>Transportation</title>
    ~[wc:UI_js_includes]
    ~[wc:commonscripts]
    <link href="/images/css/screen.css" rel="stylesheet" media="screen">
    <link href="/images/css/print.css" rel="stylesheet" media="print">


</head>
<body>
    ~[wc:admin_header_frame_css]
 
    <!-- breadcrumb start -->
    <a href="/admin/home.html" target="_top">~[text:psx.html.admin_students.unlimitedcontacts.start_page]</a> &gt;
    <a href="home.html?selectstudent=nosearch" target="_top">~[text:psx.html.admin_students.unlimitedcontacts.student_selection]</a> &gt;
    Transportation Roster
    <!-- breadcrumb end -->
 
    ~[wc:admin_navigation_frame_css]

<!-- start of title and student content -->


<table width="100%">
<tr>
<td background="/images/transparent.gif">

<!-- title -->
<h1>Transportation Roster</h1>
<!-- title -->


<form name="searchform" action="ssis_transportation.html" method="GET" style="float:left;width:100%">
<table>
<tr>
                        <td  style="background-color:white;">Filter by Bus: </td>
<td style="background-color:white;">
<a href="ssis_transportation.html?busnumber=Bus 1">Bus 1</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 2">Bus 2</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 3">Bus 3</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 4">Bus 4</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 5">Bus 5</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 6">Bus 6</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 7">Bus 7</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Bus 8">Bus 8</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 1">Van 1</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 2">Van 2</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 3">Van 3</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 4">Van 4</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 5">Van 5</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 6">Van 6</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=Van 7">Van 7</a>&nbsp;|&nbsp;
<a href="ssis_transportation.html?busnumber=ALL">ALL</a>
</td>

</tr>
</table>
</form>

<br><br>
<p id="demo" style="font-size: 1.5em;">Driver and Monitor Information Replaced Here.</p>
<script type="text/javascript">

if ('~(gpv.busnumber)'=='Bus 1') {
  document.getElementById("demo").innerHTML = "Driver: Dang Cong Minh (84) 93-356-9755 | Monitor: Dang Thi Thu Hong (84) 93-267-8310";
} else if ('~(gpv.busnumber)'=='Bus 2') {
  document.getElementById("demo").innerHTML = "Driver: Mr. Lam (84) 90-690-6030 | Monitor: Le Thi Hoang (84) 93-240-1677";
} else if ('~(gpv.busnumber)'=='Bus 3') {
  document.getElementById("demo").innerHTML = "Driver: Duong Hoang Hai (84) 93-262-3161 | Monitor: Nguyen Thi Huong Lan (84) 93-839-3678";
} else if ('~(gpv.busnumber)'=='Bus 4') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Thanh Long (Minh) (84) 90-909-5221 | Monitor: Le Thi My Ngoc (84) 96-183-0728";
} else if ('~(gpv.busnumber)'=='Bus 5') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Huu Duc (84) 90-217-4558 | Monitor: Tran Thi Thu Thao (84) 90-286-0135";
} else if ('~(gpv.busnumber)'=='Bus 6') {
  document.getElementById("demo").innerHTML = "Driver: Pham Anh Tuan (84) 93-867-7970 | Monitor: Nguyen Le Kim Thuy (84) 126-711-5315";
} else if ('~(gpv.busnumber)'=='Bus 7') {
  document.getElementById("demo").innerHTML = "Driver: Tran Chi Linh (84) 98-853-0258 | Monitor: Ho Thi Thu Trang (84) 90-648-3441";
} else if ('~(gpv.busnumber)'=='Bus 8') {
  document.getElementById("demo").innerHTML = "Driver: Mr. Binh (84) 92-444-6698 | Monitor: Lu Vi Thuy (84) 93-760-3832";
} else if ('~(gpv.busnumber)'=='Van 1') {
  document.getElementById("demo").innerHTML = "Driver: Duong Quang Hieu (84) 90-316-2641 | Monitor: Nguyen Ngoc (84) 93-805-0819";
} else if ('~(gpv.busnumber)'=='Van 2') {
  document.getElementById("demo").innerHTML = "Driver: Mr. Phong (84) 91-914-7306 | Monitor: Phuong Thi My Dung (84) 93-803-2507";
} else if ('~(gpv.busnumber)'=='Van 3') {
  document.getElementById("demo").innerHTML = "Driver: Pham Phuc Dai (84) 90-939-3472 | Monitor: Tran Thi Han Hoan (84) 91-553-3467";
} else if ('~(gpv.busnumber)'=='Van 4') {
  document.getElementById("demo").innerHTML = "Driver: Vu Thai Hong (Long) (84) 91-360-1602 | Monitor: Duong Thi Lanh (84) 90-314-9296";
} else if ('~(gpv.busnumber)'=='Van 5') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Hoang Thich (84) 93-402-6073 | Monitor: Duong Thi Hien (84) 93-785-4299";
} else if ('~(gpv.busnumber)'=='Van 6') {
  document.getElementById("demo").innerHTML = "Driver: Le Hoang An (84) 91-803-1819 | Monitor: Luong Thi Thu Yen (84) 90-253-2862";
} else if ('~(gpv.busnumber)'=='Van 7') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Tan Buu (84) 90-589-6220 | Monitor: Phan Thi Kim Cuc (84) 93-834-2083";
} else {
  document.getElementById("demo").innerHTML = ".";
}
</script>

<table id="transportationExport" class="grid" style="width:100%">
<tr>
  <th width='300px'></th>
  <th>StudentID</th>
  <th>Students</th>
  <th>Grade/Gender<br>HR Teacher</th>
  <th>Address</th>
  <th colspan=2>Contact Information</th>
  <th>Special Instructions</th>
</tr>


~[tlist_sql;
WITH ROUTE AS (
  SELECT t.BUSNUMBER AS BUSNUMBER, s.ID AS STUDENTDCID,
    TO_CHAR(TRUNC(t.departuretime/3600),'FM9900') || chr(58) ||
    TO_CHAR(TRUNC(MOD(t.departuretime,3600)/60),'FM00') ||
    ' ' || TO_CHAR(t.address) AS T_ADDRESS,
    s.STUDENT_NUMBER as STUDENT_NUMBER,
    s.LASTFIRST AS STUDENTLASTFIRST,
    DECODE(s.grade_level,0,'K',-2,'EC3',-1,'EC4',TRIM(TO_CHAR(s.grade_level))) AS GRADE,
    s.gender AS GENDER,
    u.SSIS_HR_TEACHER AS HR_TEACHER,
    s.street || '&lt;br&gt;' || u.ssis_student_ward || ', ' || u.ssis_student_district || '&lt;br&gt;' || s.city  AS ADDRESS,
    TO_CHAR(t.SPECIALINSTRUCTIONS) AS SPECIALINSTRUCTIONS,
    ROW_NUMBER() OVER (PARTITION BY t.BUSNUMBER ORDER BY t.BUSNUMBER)AS RN
  FROM TRANSPORTATION t
    INNER JOIN STUDENTS s ON s.id=t.STUDENTID
    INNER JOIN U_StudentsUserFields u ON s.DCID = u.StudentsDCID
  WHERE s.ENROLL_STATUS =0
  AND t.fromto = 'To'
  ~[if#1.~(gpv.busnumber)=]
        /* NO bus number provided. */
        AND t.busnumber = 'zzz'
  [else#1]
      ~[if#2.~(gpv.busnumber)=ALL]
          AND t.busnumber LIKE '%'
      [else#2]
      /* Bus number provided. . */
      AND t.busnumber = ('~[gpv:busnumber]')
      [/if#2]
  [/if#1]
),
StudentsParents AS (
    SELECT DISTINCT
        DECODE(co.ContactRelationship,'Mother','M','Father','F','Step-Mother','M','Step-Father','F','X') ContactRelationship,
        co.StudentDCID AS STUDENTDCID,
        co.ContactLastFirst,
        pp.PhoneNumberasentered,
        e.EmailAddress
    FROM
        PSSIS_STU_Contact_Act_Emerg co
        LEFT JOIN PSSIS_Person_Phone pp on pp.PersonID = co.ContactPersonID AND pp.isPreferred = 1
        LEFT JOIN PSSIS_Person_Email e  on e.PersonID  = co.ContactPersonID AND e.isPrimaryEmailAddress = 1
    WHERE co.ContactRelationship in ('Mother','Step-Mother','Father','Step-Father')
)
SELECT ID, BUSNUMBER,
       MONITORDETAIL,
       STUDENT_NUMBER, STUDENTLASTFIRST, GRADE, GENDER,
       HR_TEACHER,
       ADDRESS,
       Mother,
       Father,
       SPECIALINSTRUCTIONS
FROM(
   SELECT RN AS ID, BUSNUMBER,
          '&lt;font size=4&gt;&lt;strong&gt;' || BUSNUMBER || '&lt;/strong&gt;&lt;/font&gt;' ||
          '&lt;br&gt; .'  as MONITORDETAIL,
          0 AS STUDENT_NUMBER, '' AS STUDENTLASTFIRST, '' AS GRADE, '' AS GENDER,
          '' AS HR_TEACHER,
          '' AS ADDRESS,
          '' AS SPECIALINSTRUCTIONS,
          '' AS Mother,
          '' AS Father,
          'Group' As RowType
   FROM ROUTE r
    LEFT JOIN StudentsParents m ON r.StudentDCID = m.StudentDCID AND m.ContactRelationship = 'M'
    LEFT JOIN StudentsParents f ON r.StudentDCID = f.StudentDCID AND f.ContactRelationship = 'F'
   WHERE RN = 1
   UNION ALL
   SELECT RN AS ID, BUSNUMBER,
          T_ADDRESS AS MONITORDETAIL,
          STUDENT_NUMBER, STUDENTLASTFIRST, GRADE, GENDER,
          HR_TEACHER,
          ADDRESS,
          SPECIALINSTRUCTIONS,
          m.ContactLastFirst || '&lt;br&gt;' || m.PhoneNumberasentered || '&lt;br&gt;' || m.EmailAddress AS Mother,
          f.ContactLastFirst || '&lt;br&gt;' || f.PhoneNumberasentered || '&lt;br&gt;' || f.EmailAddress AS Father,
          'Item' As RowType
   FROM ROUTE r
    LEFT JOIN StudentsParents m ON r.StudentDCID = m.StudentDCID AND m.ContactRelationship = 'M'
    LEFT JOIN StudentsParents f ON r.StudentDCID = f.StudentDCID AND f.ContactRelationship = 'F'
)X
ORDER BY BUSNUMBER ASC
, CASE WHEN RowType='Group' THEN 0 ELSE 1 END ASC
, MONITORDETAIL ASC
, STUDENTLASTFIRST ASC
;]
  <tr>
    <td style="display:none"> ~(ID) </td>
    <td style="display:none"> ~(BUSNUMBER) </td>
    <td>~(MONITORDETAIL)</td>
    <td> ~(STUDENT_NUMBER)</td>
    <td> ~(STUDENTLASTFIRST)</td>
    <td>~(GRADE) / ~(GENDER) <br> ~(HR_TEACHER)</td>
    <td> ~(ADDRESS)</td>
    <td> ~(Mother)</td>
    <td> ~(Father)</td>
    <td> ~(SPECIALINSTRUCTIONS)</td>
  </tr>

[/tlist_sql]

</table>
<!-- end of title and student content -->

</body>
</html>



File: ssis_transportation_attendance.html

<!DOCTYPE html>
<html>
<!-- start right frame -->
<head>
    <title>Transportation Attendance</title>
    ~[wc:UI_js_includes]
    ~[wc:commonscripts]
    <link href="/images/css/screen.css" rel="stylesheet" media="screen">
    <link href="/images/css/print.css" rel="stylesheet" media="print">


</head>
<body>
    ~[wc:admin_header_frame_css]
 
    <!-- breadcrumb start -->
    <a href="/admin/home.html" target="_top">~[text:psx.html.admin_students.unlimitedcontacts.start_page]</a> &gt;
    <a href="home.html?selectstudent=nosearch" target="_top">~[text:psx.html.admin_students.unlimitedcontacts.student_selection]</a> &gt;
    Transportation Attendance
    <!-- breadcrumb end -->
 
    ~[wc:admin_navigation_frame_css]

<!-- start of title and student content -->


<table width="100%">
<tr>
<td background="/images/transparent.gif">

<!-- title -->
<h1>Transportation Attendance</h1>
<h3>Period Coverage: ____________________________</h3>
<!-- title -->


<form name="searchform" action="ssis_transportation_attendance.html" method="GET" style="float:left;width:100%">
<table>
<tr>
      <td  style="background-color:white;">Filter by Bus: </td>
<td style="background-color:white;">
<a href="ssis_transportation_attendance.html?busnumber=Bus 1">Bus 1</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 2">Bus 2</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 3">Bus 3</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 4">Bus 4</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 5">Bus 5</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 6">Bus 6</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 7">Bus 7</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Bus 8">Bus 8</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 1">Van 1</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 2">Van 2</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 3">Van 3</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 4">Van 4</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 5">Van 5</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 6">Van 6</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=Van 7">Van 7</a>&nbsp;|&nbsp;
<a href="ssis_transportation_attendance.html?busnumber=ALL">ALL</a>
</td>

</tr>
</table>
</form>

<br><br>
<p id="demo" style="font-size: 1.5em;">Driver and Monitor Information Replaced Here.</p>
<script type="text/javascript">

if ('~(gpv.busnumber)'=='Bus 1') {
  document.getElementById("demo").innerHTML = "Driver: Dang Cong Minh (84) 93-356-9755 | Monitor: Dang Thi Thu Hong (84) 93-267-8310";
} else if ('~(gpv.busnumber)'=='Bus 2') {
  document.getElementById("demo").innerHTML = "Driver: Mr. Lam (84) 90-690-6030 | Monitor: Le Thi Hoang (84) 93-240-1677";
} else if ('~(gpv.busnumber)'=='Bus 3') {
  document.getElementById("demo").innerHTML = "Driver: Duong Hoang Hai (84) 93-262-3161 | Monitor: Nguyen Thi Huong Lan (84) 93-839-3678";
} else if ('~(gpv.busnumber)'=='Bus 4') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Thanh Long (Minh) (84) 90-909-5221 | Monitor: Le Thi My Ngoc (84) 96-183-0728";
} else if ('~(gpv.busnumber)'=='Bus 5') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Huu Duc (84) 90-217-4558 | Monitor: Tran Thi Thu Thao (84) 90-286-0135";
} else if ('~(gpv.busnumber)'=='Bus 6') {
  document.getElementById("demo").innerHTML = "Driver: Pham Anh Tuan (84) 93-867-7970 | Monitor: Nguyen Le Kim Thuy (84) 126-711-5315";
} else if ('~(gpv.busnumber)'=='Bus 7') {
  document.getElementById("demo").innerHTML = "Driver: Tran Chi Linh (84) 98-853-0258 | Monitor: Ho Thi Thu Trang (84) 90-648-3441";
} else if ('~(gpv.busnumber)'=='Bus 8') {
  document.getElementById("demo").innerHTML = "Driver: Mr. Binh (84) 92-444-6698 | Monitor: Lu Vi Thuy (84) 93-760-3832";
} else if ('~(gpv.busnumber)'=='Van 1') {
  document.getElementById("demo").innerHTML = "Driver: Duong Quang Hieu (84) 90-316-2641 | Monitor: Nguyen Ngoc (84) 93-805-0819";
} else if ('~(gpv.busnumber)'=='Van 2') {
  document.getElementById("demo").innerHTML = "Driver: Mr. Phong (84) 91-914-7306 | Monitor: Phuong Thi My Dung (84) 93-803-2507";
} else if ('~(gpv.busnumber)'=='Van 3') {
  document.getElementById("demo").innerHTML = "Driver: Pham Phuc Dai (84) 90-939-3472 | Monitor: Tran Thi Han Hoan (84) 91-553-3467";
} else if ('~(gpv.busnumber)'=='Van 4') {
  document.getElementById("demo").innerHTML = "Driver: Vu Thai Hong (Long) (84) 91-360-1602 | Monitor: Duong Thi Lanh (84) 90-314-9296";
} else if ('~(gpv.busnumber)'=='Van 5') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Hoang Thich (84) 93-402-6073 | Monitor: Duong Thi Hien (84) 93-785-4299";
} else if ('~(gpv.busnumber)'=='Van 6') {
  document.getElementById("demo").innerHTML = "Driver: Le Hoang An (84) 91-803-1819 | Monitor: Luong Thi Thu Yen (84) 90-253-2862";
} else if ('~(gpv.busnumber)'=='Van 7') {
  document.getElementById("demo").innerHTML = "Driver: Nguyen Tan Buu (84) 90-589-6220 | Monitor: Phan Thi Kim Cuc (84) 93-834-2083";
} else {
  document.getElementById("demo").innerHTML = ".";
}
</script>

<table id="transportationExport" class="grid" style="width:100%">
<tr>
  <th>Monitor</th>
  <th>Students</th>
  <th>Grade</th>
  <th>Gender</th>
  <th>HR Teacher</th>
  <th colspan=2>MON</th>
  <th colspan=2>TUE</th>
  <th colspan=2>WED</th>
  <th colspan=2>THU</th>
  <th colspan=2>FRI</th>
  <th>Special Instruction</th>
</tr>
<tr>
  <td colspan=5></td>
  <td>AM</td>
  <td>PM</td>
  <td>AM</td>
  <td>PM</td>
  <td>AM</td>
  <td>PM</td>
  <td>AM</td>
  <td>PM</td>
  <td>AM</td>
  <td>PM</td>
</tr>

~[tlist_sql;
 WITH ROUTE AS (
  SELECT t.BUSNUMBER AS BUSNUMBER,
    '.' AS MONITOR,
    s.LASTFIRST AS STUDENTLASTFIRST,
    DECODE(s.grade_level,0,'K',-2,'EC3',-1,'EC4',TRIM(TO_CHAR(s.grade_level))) AS GRADE,
    s.gender AS GENDER,
    u.SSIS_HR_TEACHER AS HR_TEACHER,
    TO_CHAR(t.SPECIALINSTRUCTIONS) AS SPECIALINSTRUCTIONS,
    ROW_NUMBER() OVER (PARTITION BY t.BUSNUMBER Order By s.LASTFIRST)AS RN
  FROM TRANSPORTATION t
    INNER JOIN STUDENTS s ON s.id=t.STUDENTID
    INNER JOIN U_StudentsUserFields u ON s.DCID = u.StudentsDCID
    INNER JOIN U_DEF_EXT_TRANSPORTATION x ON x.TRANSPORTATIONDCID=t.DCID
  WHERE s.ENROLL_STATUS =0
  AND t.fromto = 'To'
  ~[if#1.~(gpv.busnumber)=]
        /* NO bus number provided. */
        AND t.busnumber = 'zzz'
  [else#1]
      ~[if#2.~(gpv.busnumber)=ALL]
          AND t.busnumber LIKE '%'
      [else#2]
      /* Bus number provided. . */
      AND t.busnumber = ('~[gpv:busnumber]')
      [/if#2]
  [/if#1]
)
SELECT ID, BUSNUMBER,
       MONITORDETAIL, STUDENTLASTFIRST, GRADE, GENDER,
       HR_TEACHER,
       SPECIALINSTRUCTIONS
FROM(
   SELECT RN AS ID, BUSNUMBER,
          '&lt;font size=4&gt;' || BUSNUMBER || '&lt;/font&gt;&lt;br&gt;' || MONITOR   as MONITORDETAIL,
          '' AS STUDENTLASTFIRST, '' AS GRADE, '' AS GENDER,
          '' AS HR_TEACHER,
          '' AS SPECIALINSTRUCTIONS,
          'Group' As RowType
   FROM ROUTE WHERE RN = 1
   UNION ALL
   SELECT RN AS ID, BUSNUMBER,
          RN || '.' AS MONITORDETAIL,
          STUDENTLASTFIRST, GRADE, GENDER,
          HR_TEACHER,
          SPECIALINSTRUCTIONS,
          'Item' As RowType
   FROM ROUTE
)X
ORDER BY BUSNUMBER ASC
, CASE WHEN RowType='Group' THEN 0 ELSE 1 END ASC
, STUDENTLASTFIRST ASC
;]

  <tr>
    <td style="display:none"> ~(ID) </td>
    <td style="display:none"> ~(BUSNUMBER) </td>
    <td><strong> ~(MONITORDETAIL) </strong></td>
    <td> ~(STUDENTLASTFIRST)</td>
    <td> ~(GRADE)</td>
    <td> ~(GENDER)</td>
    <td> ~(HR_TEACHER)</td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td> ~(SPECIALINSTRUCTIONS)</td>
  </tr>

[/tlist_sql]

</table>
<!-- end of title and student content -->

</body>
</html>
Posted by at

Thursday, February 7, 2019

ThermalTake Tt esports Commander Mouse intermittently stops working in Linux Mint

So far nothing worked yet but I am making all attempt to document the things I have tried.
sudo sh -c "echo -1 > /sys/module/usbcore/parameters/autosuspend"


sudo apt-get install powernap
sudo powernap-action --disable usb_autosuspend
------
cat /etc/X11/xorg.conf
Section "InputClass"
    Identifier "Mouse Remap"
    MatchProduct "TT Esport Commander Mouse"
    MatchDevicePath "/dev/input/event*"
    Option "ButtonMapping" "1 2 3 4 5 6 7 8 9 10 11 12 0 0 0"
EndSection
Read more »
Posted by at

Madcatz Rat7 stops working intermittently in Linux Mint

This method works for sure for Linux Mint

 sudo mkdir /etc/X11/xorg.conf.d
sudo vi /etc/X11/xorg.conf.d/910-rat.conf

File includes:



Section "InputClass"

Identifier "R.A.T."

MatchProduct "R.A.T.7|R.A.T.9"

MatchDevicePath "/dev/input/event*"

Option "Buttons" "17"

Option "ButtonMapping" "1 2 3 4 5 0 0 8 9 7 6 12 0 0 0 16 17"

Option "AutoReleaseButtons" "13 14 15"

Option "ZAxisMapping" "4 5 6 7"

EndSection



sudo apt-get update

sudo apt-get upgrade

reboot

NOTE  Try these method: https://github.com/MayeulC/Saitek

Someone else suggested a simpler configuration and I have tried it.  It works fine.
 Section "InputClass"
        Identifier "R.A.T."
        MatchProduct "R.A.T.7|R.A.T.9"
        MatchDevicePath "/dev/input/event*"
Option    "ButtonMapping" "1 2 3 4 5 6 7 8 9 0 0 0 0 0"
EndSection

MOUSE SETTING
As for the single left click registered as a double click, there is a small middle button to control the speed of the mouse movement, click backward until the red light on the left side has only one lit bar

Also in combination with the mouse and trackpad setting: turn down the sensitivity of the double-click.

And the double-click timeout setting to very long.

It is still not perfect but tolerable.
Posted by at

Photoshop Installation on Linux Mint

There are many in between steps that are trial and error.  Look at logs and error message to figure out!
sudo apt-get install wine-stable ttf-mscorefonts-installer
Then run the following to create your own .wine folder.
winecfg
sudo apt install wine32 
 
Use PlayonLinux from the repository NOT from flatpak to install Photoshop CS6
Note: wine version 3.4 is called from the playonlinux script. 


Before accepting the EULA agreement, turn off the network to avoid creating an Adobe ID process
ifconfig
sudo ifconfig <interface> down
Posted by at